+91 88009 94741
contact-us@progroalliance.org

Not a member yet? Register Now

Login to your account

Lost your password?

Register to start learning

Want to become an instructor?

Advanced Excel

A Powerful Data Analysis tool that helps you to increase your salary

This content is protected, please login and enroll course to view this content!

Prev Using custom sorting

Next Using advanced filter options

Leave a Reply Cancel reply

You must be logged in to post a comment.

Course Content

Total learning: 50 lessons Time: 40 hours

Overview of MS Excel 0/4
- Lecture1.1
  
  MS-Excel Fundamentals
- Lecture1.2
  
  Customizing common options in Excel
- Lecture1.3
  
  Absolute and relative cells
- Lecture1.4
  
  Protecting and un-protecting worksheets and cells
Working with Functions 0/5
- Lecture2.1
  
  Writing conditional expressions (using IF)
- Lecture2.2
  
  Using logical functions (AND, OR, NOT)
- Lecture2.3
  
  Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
- Lecture2.4
  
  VlookUP with Exact Match
- Lecture2.5
  
  VlookUP with Tables, Dynamic Ranges
Data Validations 0/3
- Lecture3.1
  
  Specifying a valid range of values for a cell
- Lecture3.2
  
  Specifying a list of valid values for a cell
- Lecture3.3
  
  Specifying custom validations based on formula for a cell
Working with Templates 0/2
- Lecture4.1
  
  Designing the structure of a template
- Lecture4.2
  
  Using templates for standardization of worksheets
Sorting and Filtering Data 0/5
- Lecture5.1
  
  Sorting tables
- Lecture5.2
  
  Using multiple-level sorting
- Lecture5.3
  
  Using custom sorting
- Lecture5.4
  
  Filtering data for selected view (AutoFilter)
- Lecture5.5
  
  Using advanced filter options
Working with Reports 0/9
- Lecture6.1
  
  Creating subtotals
- Lecture6.2
  
  Multiple-level subtotals
- Lecture6.3
  
  Creating Pivot tables
- Lecture6.4
  
  Formatting and customizing Pivot tables
- Lecture6.5
  
  Using advanced options of Pivot tables
- Lecture6.6
  
  Pivot charts
- Lecture6.7
  
  Consolidating data from multiple sheets and files using Pivot tables
- Lecture6.8
  
  Viewing Subtotal under Pivot
- Lecture6.9
  
  Creating Slicers
More Functions 0/4
- Lecture7.1
  
  Date and time functions
- Lecture7.2
  
  Text functions
- Lecture7.3
  
  Database functions
- Lecture7.4
  
  Power Functions (CountIf, CountIFS, SumIF, SumIfS)
Formatting 0/2
- Lecture8.1
  
  Using auto formatting option for worksheets
- Lecture8.2
  
  Using conditional formatting option for rows, columns and cells
Macros 0/2
- Lecture9.1
  
  Relative & Absolute Macros
- Lecture9.2
  
  Editing Macro’s
WhatIf Analysis 0/4
- Lecture10.1
  
  Goal Seek
- Lecture10.2
  
  Data Tables
- Lecture10.3
  
  Scenario Manager
- Lecture10.4
Charts 0/5
- Lecture11.1
  
  Using Charts
- Lecture11.2
  
  Formatting Charts
- Lecture11.3
  
  Using 3D Graphs
- Lecture11.4
  
  Using Bar and Line Chart together
- Lecture11.5
  
  Sharing Charts with PowerPoint / MS Word, Dynamically
New Features Of Excel 0/2
- Lecture12.1
  
  Sparklines, Inline Charts, data Charts
- Lecture12.2
  
  Overview of all the new features
MIS 0/2
- Lecture13.1
  
  What is MIS ?
- Lecture13.2
  
  Learn to use excel for the application of analytics in MIS
More Applications 0/1
- Lecture14.1
  
  Creating Balance Sheet, GST Sheets, Medical Tables, etc.