Introduction to Microsoft Excel Training

• Writing simple formulas 
• Exploring audit tools to examine and evaluate formulas 
• Referencing cells in formulas using relative and absolute references 
• Configuring cells for the number format and alignment 
• Constructing common functions with the aid of the function wizard and the Formula tab 
• Implementing names in formulas and functions 

• Setting up initial cell formatting 
• Drawing attention to data with formatting 
• Working with templates - Protecting cell ranges and worksheets 
• Analysing data with conditional formatting 

• Importing data into Excel from various sources: text, web, Microsoft Access, SQL (Structured Query Language) Server 
• Transforming data with global replace and data tools 
• TEXT and DATE functions 
• 2013 Flash Fill assistant 
• Setting WISE (Written, Integrated, Synergistic, and Expansive) goals 

• Subtotaling a Filtered list with the subtotal command 
• Implementing Tables and Table Formulas 
• Subtotaling a table with the Total Row 
• Filtering Tables with Slicers 

• Leveraging charts to create a visual presentation 
• Creating charts using wizards 
• Adjusting chart settings, including titles, labels, and chart types 
• Working with Views of the spreadsheet 
• Setting up your workbook for printing 

• Implementing dates 
• Summarising data from other worksheets with 3-D formulas 
• Designing IF functions and conditional formatting 
• Analysing summary data with Pivot tables and slicers 

Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.

Module 1: Introduction to Microsoft Excel

• Working with cell ranges—navigating and selecting cells with the mouse and keyboard
• Entering and editing data
• Employing AutoFill to enter data
• Inserting and deleting rows, columns, or cells
• Adjusting column width and row height
• Manipulating data with cut, copy, paste, with the clipboard, or by dragging the mouse
• Leveraging multiple worksheets

Module 2: Formulas and Functions

• Writing simple formulas
• Exploring audit tools to examine and evaluate formulas
• Referencing cells in formulas using relative and absolute references
• Configuring cells for the number format and alignment
• Constructing common functions with the aid of the function wizard and the Formula tab
• Implementing names in formulas and functions

Module 3: Worksheet Formatting and Presentation

• Setting up initial cell formatting
• Drawing attention to data with formatting
• Working with templates - Protecting cell ranges and worksheets
• Analysing data with conditional formatting

Module 4: Getting Data In and Out

• Importing data into Excel from various sources: text, web, Microsoft Access, SQL Server
• Transforming data with global replace and data tools
• TEXT and DATE functions
• 2013 Flash Fill assistant

Module 5: Sorting, Selecting and Subtotaling data

• Subtotaling a Filtered list with the subtotal command
• Implementing Tables and Table Formulas
• Subtotaling a table with the Total Row
• Filtering Tables with Slicers

Module 6: Present Data Visually

• Leveraging charts to create a visual presentation
• Creating charts using wizards
• Adjusting chart settings, including titles, labels, and chart types
• Working with Views of the spreadsheet
• Setting up your workbook for printing

Module 7: Introducing Advanced Features

• Implementing dates
• Summarising data from other worksheets with 3-D formulas
• Designing IF functions and conditional formatting
• Analysing summary data with Pivot tables and slicers