VAC - Advanced Excel - Session Topics

 

Name of the Course : Advanced Excel Techniques

Duration of the Course : 30 Hours

Pre-Requisite:

·         Must know the fundamentals of Excel – Workbook, Sheet, Cell, Saving Workbook.

·         Commitment to spend at least two hours per week practicing the skills introduced in the course.

Course Objective:

·         master the skills of working with: diagrams, Microsoft Excel and sorts;

·         learn to use this software confidently;

·         understand the advanced functions of Excel: the user interface of Excel

·         Ability to competently navigate the Excel user interface; performs basic calculations using formulas and functions, professionally format spreadsheets and create data visualizations using charts and graphs.

Course Outcome:

·         Speedy data analysis

·         Better Understanding of Excel functionalities

·         Time Saving in data processing

·         Reaching deep into data and seeing the unseen truth

·         Learn to present data in better and understanding way

Topics Covered:

EXCEL BASICS - FORMATS, CONDITIONAL FORMATTING & SORTING - DATA MANAGEMENT - FORMULAS & FUNCTIONS - CHART & GRAPHS - DATA ANALYSIS (Pivot Table)

Topic

Formatting & Managing your Worksheet & workbook

Basic Formulas, Number Formats & Working

Conditional Formatting Data Bars, Colour Scales & Icon Sets,

Conditional formatting with formulas

Sorting basic & advance

Filters Basic & Advance

Data from other Sources

Data Validation and dealing with Invalid Data

Text Formulas : Exact, Find, Upper, Proper, Left, Right, Mid & many more

Lookup Formulas : Vlookup, Hlookup, Lookup, Match etc..

Logical Formulas: If, AND, OR, NOR etc…

Date & Time Formulas : Today, Now, Years, etc..

How & when to apply Nested Functions

Chart Basics: What, When & How

Line Chart - Column Chart

Creating a PivotTable

Selecting What Appears in a PivotTable

Scenario Modelling

Goal Seek

Macro – Recording a Macro