Advanced Microsoft Excel - From Basic to Pro
Learn from Industry Experts | 100% Placement Assistance
Timing : 9.00 AM - 06.00 PMAbout 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 Duration
1-1.5 Months
-
Certificate
Upon Completion
-
Students Enrolled
1000+
-
Learning Mode
Online & Offline
-
Branches
Maninagar | Gandhinagar | Kudasan | Bopal | Nikol | Mehsana | Gurukul
Course Curriculum
- 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
