Our Excel course is designed to provide individuals and businesses with the knowledge and skills necessary to use Microsoft Excel effectively for data analysis and management.This course will cover advanced topics such as pivot tables, conditional formatting, and macros, which are powerful tools that allow users to manipulate data more efficiently. You will learn how to sort, filter, and analyse data using these tools, which can save time and provide insights into complex data sets.
Excel Introduction
11:37
09:13
05:07
02:33
05:31
16:42
Excel Basic Tools
13:58
07:23
08:40
05:14
08:44
Apply Custom Data Formats
08:54
Use Advanced Fill Options
10:16
13:19
12:50
Apply Advanced Conditional Formatting and Filtering
16:07
12:54
11:39
11:41
04:31
Apply Custom Styles and Templates
Functions
Apply functions in formulas
13:44
Mathematical Functions
Financial functions
Useful Data Functions
IFERROR, OFFSET, INDIRECT Function
Look up data by using functions
10:06
14:45
Calculation Between Two Dates
Functions for Manipulating Text
06:45
13:40
Use What-If Analysis Tools
Basic Excel Charts
PivotTables
Use Pivot Charts
15:45
Work With Sparklines
08:27
Manage Workbook Versions
10:22
Protect Workbooks for Sharing
16:23
Connect To External Data
17:38