Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Analyse and Visualize using MS Excel

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting,Skype

Course ID: 32006

Course type: Online Instructor led Course

Platform: GoToMeeting,Skype

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.


Analytics Consultant and Instructor

About Samik

10+ years of Experience in analytic with 8 Years of Teaching Experience.
No reviews currently Be the First to Review

About the Course

MS Excel and VBA

MS Excel is a very powerful tools used by most of the data analyst in the industry. In this course you will learn how to Master Excel and make it perform any kind of data analysis and Visualization. You will also be equipped with VBA programming skills which is the most powerful feature of Excel. 


The Microsoft Excel Course is divided into 4 levels


  • Excel L1: Excel Basics

  • Excel L2: Intermediate Level Excel

  • Excel L3: Advanced Level

  • Master Excel Macro and VBA


Who can take this course:


If you are looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you. No prior experience of Excel is required to take this course


Excel L1


  • Excel Basics:

    • Excel interface.

    • Quick Access toolbar.

    • Structure of an Excel Workbook


  • Texts and Formula in Excel

    • Work with numeric data

    • Work with Date values

    • Cell reference

    • Basic formulas

    • Relative vs Absolute cell reference


  • Work with basic Excel Functions

    • How to use basic excel formulas

    • Use Autosum command

    • Use autofill command to copy formulas


  • Formatting data in Excel Workbook

  • Work with data, cell formatting

  • Use conditional formatting


  • Create basic charts in Excel

    • Create Excel column chart

    • Excel chart ribbon

    • Adding and modifying data on Excel chart

    • Formatting Excel Chart

    • Move chart into another worksheet

    • Work with Excel pie charts


  • Work with Excel Template

    • Intro to excel template

    • Create customer template


Excel L2


  • Work with Excel List


  • Sort List Using Single Level and Multi level Sort

  • Custom Sorts

  • Filter an Excel List Using the AutoFilter Tool

  • Subtotals in a List

  • Format a List as a Table

  • Conditional Formatting to Find Duplicates and remove duplicated

  • List Functions: DSUM(), DAVERAGE(), DCOUNT(), SUBTOTAL()


  • Excel Data Validation

    • Basics of Validation

    • Create a validation list

    • Customer validation error

    • Create dynamic formula using validation technique


  • Importing and Exporting Data in Excel


  • Pivot Tables

    • Understanding Pivot table

    • Create and Modify Pivot table

    • Grouping Pivot Data

    • Formatting and Drill down

    • Work with Pivot Charts

    • Filter Pivot table Data

    • Work with Slicer tool

    • Power Pivot tool-Activate power pivot

    • Create data model with Power Pivot

    • Power Pivot calculated fields and KPIs


  • Work with Large set of Excel Data

    • Freeze pane tool

    • Grouping Data (Columns and/or Rows)

    • Link Worksheets (3D Formulas)

    • Consolidating Data from Multiple Worksheets



Excel L3


  • Conditional Function in Excel

    • Excel Name Ranges

    • Excel's IF() Function

    • Nesting Functions




  • Excel Look up functions

    • VLOOKUP() and HLOOKUP() function-two very important functions

    • Excel's INDEX() and MATCH() Functions

  • Text Functions in Excel

    • LEFT(), RIGHT() and MID() Functions

    • Understanding LEN() ,SEARCH(), CONCATENATE() Functions


  • Excel worksheet auditing

    • Precedents, Dependentsand watch window in Excel


  • “What If” analysis in Excel

    • Solver Tool,Goal Seek tool

    • Creating scenarios and building effective data tables in Excel



Excel VBA


  • Introduction to Visual Basics

    • Understanding Objects

    • Containers and Collections

    • How VBA refers to Objects


  • Recording and Modifying Macros

    • Recording Macros to perform repetitive task

    • Testing the Macro and Looking at the VBA

    • Absolute vs. Relative Mode

    • Modifying Macros Using VBA

    • Accessing Macros through Command Buttons , shapes or images


  • Visual Basics Editor

    • Basics Navigation: Project Explorer, Properties window, Code window

    • Adding and Removing Modules

    • Customizing the Visual Basic Environment

    • The Object Browser


  • Programming in VBA

    • Introduction to Writing VBA

    • Structure of Sub Procedures

    • Calling a Sub Procedure

    • Structure of Functions

    • Calling a Function and procedure

    • Work with Objects, Methods, Event procedures


  • Variables, Data types and Operators

    • Declaring multiple variable

    • Object variables

    • Data types

    • Declaring constant

    • Arithmetic and logical operators

    • String concatenation


  • Workbooks, Cells and Ranges

    • Active sheet, Adding and moving worksheets

    • Cell object, Active cell , Autofit columns and rows

    • Range objects

    • The currentRegion property

    • The range.end property

    • The name property and value property

    • Sorting and filtering fields


  • Formatting with Functions

    • Named format expressions

    • Custom Formatting


  • VBA Programming tools

    • Decision structures-If..Then, if..then.else

    • Select case

    • Loops in VBA: For Next, Stepping, for each, do while loop


  • VBA functionality

    • Message box and input boxes

    • User forms

    • Form control- Attach Events to Form Controls

    • Form Event

    • Validate form data


  • Debugging in VBA

    • Syntax error

    • Run time error

    • Logical error

    • Debugging and error handling techniques

  -break point, watch window, stepping through


  • Case Studies


  • Dashboards

  • VBA based Projects












No reviews currently Be the First to Review

Gallery (1)

Discussions (1)

Hi, Is this course for beginners or advanced Excel? Does this course covers Excel Dash boarding?

By Sutapa


Top Answer

Hi Sutapa, Thank you for your query. The course is designed to cover from Basics to advanced level (including VBA). The case studies will cover how to create interactive Excel Dashboards.
0 Dislike
View all answers

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now


Submit your enquiry for Analyse and Visualize using MS Excel

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Edulitix

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer