COURSE OUTLINE

This class is designed for the beginner who wants to learn how to building a spreadsheet from scratch using basic formulas.  Have you been using a spreadsheet that someone else designed but you don’t know how they created the formulas?  In the class you will learn how to:

EXCEL BASICS

• Navigate the Excel Environment 
• Enter and Edit data
• Learn shortcuts for basic tasks

CREATING A SPREADSHEET

• Create Basic Formulas that add, subtract, multiple or divide
• Learn to Work with Functions such as =sum() and =average()
• Move and Copy Data
• Insert rows and columns
• Move and Copy Data – Understand the Clipboards
• Use Fill Series
• Adjust Column Width and Row Height

FORMATTING TECHNIQUES

• Use the Ribbon to format cells
• Work with the Dialog Launcher and Dialog Boxes
• Use Number and Text Alignment
• Learn the various number formats
• Learn to Copy or Repeat Formats
• Work with Format Painter

PRINTING SOLUTIONS

• Learn Tips and Tricks for Printing
• Understand the Page Setup options
• Create and Set Print Areas

Work with Printing Problems