1 / 24

Day 3 Excel chapter 1

Day 3 Excel chapter 1 . Nitin Chowdary Are Nitin.Are @mail.wvu.edu Jan 23 rd ,2013. Attendance starts from today. During the scheduled class time, from a lab PC (not a laptop), students must go to Course Tools > Record Attendance on CS101.wvu.edu to record their attendance.

tobias
Download Presentation

Day 3 Excel chapter 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Day 3Excel chapter 1 NitinChowdary Are Nitin.Are@mail.wvu.edu Jan 23rd ,2013

  2. Attendance starts from today. • During the scheduled class time, from a lab PC (not a laptop), students must go to Course Tools > Record Attendance on CS101.wvu.edu to record their attendance.

  3. Upcoming due dates… • MYITLAB Lesson A : Jan 28th • Homework #1 : Feb 8th

  4. Mathematics and Formulas • Managing workbook and worksheet • Formatting • Page Setup and Printing

  5. Mathematics and formulas

  6. Basic mathematics • Covered in last class • Arithmetic operators • Using Order of precedence • Using AutoFill

  7. How to enter a formula ? • Two ways • Directly • Using “ INSERT FUNCTION”

  8. Lets do an example • A1 – “ OK Office Systems Pricing Information” • A2 – “1/23/2013” • A4 – “Product” • B4 – “Cost” • C4 – “Markup Rate” • D4 – “Retail Price” • E4 – “Percent Off” • F4 – “Sale Price” • G4 – “Profit Margin”

  9. Lets do an example E B C • A5 – “Computer” • A6 – “Printer” • A7 – “Filing Cabinet” • A8 – “Desk Chair” • A9 – “Computer Desk” • A10 – “Monitor” • 0 • 0.2 • 0.1 • 0.25 • 0.3 • 0.1 • 0.5 • 0.75 • 0.905 • 1 • 1.857 • 0.835 • 400 • 457.7 • 68.75 • 75 • 700 • 195

  10. 1.Finding RETAIL PRICE • Formula : Cost*(Markup rate + 1) • Click D5 cell and enter formula and press ENTER. • AutoFill the formula by dragging along the column.

  11. 2.Finding sale price • Formula : Retail Price – (Retail Price * Percent Off) • Click F5 and enter the formula and press ENTER. • AutoFill the formula by dragging along the column.

  12. 3.Finding Profit margin • Formula : (Sale Price – Cost)/Sale Price • Click G5 and enter the formula and press ENTER. • AutoFill the formula by dragging along the column.

  13. That’s it ….

  14. Managing workbook and worksheet

  15. Rename worksheet (3 ways) • Double click on sheet tab and enter new name. • Click on ‘Format’ option in cell sectionin home ribbon and select ‘Rename Sheet’. • Right click on sheet tab and select ‘Rename’. • Change Worksheet Tab Color (2 ways) • Click on ‘Format’ option in cell sectionin home ribbon and select ‘Tab Color’. • Right click on sheet tab and select ‘Tab Color’ .

  16. Insert Worksheet (4 ways) • Using icon. • Using ‘Insert’ option in ‘cells’ sectionof ‘home’ ribbon. • Right click on ‘worksheet tab’ and select ‘Insert’ option. • Using ‘Shift+F11’ shortcut. • Delete Worksheet (2 ways) • Using ‘Delete’ option in ‘cells’ section of ‘home’ ribbon. • Right click on ‘worksheet tab’ and select ‘Delete’ option.

  17. Move worksheet • Click ‘sheet tab’ and drag to desired position. • Copy worksheet • Using ‘Move or Copy Sheet’ option in ‘cells’ section (Format) of ‘home’ ribbon.

  18. Managing Columns and Rows • Insert cells, columns, and rows (2 ways) • Delete cells, columns, and rows (2 ways) • Adjust column width • Adjust row height • Hide and unhide columns and rows (2ways)

  19. formatting

  20. Font options in home ribbon • Font type • Font size • Increase/decrease font size • Bold ( Ctrl+B ) • Inclined ( Ctrl+I ) • Underline ( Ctrl+U ) • Border • Fill color ( fills the cell background with selected color) • Font Color

  21. Alignment options in home ribbon • Top/Middle/Bottom Align • Orientation • Wrap text ( makes text visible on multiple lines within cell) • Left/Center/Right Align • Increase/Decrease Indent • Merge cells

  22. Number options in home ribbon • Number Format • Accounting number format • Percent Style (Ctrl+Shift+%) • Comma Style (Displays with a thousands separator) • Increase / Decrease decimal value.

  23. Page setup and printing • Click ‘Page Setup Dialog Box Launcher’ in ‘Page Setup’ sectionof ‘Page Layout’ tab in ribbon. • Specify Page Options. • Specify Margins Options. • Create Header and Footers. • Select Sheet Options. • Printing a Worksheet.

More Related