This course is ideal for complete novices, those who have basic knowledge of Excel or are self-taught. The course will provide you with the skills you need to work quickly and produce functional and well formatted spreadsheets. This course is often used to benchmark Microsoft Excel skills and ensure a level of understanding for new hires at companies. Students will leave feeling confident about creating professional worksheets with the software and be able to navigate the interface intuitively and productively.

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.

• Working with the Excel Environment
• Title Bar
• Ribbon and Ribbon Tabs
• Quick Access Toolbar
• Worksheet Views
• Backstage View

• Understanding Cells
• Select a Cell
• Select a Cell Range
• Inserting Cell Content
• Deleting Cell Content
• Cutting & Pasting Cell Content
• Drag and Drop Cells
• Completing Series with Fill Handle

• Changing Column Width
• Changing Row Height
• Inserting & Deleting Columns and Rows
• Hiding & Showing Columns and Rows
• Wrapping Cell Text
• Merging Cells

• Font Type, Size, Color, and Decorations
• Cell Borders and Fill Colors
• Cell Alignment and Styles

• Number Formats
• Percentage Formats
• Date Formats

• Tables Overview
• Creating Tables
• Adding & Removing Data

• Pivot Tables Overview
• Creating Pivot Tables
• How Pivot Tables Work
• Slicing and Dicing

• Formulas Overview
• Mathematical Operators
• Cell References
• Creating Formulas
• Copying Formulas