Microsoft Excel Masterclass (Advanced)

DURATION:
3 Days
ID:
TFA-00018
PRICE
₦150,000.00

Address

3, Allen Lane, Capable People Africa Building, Allen Lane, Ikeja, Lagos State.   View map

Categories

Excel , Microsoft

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

The participant will learn how:

  • 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

People who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel software.

Delegates would want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel.

This course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Consulting

Training

Software Development

Project Management

TERIBITE CONSULTING

We are a privately-owned business incorporated by the Corporate Affairs Commission of Nigeria to provide ready made and tailored I.T., Management, Financial and Branding Consulting services and solutions to a broad spectrum of clients.

Opening Hours

Monday – Friday: 8:00 am – 5:00 pm

Saturday, Sunday: Closed

CONTACT

Email: info@teribiteng.com
Telephone: (+234) 0803 358 8649, 0908 069 9264
Address: 3, Allen Lane, Capable People Africa Building Allen, Ikeja, Lagos, Nigeria

TOP