Microsoft Excel Training Courses in Harare
Microsoft Excel training courses which we offer are organised in to 3 levels so as to allow individuals to start at the level which suits their current competency with Excel. While those who are new to Excel need to start at beginner level experienced users may start at either intermediate or advanced level depending on their prior knowledge. The competencies which are taught at each level are outlined in detail in the course outlined which are provided here. Click the particular link to find out what is taught at each level. You are free to talk to our consultants to determine which is the best level for you to start with.
- Beginner Microsoft Excel Training Course
- Intermediate Microsoft Excel training Course
- Advanced Microsoft Excel Training Course
- Microsoft Excel Data Analysis Training Course
- Training process
- Design
- Training methodology
Contact us to enrol or enquire
Beginner to Advanced Microsoft Excel Training Courses will take you from zero to hero in no time!
Beginner Microsoft Excel Training Course
Course Duration: 1 Day
Who is this course for?
Microsoft Excel training courses start with beginners’ level. This course is intended for participants who wish to gain the foundational understanding of Microsoft Excel that is necessary to create and work with electronic spreadsheets. if you are working with Microsoft Excel for the first time this is the best level to start from. Current users may also still benefit as you will be exposed to some elements which you may not be aware of despite being an experienced user.
Pre-requisites
Basic knowledge of Windows is essential with the following pre-requisites:
- Possession of mouse control skills, including the ability to point, click, drag, and double-click.
- Capability to make use of the Control Panel
- Having the ability to resize and move the Application Windows
- Having the ability to transition between different applications and tasks
Benefits
Upon completion of this program, participants should be able to:
- Get started with Microsoft Excel Application
- Identify the elements and interface of Excel
- Preform calculations and use basic formulas and functions
- Modify worksheets and format worksheets
- Print and manage large workbooks
Key Content
Unit 1 – Getting Started with Microsoft Excel
Topic A – Identify the elements of the Excel interface
- What are spreadsheet, worksheet and workbook
- What are columns, row, cells, and ranges
- The Excel interface
- Navigation Options
Topic B – Creating a new blank workbook
- Create a basic worksheet
- The ribbon
- The backstage view
- Save and save as commands
Unit 2 – Performing Calculations
Topic A: Create formulas in a worksheet
- Excel formulas
- The formula bar
- Elements of an excel formula
- Common mathematical operators
- The order of operations
- Division formula
Unit 3 – Modifying a Worksheet
Topic A: Manipulating Data
- The undo and redo commands
- The Auto Fill feature
- Auto Fill options
- The Transpose option
- Live preview
- The Clear button
Topic B: Insert, Manipulate, and Delete Cells, Columns and Rows
- The Insert and Delete options
- Column Width and Row Height alternation methods
- The Hide and Unhide options
Topic C: Search for and Replace data
- The Find command
- The Replace command
- The Go To command
Topic D: Spell Check a worksheet
- The Spelling dialog box
Unit 4 – Formatting a Worksheet
Topic A: Modify Fonts
- Fonts
- The Font Group
- The Format Cells dialog box
- The Format Painter
- Live Preview and Formatting
- The mini toolbar
Topic B: Add borders and colours to cells
- Border Options
- Fill Options
Topic C: Apply Number Formats
- Number formats
- Dragging and dropping cells
- How to cut, copy and paste cells
- How to cut, copy and paste multiple cells
- Using the Clipboard
- Using Paste Special
- Number formats in Excel
- Custom number formats
Topic D: Align Cell Contents
- Alignment Options
- The Indent Commands
- Orientation Options
- The Merge and Centre Options
Unit 5 – Printing Workbook Contents
Topic A – Define the Basic Page Layout for a Workbook
- The Print Options in Backstage View
- The Page Setup Dialog Box
- The Print Preview Option
- Headers and Footers
- Page Margins
- Margins Tab Options
- Page Orientation
Topic B – Refine the Page Layout and Apply Print Options
- Zoom Options
- Page Breaks
- Page Breaks Options
- The Print Area
- Print Titles
- Scaling Options
Unit 6 – Managing Large Workbooks
Topic A – Format Worksheet Tabs
- Renaming Worksheet Tabs
- Changing Tab Colour
Topic B – Manage Worksheets
- Repositioning Worksheets
- Inserting or Deleting Worksheets
- Hiding and Unhiding Worksheets
- Worksheet References in Formulas
Methodology
Informative presentation, group discussion and presentations, hands on practical session
Contact us to enrol or enquire
Intermediate Microsoft Excel Training Course
Course Duration: 2 Days
Who is this course for?
This course is intended for participants who wish to gain more knowledge after completing the beginner level of Excel or current users who wish to upskill. For participants who are working with lots of formulas and create reports to understand the necessary techniques on how an electronic spreadsheet works. Microsoft Excel training courses help you acquire these competencies over a short period of time rather than finding out as you go. This training goes a long way to increasing your productivity.
Pre-requisites
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Ability to switch between task applications
- Ability to create a spreadsheet with simple formatting
- Ability to create a basic chart
- Ability to print a spreadsheet with headers and footers added
- Ability to use Auto Filter command
- Ability to apply Freeze Pane command
- Ability to create basic formulas – Addition, Subtraction, Multiplication and Division
- Ability to use basic functions – AutoSum, Count, Max, Min and Average functions
Benefits
Upon completion of this program, participants should be able to:
- Create simple to complex formulas and functions like:
- COUNTA & COUNTIFS Function
- AVERAGE A & AVERAGEIFS Function
- SUMIF & SUMIFS function
- IF Function
- Nested Function
- Database Function
- Validate data in a worksheet
- Filter data using Auto & Advanced Filters
- Use Advanced Chart Formatting
- Clean duplicate records
- Visualise data as a graphics
Key Content
Unit 1: Performing Calculations
Topic A – Reuse Formulas
- Relative references
- Absolute references
- Mixed references
- Understanding mixed cell references
Unit 2: Creating Advanced Formulas
Topic A – Apply Range Names
- Range names
- Adding range names using the Name Box
- Adding a range names using the New Name dialog box
- Editing a range name and deleting a range name
- Using range names in formulas
Unit 3: Working with Functions
Topic A – Using Statistical Functions
- COUNTA Function
- COUNTIFS Function
- AVERAGEA Function
- AVERAGEIFS Function
Topic B – Using Mathematical Functions
- SUMIFS Function
Topic C – Using Logical Functions
- IFERROR Function
- IF Function
- Nested IF Function
Topic D – Using Database Functions
- DSUM Function
- DCOUNT Function
- DAVERAGE Function
- DMAX Function
- DMIN Function
Topic E – Using the XLOOKUP Function
- Understand XLOOKUP, VLOOKUP and HLOOKUP
- Using XLOOKUP to find data
- How to find an exact match with XLOOKUP
- Finding an approximate match with XLOOKUP
- Using XLOOKUP as an Array Formula
Unit 4: Organising Worksheet Data with Tables
Topic A – Create and Modify Tables
- Tables
- Table Components
- Create table dialog box
- Table tools design contextual tab
- Styles and Quick Styles sets
- Customising row display
- Table modification options
Topic B – Sort and Filter Data
- Difference between Sorting and Filtering
- Sorting data
- Advanced filtering
- Removing duplicate values
Topic C – Use Subtotal and Database Functions to Calculate Data
- SubTotal Function
- Summary Function in Tables
Topic D – Data Validation
- Validating your data
- Data Validation using Lists
- Data Validation using Date
- Data Validation using Formulas
Unit 5: Visualising Data as a Graphics
Topic A – Conditional Formatting
- Highlight Cell Rules
- Using Data Bars
- Using Icon Sets
- Creating new rules with Formula
Topic B – Create Charts
- Charts
- Chart Types
- Chart insertion methods
- Resizing and moving Chart
- Adding additional data
- Switching between rows and columns
Topic C: Modify and Format Charts
- Difference between modifying and formatting
- Chart elements
- Minimise extraneous chart elements
- The chart tools contextual tabs
- Formatting the chart with a Style
- Adding legend to the chart
Topic D: Adding Sparklines
- What are Sparklines?
- Adding Sparklines
- Sparkline Tools Tab
- Editing Sparkline Data
- Removing Sparklines
Topic E: Editing Sparklines
- Showing and hiding data
- Changing the style
- Changing Sparkline and Marker Colour
- Setting Sparkline options
Unit 6: Managing Views
Topic A – Working with Different Views
- Using Custom View
- Using Page Layout View
- Express Header & Footer
Topic B – Managing Multiple Windows
- Arranging Workbooks
- Comparing Workbooks Side by Side
- Synchronous Scrolling and Resetting Window
Methodology
Informative presentation, group discussion and presentation, hands-on practical session
Contact us to enrol or enquire
Advanced Microsoft Excel Training Course
Course Duration: 2 Days
Who is this course for?
Microsoft Excel Training courses end with the Advanced level which makes you a master of Excel. This course is intended for participants who wish to gain more knowledge beyond the intermediate level of Excel and become expert users. For participants who are working with nested formulas, perform what if analysis, consolidating data and creates Pivot Table to have in depth understanding of how an electronic spreadsheet works. After this stage you can righfully claim to be an Excel Guru.
Pre-requisites
Intermediate knowledge of Microsoft Excel is essential with the following pre-requisites:
- Ability to switch between task applications
- Ability to create simple to complex formulas and functions
- Ability to validate data in a Worksheet
- Ability to apply Filter data using Auto & Advanced Filters
- Ability to clean Duplicate Records
Benefits
Upon completion of this program, participants should be able to:
- Create Subtotal using the Subtotal Function
- Analyse data using Pivot Tables
- Perform What If Analysis
- Use VLOOKUP function to extract data
- Nesting INDEX and MATCH Function
- Combine & Consolidate Data
- Record and Run a Macro
Key Content
Unit 1: Getting the Most from Your Data
Topic A – Outlining and Grouping Data
- Using Automatic Outlining
- Displaying and Collapsing Levels
- Grouping Data Manually
- Creating Subtotals
Unit 2: What If Analysis
Topic A – Using Data Analysis Tools
- Using a One or Two Input Data Table
- Using Goal Seek
Topic B – Exploring Scenarios
- What is a Scenario?
- Creating a Scenario
- Saving Multiple Scenarios
- Creating a Scenario Summary Report
Topic C – Using Solver
- Understanding Solver
- Generating reports and scenarios with Solver
- Changing Solver values
- Managing Solver constraints
- Using Solver as a Goal Seek tool
Unit 3: Advanced Excel Task
Topic A – Working with Array Formulas
- What are Array Formulas?
- Defining Basic Array Formulas
- Using Functions within Array Formulas
- Using the IF Function in Array Formulas
- Using IFERROR with Array Formulas
Topic B – Using the XLOOKUP Function
- Understand XLOOKUP, VLOOKUP and HLOOKUP
- Using XLOOKUP to find data
- How to find an exact match with XLOOKUP
- Finding an approximate match with XLOOKUP
- Using XLOOKUP as an Array Formula
Topic C – Using Advanced Functions
- Using INDEX Function
- Using MATCH Function
- Combining MATCH & INDEX Functions
Topic D – Linking, Consolidating and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Combining Worksheets
Unit 4: Advanced Chart
Topic A – Create Advanced Chart
- Dual Axis Charts
- Creating Custom Chart Templates
Unit 5: Analysing Data with Pivot Table, Slicer & Pivot Charts
Topic A – Create a Pivot Table
- Create Pivot Table Dialog Box
- Pivot Table Fields Pane
- Summarise Data in a Pivot Table
- Show Values as Functionality of a Pivot Table
Topic B – Filter Data by Using Slicer
- Insert Slicers dialog box
Topic C – Analysing Data with Pivot Chart
- Creating a Pivot Chart
- Applying a Style to a Pivot Chart
Unit 6: Enhancing Workbooks
Topic A – Customizing Workbooks
- What is a Hyperlink?
- Inserting Hyperlinks
- Editing Hyperlinks
- Formatting Hyperlinks
- Using Hyperlinks in Excel
Unit 7: Macros & Form Controls
Topic A – Macros
- Recording Macros
- Saving Macros Enabled Workbook
- Closing and re-opening a Macro Workbook
- Security Warning Message
- Playing a Macro
- Assigning a Keystroke to a Macro
Topic B – Form Controls
- Adding a Control to a Worksheet
- Assigning a Macro to a Control
- Using Form Controls
Unit 8: Publishing & Protection
Topic A – Finishing Workbook
- Publishing to PDF or XPS
Topic B – Protecting Worksheet and Workbook
- Protecting current Sheet
- Protecting entire workbook
- File protection
Contact us to enrol or enquire
Microsoft Excel Training Courses do not end here. You can go on to learn special uses for Excel such as data analysis.
Microsoft Excel Data Analysis Training Course
Course Duration: 4 Days
Microsoft Excel Training courses beginner to advanced level equip you with the skills to be a master of Excel. Microsoft Excel Data Analysis Training Course focuses on the skills which you require to be a skilled data analyst. You will learn the skills that will help you analyse data and present top quality reports using Microsoft Excel. Unleash the power of the world’s leading spreadsheet and acquire top class data analysis skills which improves your value to your organisation. After this course you will be comfortable handling complex data analysis using your favourite Excel. No more need to scramble around for statistical software which will cost you an arm and a leg.
Module 1
- Data Sort
- Filtering
- Tables
- Text to Columns
- Flash Fill
- Data Validation
- Group and Outline
- Freeze Panes
Module 2
- Relative and Absolute Referencing
- VLOOKUP
- Index Match
- IF
- Nested If
- Countif Countifs
- SUMIF SUMIFS
- LEN
- RIGHT LEFT MID
- SEARCH
- Common Error Types
- IFERROR
Module 3
- Chart Basics
- Chart Series and Column Charts
- Bar Charts
- Pie Charts
- Composite Charts
Module 4
- Power Query
- Pivot Tables
- Setting up a Pivot Table
- Pivot Table Field Settings
- Pivot Table Calculated Fields
- Pivot Table Groupings
- Pivot Table Slicers and Timelines
- Dashboards Part 1
- Dashboards Part 2
Training process
- Training Course can be delivered individually or in groups.
- For corporate and other institutions, training can be conducted at your premises.
Course Design
- The courses are designed as an interactive workshops where you do a lot of practice exercises and come out very comfortable with the practical application of Excel skills.
- Our aim is to make sure you come out as an expert in Microsoft Excel Data.
Methodology
Informative presentation, group discussion and presentation, hands on practical session
Contact us about your Microsoft Excel training needs:
Other training courses on offer:
Financial Modelling Using Excel Training Course
Business Analytics with Excel Training Course