Advance Excel

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations.

Course Duration

1-1.5 Months

Certificate

Upon Completion

Students Enrolled

1000+

Learning Mode

Online & Offline

Branches

Maninagar | Gandhinagar | Kudasan | Bopal | Nikol | Mehsana | Gurukul

Advanced Microsoft Excel - From Basic to Pro

Learn from Industry Experts | 100% Placement Assistance

Timing : 9.00 AM - 06.00 PM

About This Course

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

Course Curriculum


Module 1: Advanced Microsoft Excel

  • Introduction to Excel Interface and Workbook Basics
  • Entering, Editing, and Formatting Data
  • Basic Formulas - SUM, AVERAGE, COUNT, MIN, MAX
  • Cell Referencing - Relative, Absolute, Mixed
  • Working with Multiple Worksheets and Workbooks
  • Advanced Formulas - VLOOKUP, HLOOKUP, XLOOKUP
  • INDEX-MATCH and IF Functions
  • Conditional Formatting and Data Validation
  • Sorting, Filtering, and Subtotals
  • PivotTables and PivotCharts for Data Analysis
  • Charts and Graphs - Bar, Line, Pie, Column
  • What-If Analysis - Goal Seek, Data Tables, Scenario Manager
  • Power Query for Data Transformation
  • Dashboard Creation in Excel
  • Protecting Sheets and Workbooks
  • Printing and Sharing Excel Files

Inquiry Now

Leave Message