Excel is one of the most used computer programs in the world. It is a spreadsheet that collects data in rows and columns and allows you to perform calculations on the data. It can be used for many purposes, including bookkeeping, budgeting, statistics, plotting graphs, accounting, and more.
In this course, you will learn how to use advanced formula techniques. You will master sophisticated lookup functions. You’ll clean and prepare data for analysis and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for the big finale, where you will learn how to build professional dashboards in Excel.
The course is aimed at those who have taken an intermediate level excel course or have basic skills in excel. This course will build on that foundation of knowledge by providing a more detailed look at the capabilities of Excel 2016 for Windows.
Our goal is to prepare you with everything you need so that you’re an expert at creating high-quality dashboards in Excel.
If this sounds like something you’d be interested in, take a look at our full curriculum below or just click the enroll button below!
- Overview and Background
- Basic desktop navigation
- Creating a workbook and adding data
- Creating formulas and functions
- Formatting cells and tables for readability and analysis
- Creating and Formatting Tables
- Creating Graphs and Charts
- Introduction to Macros and VBA
Virtual Training Schedule
|Start Date||End Date||Location||Cost||Apply here|
|7th Feb 2022||11th Feb 2022||Online||$350/ksh35000||Enroll|
|7th March 2022||11th March 2022||Online||$350/ksh35000||Enroll|