The course is a combination of Microsoft Excel Basic and Intermediate and Advanced

Click to read more about Microsoft Excel Basic

Click to read more about Microsoft Excel Intermediate

Click to read more about Microsoft Excel Advanced

Microsoft Excel Basic

• Indicate the names and functions of the Excel interface components
• Enter and edit data
• Format data and cells
• Construct formulas, including the use of built-in functions, and relative and absolute references
• Create and modify charts
• Preview and print worksheets
• Use the Excel online Help feature

Microsoft Excel Intermediate

• Create pivot tables and charts
• Learn to trace precedents and dependents
• Convert text and validate and consolidate data
• Collaborate with others by protecting worksheets and workbooks
• Create, use, edit, and manage macros
• Import and export data

Microsoft Excel Advanced

• Filter and generate reports from Excel data
• How to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek
• How to create macros to automate some repetitive tasks
• How to protect worksheets and workbooks
• How to manage and analyze data efficiently with Microsoft Excel.

Microsoft Excel Basic

Intro Section:

• Workplace Intelligence
• The Benefits
• The Staff and The Workplace
• Common Mistakes
• Workplace Intelligence: An Overview.

Part One:

• Workplace Dynamics
• When You Left For Work This Morning, What Did You Leave Behind?
• Hostile Working Environment
• Four Generations At Work
• Values And Generational Feedback
• Generational Interaction In The Workplace.

Part Two:

• What Is Organizational Culture?

Exploring Excel

• Finding and using commands
• Moving around a worksheet
• Navigating the workbook

Basic Workbook Skills

• Creating a workbook
• Selecting cells and ranges
• Opening, closing and saving workbooks
• Entering data into cells
• Entering values into ranges

Creating Simple Formulas

• Writing formulas in cells
• Using the Formula Bar
• AutoSum and other basic functions
• The Paste Function tool
• Automatic calculation

Copying And Moving Data

• Copying and cutting data
• Absolute cell references
• Filling cells
• Using drag-and-drop
• Undo and Redo
• Find and Replace

Managing Worksheets

• Naming worksheets
• Copying and moving worksheets
• Grouping worksheets
• Moving data between sheets
• Adding and deleting worksheets
• Creating 3-D formulas

Printing

• Choosing what to print
• Previewing and printing
• Page Setup
• Margins and page orientation
• Headers and footers
• Repeating column/row headings
• Page Break Preview
• Printing gridlines

Formatting Data And Cells

• Formatting numbers
• Formatting text
• Colouring data and cells
• Wrapping and shrinking text
• Merging cells
• Using indents
• Applying borders to cells
• The Format Painter
• Conditional formatting

Working With Columns and Rows

• Selecting columns and rows
• Changing column width and row height
• Hiding and unhiding
• Inserting and deleting

Using Large Spreadsheets

• Changing the magnification
• Full Screen view
• Splitting the window
• Using Freeze Panes

Named Ranges

• Naming a range of cells
• Jumping to a named range
• Using range names in formulas
• Re-defining and deleting range names

Working With Data Series

• Creating a linear series
• Working with Date series
• Using Autofill

Microsoft Excel Intermediate

WORKING WITH FUNCTIONS

• Using the Paste Function tool
• Absolute and relative cell references
• Using range names in functions
• Creating nested functions
• Logical functions (SUMIF, COUNTIF)
• The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
• Financial functions (PMT, NPV)

WORKING WITH DATA

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool
• Database functions
• Using the Data Form to enter data
• Creating subtotals

WORKING WITH EXTERNAL DATA

• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web

CHARTING WITH EXCEL

• Selecting the data to chart
• Creating a chart
• Choosing the right chart for the job
• Moving and re-sizing charts
• Customizing charts
• Saving and copying a chart’s design

TABLES

• Creating an Excel table
• Table formatting
• Adding rows and columns
• Automatic calculation in tables

COLLABORATION TOOLS

• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks
• Tracking changes

AUDITING WORKBOOKS

• Viewing formulas
• Tracing precedents and dependents
• Error checking

Microsoft Excel Advanced

• Advanced Excel Formulas and Useful Functions
• Text to Column
• Flash fill
• Sorting with Slicer
• Lookup Functions
• Statistical Functions
• Database Functions
• Index
• Text function/operation
• Referencing
• Cell Comments and Cell Referencing
• What if Analysis
• Data Table
• Pivot Tables
• Grouping & Subtotal
• Data Consolidation and Data Validation
• Linking Files and Worksheets
• Worksheet Protection
• Share Workbook
• Formula Editing
• Error Tracing
• Custom Number Formatting
• Tracking Changes
• Hyperlink
• Importing Data
• Introduction to Macros
• Advanced Charts and Graphs
• Advanced Printing
• Cheat Sheet Handout

• Management Trainee
• Specialist Staff
• Managers
• Management Staff and Directors