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