Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts.
What you will learn:
Create Formulas that add, subtract, multiply divide, etc:
- Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate percentages, figure out averages, etc.
- Learn how to copy Formulas.
Edit a Spreadsheet:
- Insert & Delete rows, columns, and sheets.
- Resize rows and columns.
- Add Headers, Footers, and Page Numbers to spreadsheet.
- Learn about various options to improve your printout.
- Split panes to view different parts of spreadsheet simultaneously.
- Freeze and Unfreeze panes to view titles while scrolling down a page.
- Make a title print out on every page, and more.
Build Different Spreadsheets:
- Add borders, patterns (background colors).
- Center, Bold, Italicize, change font/font size.
- Apply an AutoFormat that includes borders, patterns, and other formatting.
- Convert numbers to currency or percentages.
- Rename a spreadsheet, etc.
Charts:
- Create and edit a variety of different charts: Pie Charts and Column Charts.