MS EXCEL (Level 3 - Advanced)

Description

Date Function(s) :

-- Using Excel's DATE() Function

-- Using Excel's DAYS() Function

-- Using Excel's WEEKDAY() Function

-- Using Excel's EOMONTH() Function

-- Using Excel's EDATE() Function

-- Using Excel's WEEKNUM() Function

-- Using Excel's YEARFRAC() Function

Financial Functions :

-- Using Excel's PV() Function

-- Using Excel's FV() Function

-- Using Excel's PMT() Function

-- Using Excel's RATE() Function

-- Using Excel's NPER() Function

Working with Excel's Lookup Functions :

-- Using Excel's VLOOKUP() Function 

-- Using Excel's HLOOKUP() Function 

-- Using Excel's INDEX() Function

-- Using Excel's MATCH() Function

Data Validation :

-- Introduction to  Data Validation

-- Removing Duplicates

-- Error Alert using Data Validation

Text To Column :

-- Text to Column Approach

What If Analysis :

-- "Go-To" Command

-- Analysis Toolkit

-- Goal Seek

-- Scenario Manager

-- Data Table

Pivot Table and it's Features:

-- Creating and Working with Pivots

-- Creating a Pivot Report

-- Features of Pivot like Grouping, Ungrouping

-- Options in the Value-Field Setting

-- Using Slicers

-- Connecting Slicers

-- Analyzing and Modifying a PivotTable

-- Calculations in Pivots

-- Creating and Working with Pivot Charts

-- Linking Charts to Slicers

Excel Macros - Overview :

-- Creating A Macro

-- Recording a Macro

-- Running a Macro

-- Storing a Macro

-- Saving a Macro Enabled File

Excel Macros - VBA :

-- Developer Tab & Commands on the Ribbon

-- VBA Editor / Projects Explorer

-- Viewing a Macro Code in VBA Editor

-- Understanding the Recorded Actions as Parts of Code

Macros in a Single Workbook :

-- Saving Macros in Personal Macro Workbook

-- Hiding / Unhiding Personal Macro Workbook

-- Adding / Deleting Macros in Personal Macro Workbook

Assigning Macros to Objects :

-- Assigning a Macro to a Shape / Graphic

-- Assigning a Macro to a Control

Running A Macro :

-- Running a Macro from View Tab

-- Running a Macro with Shortcut Key

-- Running a Macro through Quick Access Toolbar

-- Running a Macro in Custom Group

-- Running a Macro by Clicking an Object

-- Running a Macro from the Developer Tab

-- Running a Macro from VBA Editor

Macro Editor :

-- Copying a Macro Code

-- Renaming a Macro

-- Deleting a Macro

Debugging a Code :

-- VBA Debugging