MS Excel Advanced

MS Excel Advanced
  • Pre-Requisite:
    Basic Excel with functions knowledge.
  • Objective:
    Participants can learn how to create advanced workbooks and worksheets and create custom formulas, apply built-in Excel functions and manipulate data to extract desired outputs.
  • Take Away:
    After completing this course, you will be able to apply custom formulas and present data to make informed business decisions.

Course Details:

1
Lesson 1: Creating Advanced Formulas
  • Apply Range Names
  • Use Statistical functions like SUMIF, COUNTIF, SUMIFS, COUNTIFS, LARGE, SMALL
  • Use Text functions like CONCATENATE, UPPER, LOWER, PROPER, FIND, REPLACE, RIGHT, LEFT, MID, TRIM
  • Use Financial Functions like PMT, PV, FV
  • Use date functions like NOW, TODAY, YEAR, MONTH, DAY, DATE, NETWORKDAYS, WORKDAYS, DATEDIF
2
Lesson 2: Analyzing Data with Logical and Lookup Functions
  • Use Logical and Lookup Functions like IF, AND, OR, NOT, NESTED IF
  • VLOOKUP, HLOOKUP, INDEX, MATCH
  • How to use multiple VLOOKUP
3
Lesson 3: Organizing Worksheet Data with Tables
  • Create and Modify Tables
  • Sort and Filter Data
  • Advanced Filter
  • Use Summary and Database Functions to Calculate Data
4
Lesson 4: Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
5
Lesson 5: Analyzing Data with PivotTables, Slicers, and Pivot Charts
  • Create a PivotTable
  • Filter Data Using Slicers
  • Analyze Data Using Pivot Charts
  • Dashboards
6
Lesson 6: Enhancing Workbooks
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files and range of data
7
Lesson 7: Automating Worksheet Functionality
  • Create and Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
8
Lesson 8: Analyzing Data
  • Create Sparklines
  • Perform a What-If Analysis using Goal Seek, Scenarios, Data Table
9
Lesson 9: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks
10
Lesson 10: Exporting Excel Data
  • Export Excel Data
  • Import a Delimited Text File

Onetime payment at the time of admission

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 3 students
Duration: 12 Hours
Lectures: 10
Video: 4

Talk to Our Experts














    Please prove you are human by selecting the Key.