+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

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.

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

Prev Pivot charts

Next Viewing Subtotal under Pivot

Leave a Reply Cancel reply

You must be logged in to post a comment.