Why learn MS Excel?

Excel provides users with the ability to calculate, organize, and evaluate quantitative data, allowing managers and senior staff to have the information they need to make important decisions that can affect the company. Excel is a vital tool for speeding up productivity and allowing workers to be more efficient when dealing with large amounts of data and calculations. The more proficient at Excel you become, the more quickly you will be able to navigate the system. Microsoft Excel features several shortcuts that can enable you to work faster and even learn more complicated Excel strategies that can be used across the entire suite of Microsoft Office products.

What you 'll learn

  • Master basics of Excel even you have never worked in a spreadsheet.

  • Create simple to complex data models.

  • Create bespoke reports and analysis.

  • Streamline, revolutionize and automate your work.

  • Most advanced formulas on your finger tips.

  • Build Powerful Advanced Excel Projects From Scratch.

Included in this course :

  • 11 hours of on-demand videos

  • 32 plus downloadable resources

  • Unlimited access for 12 months

  • Certificate of Completion

  • Who should attend

    Everyone irrespective of your job or position.

  • Prerequisites

    None

  • Requirements

    Microsoft Excel 2016 or later. Microsoft Excel 365 is preferred.

Course curriculum

  • 1

    Understanding Excel Basics

    • What is Microsoft Excel?

    • Selecting a Range

    • Entering data in a worksheet.

    • Format your data

    • Auto Fill function to fill data range

    • Concatenate pieces of information

    • Transpose Data - Flip the information

    • Relative and Absolute Cell Reference

    • Find and Replace data

    • Hide, delete and Insert

    • Use Format painter to copy formatting

    • Use Hyperlink to jump to destination

    • Notes and Comments in spreadsheet

    • Paste Special - convert formula to value

    • Data Validation - Avoid data input problems

    • Text to Column and Flash Fill

    • Fixed Width Text to Columns

    • Printing your file

    • Saving Excel File

    • Conditional Formatting
  • 2

    Excel Formulas

    • Calculating Sum

    • VLOOKUP()

    • INDEX(), MATCH(), VLOOKUP() AND HLOOKUP()

    • Date and Time Functions

    • Text Functions

    • CountIf and SumIf

    • Formula Auditing
  • 3

    Working with Data

    • Sort your data

    • Filter your data

    • Remove Duplicates

    • Consolidate Data

    • Data Form - Data input made easy

    • Excel Table and SubTotal Function

    • Group and Ungroup Data

    • Summarize data with Sub Totals

    • What If Analysis

    • Calculation Options
  • 4

    Formulas for Conditional Analysis

    • Logical Functions

    • IF() function

    • Nested IF()

    • IFs() function

    • IF() and AND() functions

    • IF() and OR() functions

    • IF() and NOT() functions

    • SWITCH() function
  • 5

    Data Analysis with Pivot Tables

    • Pivot Tables Basics

    • Data Analysis with Pivot Table

    • Advanced Pivot Tables

    • Recommended Pivot Tables
  • 6

    Excel Charts

    • What are charts

    • Column, Line and Bar Charts

    • Pie Chart

    • Waterfall Chart

    • Create your own Gantt Chart

    • Sparklines - A quick overview of data
  • 7

    Macros

    • Creating a Macro

    • Automate the tasks

    • Macro Enabled File

Buy now

One year subscription