Habanero Data Solutions

Excel Essentials

Organise format and calculate data
Approved by Habanero Data
Excel
next available COURSE:
Duration :
3 Day/s
DURATION
3 Day/s
USD $
650
USD
$ 650
NGN ₦
250,000
NGN
₦ 250,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

About this course:This 3 day course will give delegates a thorough study on using Microsoft Excel.
 
Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects
 
Recommended Prerequisites: None
 
Course Schedule: 5 Days, 40 Academic Hours
 

Course Syllabus:
 
Day 1

Getting Started with Microsoft Excel

  • Starting Out
  • About Workbooks
  • Exploring your Workbook
  • Getting Help with Excel

 
Getting to grips with the basics

  • The Excel Interface
  • Using Backstage View
  • Understanding the Ribbon
  • Using & customising the Quick Access toolbar
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab
  • Using shortcuts

 
Organising Your Workbooks effectively

  • Create, save & open a new Workbook
  • Entering numbers & text in a Workbook
  • Adding, deleting & naming sheets

 
Entering Data into Spreadsheets

  • Inserting Cells, Columns & Rows
  • Deleting Cells, Columns & Rows
  • AutoFill & using SmartTags

 
Presenting Your Data

  • Font formatting
  • Borders & Shading
  • Number formatting (currency etc)
  • Alignment options
  • Clearing formats
  • Applying cell styles
  • Formatting shortcut

 
Defining & Creating Calculations

  • Writing a basic formula
  • Understanding the order of BODMA
  • The Sum function & AutoSum
  • Creating statistical functions (Average, Max and Min)
  • An introduction to the Function Wizard

 
Advanced File Tasks

  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility

 
Working with Functions and Formulas

  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions

 
Managing Tables in Microsoft Excel

  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

 
Data Tools in Excel

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

 
How to do more with Charts in Excel

  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting

 
Day 2

Sparklines

  • Creating Sparklines
  • Editing Sparklines

 
Grouping & Outlining and Subtotals

  • Outlining and Grouping Data
  • Using the Subtotals Tool

 
What-If Analysis

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

 
PivotTables

  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers

 
Charting Pivoted Data

  • Getting Started with Pivot Charts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

 
Advanced Excel Tasks

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

 
Creating HLOOKUP and VLOOKUP Functions

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

 
Introduction to Macros in Excel

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

 
Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting

 
Using Form Controls and Templates

  • Using Form Controls
  • Creating Templates

 
Advanced Lookup Functions

  • Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function

 
Advanced Functions in Excel

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

 
Advanced Pivot Table Tools

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

 
Introduction to User Defined Functions Using VBAs

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in

 
Day 3

Recording and Running Macros in Excel

  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolba

 
Introduction to User Defined Functions Using VBAs

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in

 
Recording and Running Macros in ExcelVBAs

  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar

 
Introduction to the Excel VBA Editor

  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros

 
Creating Procedures and Functions

  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User

 
Working with the Excel Object Model

  • Understanding Objects, Properties and Methods
  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using the Resize Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets

 
Controlling Program Flow

  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

 
Advanced Procedures

  • Calling Procedures
  • Passing Values to Procedures

 
Advanced Variables

  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables

 
Interacting with Office Applications

  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word

 
Debugging and Error Traps

  • Review of Error Types
  • Debugging tools
  • Setting Error Traps

 
Creating Custom User Forms

  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures

 
Workbook and Worksheet Events

  • Create Workbook Events
  • Create WorkSheet Events

Our international certified trainers have highly experienced Excel practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Microsoft PowerBI.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

For more information on our training, please enquire using the form above or call +2348103382376

Excel Essentials

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    Excel Essentials

    Available Dates

    Available Places

    Book or Enquire

    July 12, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +234 8103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.