a

Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

Image Alt

Microsoft Excel (Advanced)

  /    /  Microsoft Excel (Advanced)

Microsoft Office contains a variety of tools that help people accomplish many personal and professional objectives. Microsoft Excel is perhaps the most versatile and widely used of all the Office applications. No matter which career path you choose, you will likely need to use Excel to accomplish your professional objectives. In this course, the participant will be introduced to the more advanced features of Microsoft Excel.

  • 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.
  • 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
Course Overview

Microsoft Office contains a variety of tools that help people accomplish many personal and professional objectives. Microsoft Excel is perhaps the most versatile and widely used of all the Office applications. No matter which career path you choose, you will likely need to use Excel to accomplish your professional objectives. In this course, the participant will be introduced to the more advanced features of Microsoft Excel.

Learning Objectives
  • 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.
Program Outline
  • 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
Target Audience
  • Management Trainee
  • Specialist Staff
  • Managers
  • Management Staff and Directors

Call Me Back