KEMBAR78
Advanced Excel for Professionals | PDF
Scribd
Upload
124 views1 page

Advanced Excel for Professionals

This syllabus covers advanced Excel topics across 19 chapters, including custom formats, data validation, formulas, auditing tools, tables, charts, pivot tables, reports, protection, sharing, multiple workbooks, macros, and what-if analysis. It begins with basics and getting started in Excel, then delves into more complex features for formatting, formulas, importing and analyzing data, and automating processes.

Uploaded by

Raja King
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
124 views1 page

Advanced Excel for Professionals

This syllabus covers advanced Excel topics across 19 chapters, including custom formats, data validation, formulas, auditing tools, tables, charts, pivot tables, reports, protection, sharing, multiple workbooks, macros, and what-if analysis. It begins with basics and getting started in Excel, then delves into more complex features for formatting, formulas, importing and analyzing data, and automating processes.

Uploaded by

Raja King
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Advance Excel Syllabus

Chapter-1: Basics of Excel


Chapter-2: Getting Advance in excel
Chapter-3: Custom and Conditional Formats
Chapter-4: Data Validation
Chapter-5: Working with Range Names
Chapter-6: Using Formulas and Functions
Chapter-7: Absolute and Relative cell reference
Chapter-8: Excel Auditing Tool
Chapter-9: Explore more in Excel
Chapter-10: Managing Tables
Chapter-11: Getting data
Chapter-12: Working with Charts
Chapter-13: Working with Pivot Tables
Chapter-14: Working with Reports
Chapter-15: Worksheet Protection
Chapter-16: Using Shared Work Books
Chapter-17: Multiple workbooks
Chapter-18: What-IF Analysis
Chapter-19: Working with Macros

You might also like