Excel Beginning

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.