Excel 2013 Essentials

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making! 

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

Course Outline

Module One: Getting Started

•     Workshop Objectives

Module Two: Opening Excel

•     Opening Excel
•     Using the Recent List
•     Opening Files
•     Creating a Blank Workbook
•     Creating a Workbook from a Template
•     Module Two: Review Questions

Module Three: Working with the Interface

•     Understanding the Ribbon and the Status Bar
•     About Your Account
•     Using Backstage View
•     Understanding Worksheets vs. Workbooks
•     Closing Files
•     Closing Excel
•     Module Three: Review Questions

Module Four: Your First Worksheet

•     Entering Data
•     Using Flash Fill
•     Using Auto Fill
•     Editing Data
•     Adding Rows and Columns
•     Checking Your Spelling
•     Module Four: Review Questions

Module Five: Viewing Excel Data

•     An Overview of Excel’s Views
•     Switching Views
•     Creating Custom Views
•     Using Zoom
•     Switching Between Open Files
•     Module Five: Review Questions

Module Six: Building Formulas

•     The Math Basics of Excel
•     Building a Formula
•     Editing a Formula
•     Copying a Formula
•     Relative vs. Absolute References
•     Using the Status Bar to Perform Calculations
•     Module Six: Review Questions

Module Seven: Using Excel Functions

•     Formulas vs. Functions
•     Using AutoComplete
•     Using the SUM Function
•     Using Other Basic Excel Functions
•     Understanding the Formulas Tab
•     Understanding the Function Names
•     Module Seven: Review Questions

Module Eight: Using Quick Analysis

•     Formatting Tables
•     Creating Quick Analysis Charts
•     Calculating Totals
•     Creating Quick Analysis Tables
•     Using Sparklines
•     Module Eight: Review Questions

Module Nine: Formatting Your Data

•     Changing the Appearance of Text
•     Changing the Appearance of Numbers
•     Working with Alignment Options /Using the Wrap Command/Using Merge
•     Removing Formatting
•     Module Nine: Review Questions

Module Ten: Using Styles, Themes, and Effects

•     Using Conditional Formatting
•     Using Table Styles
•     Using Cell Styles
•     Formatting Cells
•     An Overview of the Page Layout Tab
•     Changing the Theme
•     Module Ten: Review Questions

Module Eleven: Printing and Sharing Your Workbook

•     Setting up Your Page
•     Previewing and Printing Your Workbook
•     Inviting People
•     E-Mailing Your Workbook
•     Module Eleven: Review Questions