microsoft excel training

BASIC, INTERMEDIATE AND ADVANCED MICROSOFT EXCEL TRAINING WORKSHOP

Course Objectives/Deliverable

INTERMEDIATE MICROSOFT EXCEL WORKSHOP OBJECTIVES

Welcome to the Microsoft Excel Training workshop. Microsoft Excel is the world’s premier spreadsheet software. You can use Microsoft Excel to analyze numbers, keep track of data, and graphically represent your information. It also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information and therefore, better information leads to better decision making!

DELIVERABLE

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. With that in mind, let’s review our goals for this course.

At the end of this Training Workshop, you should be able to:

  • Open and create Excel workbook files
  • Use the 2013 interface
  • Enter and edit data in a variety of ways
  • Understand basic formulas and functions
  • Use the Quick Analysis features new to the 2013 version Format worksheets and data
  • Print and share workbooks
  • Inclusive of training material and certificate of attendance

Course Preview

INTERMEDIATE MICROSOFT EXCEL COURSE OUTLINES

Day 1

  • Module One: Getting Started
  • Module Two: Opening Excel
  • Module Three: Working with the Interface
  • Module Four: Your First Worksheet
  • Module Five: Viewing Excel Data
  • Module Six: Building Formulas
  • Module Seven: Using Excel Functions

Day 2

  • Module Eight: Using Quick Analysis
  • Module Nine: Formatting Your Data
  • Module Ten: Using Styles, Themes, and Effects
  • Module Eleven: Printing and Sharing Your Workbook
  • Module Twelve: Wrapping Up

Course Fee

Course Fee: N80,000

Training Schedule/Application

  • TRAINING SCHEDULE

     

    MONTH DATE LOCATION DURATION
    APRIL 27, 28 Lagos & PH 2 Days
    MAY 25, 26 Lagos & PH 2 Days
    JUNE 29, 30 Lagos & PH 2 Days

APPLICATION FORM

MrMrsMiss

Course Objectives/Deliverable

ADVANCED MICROSOFT EXCEL TRAINING

In this course the participants will learn the expert features and functions in Microsoft Excel 2013 to help them get beyond the basics and have advanced-level proficiency within the Excel 2013 suite.

This course exposes several advanced features of Microsoft Excel for What-if analysis, database analysis and how to build calculations, using advanced functions as well as how to automate processes.

This course covers:

  • Using advanced graphs and presentation techniques to maximise impact.
  • How macros and VBA automate your spreadsheets and increase interactivity
  • How superpower functions can solve complex problems
  • Using PivotTables and Power Pivots to turn raw data into clear information that supports key decisions

DELIVERABLE

Participants should be able to use Microsoft Excel to:

  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry and build complex models with Lookup functions
  • Analyze data with simple PivotTables and PivotCharts
  • Create and modify Macros

DELIVERABLE

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. With that in mind, let’s review our goals for this course.

At the end of this Training Workshop, you should be able to:

  • Open and create Excel workbook files
  • Use the 2013 interface
  • Enter and edit data in a variety of ways
  • Understand basic formulas and functions
  • Use the Quick Analysis features new to the 2013 version Format worksheets and data
  • Print and share workbooks
  • Inclusive of training material and certificate of attendance

Course Preview

ADVANCED MICROSOFT EXCEL COURSE OUTLINES

Day 1

  • Module 1 Setting Excel Options
  • Module 2 Good Spreadsheet design
  • Module 3 Advanced formula construction
  • Module 4 Excel Functions for advanced users
  • Module 5 Look-up functions
  • Module 6 Understanding Reference Functions
  • Module 7 Charts and Chart Object Formatting
  • Module 8 Labels and Names
  • Module 9 Protecting Data

Day 2

  • Module 11 Data Linking
  • Module 12 Data Consolidation
  • Module 13 PivotTables
  • Module 14 Pivot Table Techniques
  • Module 15 Pivot Charts
  • Module 16 Goal Seeking
  • Module 17 Grouping and Outlining
  • Module 18 Introduction to Excel Macros
  • Module 19 Introductory Excel VBA Automation
  • Module 20 Building dashboards and Management Reports

Course Fee

Course Fee: N100,000

Training Schedule/Application

  • TRAINING SCHEDULE

     

    MONTH DATE LOCATION DURATION
    APRIL 27, 28 Lagos & PH 2 Days
    MAY 25, 26 Lagos & PH 2 Days
    JUNE 29, 30 Lagos & PH 2 Days

APPLICATION FORM

MrMrsMiss