BRIEF PROGRAM OVERVIEW

Microsoft Excel is one of the most used Math software packages in the world. It is an extremely powerful tool and easy to use once the user knows how to perform the many functions available. This training program will teach you how to use Excel 2013 through the practical session.  Every session teaches you the core functionality of Excel with real-world example spreadsheets, formulas, and charts.

 

First, you’ll get an overview of excel and a tour of the user interface.  Next, you’ll master entering data, performing calculations, formulas, formatting cells, charts, filtering data, and much more!

 

This advanced Excel training course is perfect for beginners and for intermediate users who want to better understand and make the most of Excel’s many features and functions. It’s also a great supplemental class for advanced users interested in learning additional Excel tips and shortcuts.

Who should attend?

This program is intended for anyone interested in using Microsoft Excel like a pro. It is recommended for Accountants, Financial Analysis, Business Managers, Entrepreneurs and young University Graduates. It’s a must for every organization that takes data flow management serious.

TRAINING PACK 

  • Award of Certificate of Proficiency.
  • Professional Training Manual
  • 30days On- going mentorship guide.
  • Training materials

Excel Intermediate Course Outline:

Module One: Getting Started

             Housekeeping Items

             Pre-Assignment Review

             Workshop Objectives

Module Two: SmartArt and Objects

             Inserting SmartArt

             Editing the Diagram

             Adding Pictures

             Adding Text Boxes

             Drawing Shapes

             About the Contextual Tabs

Module Three: Auditing

             Tracing Precedent cells

             Tracing the Dependents of a Cell

             Displaying Formulas Within the Sheet

             Adding, Displaying, Editing ,and Removing Comments

Module Four: Creating Charts

             Using Recommended Charts

             Inserting a Chart

             Overview of the Chart Tools Tabs

             Understanding the Parts of a Chart

             Resizing and Moving the Chart

Module Five: Working with Charts

             Using Chart Elements

             Using Chart Styles and Colors

             Changing the Chart Style

             Using Chart Filters

             Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

             Inserting a PivotTable using Excel Recommendations

             Choosing Fields and Grouping Data

             Overview of the Pivot Table Tools Tabs

             Changing the Data Displayed and Refreshing the PivotTable

             Creating a Pivot Chart from a Pivot Table or Data

             Some Real-life Examples

Module Seven: Macros

             Displaying the Developer Tab

             Recording and Running Macros

             Changing the Security Level

             Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

             Using Named Ranges

             Understanding Formula Errors

             Using the Trace Errors Commands

             Using Error Checking

             Evaluating Formulas

Module Nine: Using What If Analysis

             Using Goal Seek

             Using the Scenario manager

             Using a One Input Data Table

             Using a Two Input Data Table

Module Ten: Managing Your Data

             Transposing Data from Rows to Columns

             Using the Text to Columns Feature

             Checking for Duplicates

             Creating Data Validation Rules

             Consolidating Data

Module Eleven: Grouping and Outlining Data

             Grouping Data

             Adding Subtotals

             Outlining Data

             Viewing Grouped and Outlined Data

Excel Expert Course Outline:

Module One: Working with Permissions and Options

             Marking a Workbook as Final

             Encrypting with a Password and Restricting Permissions

             Protecting the Current Sheet or the Workbook Structure

             Adding a Digital Signature

             Setting Excel Options

             Managing Versions

             Saving a Workbook as an Excel Template

Module Two: Sharing Workbooks

             Inspecting a Document

             Sharing a Workbook

             Editing a Shared Workbook

             Tracking Changes

             Merging Copies of a Shared Workbook

Module Three: Performing Advanced Formula and Function Tasks

             Using the Watch Window

             About the Excel Calculation Process

             Setting Calculation Options

             Enabling or Disabling Automatic Workbook Calculations

             Using the IFERROR Function to Evaluate Formulas

Module Four: Working with Array Formulas

             About Array Formulas

             Creating One-Dimensional and Two-Dimensional Constants

             Creating a Simple Array

             Creating an Advanced Array

Module Five: Working with Macros

             Assigning a Macro to a Command Button

             Running a Macro by Clicking an Area of a Graphic Object

             Configuring a Macro to Run Automatically Upon Opening the Workbook

             Changing a Macro

Module Six: Working with Forms

             About Excel Forms, Form Controls, and Active X Controls

             Using a Data Form

             Using a List Box Control

             Using a Combo Box Control

             Using a Spin Button Control

             Using a Scroll Bar control

Module Seven: Applying Advanced Chart Features

             About Trend Lines

             Add a Trend Line

             Using Secondary Axes

             Using Chart Templates

Module Eight: Working with PivotTables and Pivot Charts

             Working with PivotTable Tools

             Working with PivotChart Tools

             About Slicers

             Creating a Slicer in an Existing PivotTable

             Creating a Standalone Slicer

             Formatting a Slicer

             Sharing Slicers with Another PivotTable

             Disconnect or Delete a Slicer

Module Nine: Working with Power View

             About Power View

             Creating a Power View Sheet

             Connecting to Different Data Modules in One Workbook

             Modifying the Data Model without Leaving the Power View Sheet

             Using Drill Down, Drill Up, and Cross Drill

Module Ten: Working with Multiple Tables in Data Analysis

             Using Multiple Tables in Your Data Analysis

             Connection to Additional Data Sources

             Creating Relationships between Tables

             Using a Timeline to Show Data for Different Time Periods

DURATION:

3 DAYS

DATE:

14th – 16th February 2018

TIME:

9:00am

ACCOUNT DETAILS:

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

REGISTRATION PROCEDURE

  1. Pay the registration fee on or before registration deadline date(at least a week before class commencement date)
  2. Send your name, phone number, email address, training location, amount paid to training@successdrives.net or SMS to 08096662323, 08107922921
  3. Visit www.successdrives.net click on register now tab and complete Registration Form.
  4. Upon confirmation of your registration an electronic receipt will be sent to your mail.
  5. Pay the tuition on or before the tuition deadline
  6. Commence your training at SuccessDrives Training Facility

ACCOUNT DETAILS

Bank: First City Monument Bank Plc (FCMB)

Account Name: SuccessDrive Global Consult Ltd

Account Number: 246 809 3010

""
1
Fill the Fields below to register for a Course
First Name
Last Name
Phone Noyour full name
Organization
Organization Websiteyour full name
Organization Addressyour full name
Other Informationmore details
0 /
Previous
Next