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)

₹ 2,500

No Reviews Yet

Date and Time

Not decided yet.

Samik

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

    • COUNTIF(), SUMIF(),IFERROR(),SUMIFS(), COUNTIFS()




           


 



  • 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


 


 


 


 


           


           


 


 


 


 

Reviews

No reviews currently Be the First to Review

Discussions (1)

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

By Sutapa

Edulitix

Top Answer

Hi Sutapa, Thank you for your query. The course is designed to cover from Basics to advanced level (including...

0 Dislike
Comment
View all answers

Students Interested 0 (Seats Left 0)

₹ 2,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 2,500 Enquire

Enquire

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 support@urbanpro.com 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 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