a

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

Image Alt

Microsoft Excel (Advanced)

  /    /  Microsoft Excel (Advanced)
MonthDateDurationCostLocationMake a Booking
January20th -25th5 Days₦ 341,500Port HarcourtClick to Book
February3rd -8th5 Days₦ 262,500LagosClick to Book
March4th- 8th5 Days₦ 262,500LagosClick to Book
April15th-19th5 Days₦ 262,500LagosClick to Book
May4th -8th5 Days₦ 262,500LagosClick to Book
June8th-12th5 Days₦ 262,500LagosClick to Book
July13th-17th5 Days₦ 341,500AbujaClick to Book
August17th-21th5 Days₦ 341,500Port HarcourtClick to Book
September7th- 11th5 Days₦ 341,750Port HarcourtClick to Book
October5th-9th5 Days₦ 341,500Port HarcourtClick to Book
November9th-13th5 Days₦ 341,750AbujaClick to Book
MonthDateDurationCostLocationMake a Booking
June17th -19th3 Days₦ 204,750AbujaClick to Book
July8th-10th3 Days₦ 204,750Port HarcourtClick to Book

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