About Course

Microsoft Excel is the world’s leading spreadsheet programme. It is a critical piece of software for office environments and financial businesses.

Our Microsoft Excel course teaches you how to manage, calculate and format data in clear and visually appealing ways. This includes making calculations, displaying data as graphs or charts and creating complex formulas.

Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of  Excel skills. This course is aimed at taking your excel skills to the next level. You will be able to apply complex functions within Excel to manage, manipulate, analyze and visualize data.

 

About the Course

This Excel course comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace.

Having completed our Microsoft Excel course, you could add Microsoft Excel to your list of achievements, which could help maximise your career potential.

Comprising twenty two lessons this course covers areas such as creating worksheets, formatting text, simple and complex formulas; handling rows and columns, autocomplete, using styles, headers and footers, average, max and min functions and using charts.

 

This course is aimed at professionals and individuals whom have none to intermediate Excel skills and want to advance those skills. From beginners, to advanced users, this course is perfect for all ability levels

 

By the end of this training you will be able to:

  • Master Excel formulas and functions
  • Consolidate data, link and export data in Excel
  • How to create and format worksheet
  • Create and edit tables and graphs
  • Become one of the top Excel users in your team
  • Design professional and good-looking advanced charts
  • Turn raw data into ‘must make’ decisions using PivotTables

You will learn the key concepts and techniques necessary to work with Excel

From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel

Show More

What Will You Learn?

  • Master Excel formulas and functions
  • Consolidate data, link and export data in Excel
  • How to create and format worksheet
  • Create and edit tables and graphs
  • Become one of the top Excel users in your team
  • Design professional and good-looking advanced charts
  • Turn raw data into ‘must make’ decisions using PivotTables
  • You will learn the key concepts and techniques necessary to work with Excel
  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel

Course Content

Intro to Excel

  • Welcome Note
    03:30
  • An Overview of Excel Spreadsheet
    08:44

Data Input & Manipulation in Excel

Excel Formulas

Excel Functions

Excel Data Management

Printing & Securing Excel Files

Excel Charts

Pivot Tables

VLookUp Function

Power Query

Conclusion