- A basic understanding of Microsoft Windows
MODULE 1: Getting Started with Microsoft Excel
Learning outcomes: Starting Excel and some of its basic navigation and help controls.
Topics covered:
- Starting Out
- About Workbooks
- Exploring your Workbook
- Getting Help with Excel
MODULE 2: The Excel Interface
Learning outcomes: A look at the Ribbon interface and the different tabs and options the Ribbon offers.
Topics covered:
- The Quick Access Toolbar and File Menu
- The Home Tab
- The Insert Tab
- The Page Layout Tab
- The Formulas Tab
- The Data Tab
- The Review Tab
MODULE 3: Microsoft Excel Basics
Learning outcomes: Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.
Topics covered:
- Working with Excel
- Moving your Data
- Basic Excel Features
- Smart Tags and Options Buttons
- Editing Tools
MODULE 4: Editing your Workbook
Learning outcomes: Understanding formatting features and enhancing a workbook’s overall appearance and using Conditional Formatting.
Topics covered:
- Cell Formatting
- Conditional Formatting
- Enhancing a Worksheet’s Appearance
MODULE 5: Printing and Viewing your Workbook
Learning outcomes: Exploring Excel’s printing and viewing options enhancing your ability to print and work with your data effectively.
Topics covered:
- Using the View Tab
- Managing a Single Window
- Managing Multiple Windows
- Printing your Workbook
- Print Page Layout options
MODULE 6: Working with Charts in Excel
Learning outcomes: Introducing charts within Excel and explain how to create basic charts to help convey your data with.
Topics covered:
- Using Recommended and Standard Charts
- Chart Elements
- Chart Tools – Design & Format
- The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.