Advance Excel

Advance Excel

Course Features

  • Language: Hindi/English
  • Viewers: 546
  • Course Material: Yes
  • Prerequisites: Yes
  • Course Category: Short Term Course
  • Batch Capacity: 25

Descriptions

INTRODUCTION:

MS Excel is a spreadsheet tool which helps individuals and business entities to keep records of  their important information data, perform complex calculations and analysis.

Course Requirement: Working knowledge of MS Excel  

A 8 week intensive Advanced Excel Course will cover the following: 

Week 1

Grouping & Outlining and Subtotals:

  • Outlining and Grouping Data
  • Using the Subtotals Tool

What-If Analysis:

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

Week 2

Pivot Tables:

  • Getting Started with Pivot Tables
  • Displaying Data in a Pivot Table
  • Formatting a Pivot Table
  • Using the Classic Pivot Table Layout
  • Slicers

Charting Pivoted Data:

  • Getting Started with Pivot Charts
  • Using the Pivot Chart Tools Tabs
  • Formatting a Pivot Chart

Week 3

Advanced Excel Tasks:

  • Excel and Hyperlinks
  • Using Custom Auto Fill Lists
  • Sharing Workbooks
  • MIS Report
  • Search List
  • Freezing Panes

Creating H-LOOKUP and V-LOOKUP Functions:

  • Using the V-LOOKUP Function
  • Using the H-LOOKUP Function
  • Array Formula
  • Advance filters
  • Data Validation

Week 4

Macros:

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

Week 5

Introduction to VBA:

  • What is VBA?
  • What can you do with VBA?
  • Recording a Macro

Week 6

Variables in VBA:

  • What is Variables?
  • Variables Data Type
  • Using Const Variables

Message box and Input box Function:

  • Customizing message box and Input box
  • Reading Cell Value into message
  • Various button Group in VBA

If and Select Statement:

  • Simple if Statement
  • Defining Select Case Statement

Week 7

Looping In VBA:

  • Introduction to loop and its type
  • Exiting for loop
  • Advanced loop Examples

Worksheet / Workbook operation:

  • Merge worksheet using macro
  • Merge multiple excel files into one sheet
  • Split worksheets using VBA Filters

*Customized Courses also available as per the requirement.

Course Reviews

Based On 0 Review
0
overall
5 stars
0%
0
4 stars
0%
0
3 stars
0%
0
2 stars
0%
0
1 stars
0%
0

Be the first to review “Advance Excel”

There are no reviews yet.

Enquire Now
close slider
Please fill your details.




Select Categories
Select Categories
Select Categories
Select Categories
Select Categories
Select Categories
Select Categories
Select Categories
Select Categories

*Course customization also available