Excel VBA Course

Shortcuts

Creating and Editing Workbooks

Formatting Content

Printing and Viewing Workbooks

Writing and Editing Formulas

References in Formulas

Working with Percentages

Working with Dates and Times

Fixing Errors in Formulas

Naming Cells and Ranges

Sheet Protection Sheet

Workbook Protection

Structure Protection

Overview of Functions

Text Functions ( Left, right, mid, Proper, Trim, Text…)

Date Functions ( Netwokday, Dataedif, Today ,....)

Logical Functions ( If , Nested if)

Reference Functions (Vlookup, Hlookup, Index match, …)

Aggregrate Functions ( Sub total,...)

Rounding Up and Down ( All Round function)

Advance Logical Functions ( Nestedif , Iferror)

Advance Reference Functions ( Indirect, offset)

Summarization Functions ( Sumifs, Countifs, Averageifs)

Advance Date Functions

Array Functions ( Transpose, Index Match)

Financial Functions

Organise Lists of Data

Sort and Filter Data

Advanced Data Filters

Conditional Formatting

Group and Summarise Data

Tables of Data

Introduction to PivotTables

Advanced PivotTable Skills

Data Validation

Database Functions

Performing What-If Analysis

Create column, line, pie Charts

Change the chart type

Use the quick layout options

Combine different Data types within one chart

Create a chart with two vertical axis

Add trend lines to charts

Add, edit and format labels

Use the invert if negative option

Connect Multiple excel file

Connect with Access

Connect with Text files

What is Macro

Developer Tab/ Setting

Record one programm