[go: up one dir, main page]
Scribd
Upload
41 views2 pages

Advanced Excel

The document outlines a comprehensive curriculum for mastering Excel, covering topics such as customizing options, data validation, pivot tables, advanced functions, and chart creation. It includes recommended study materials and reference books, as well as web resources for further learning. The content is structured into five units, each focusing on different aspects of Excel functionalities and features.

Uploaded by

Alamelu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
41 views2 pages

Advanced Excel

The document outlines a comprehensive curriculum for mastering Excel, covering topics such as customizing options, data validation, pivot tables, advanced functions, and chart creation. It includes recommended study materials and reference books, as well as web resources for further learning. The content is structured into five units, each focusing on different aspects of Excel functionalities and features.

Uploaded by

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

Unit-I Basics of Excel- Customizing common options- Absolute and relative cells-

Protecting and un-protecting worksheets and cells- Working with Functions - Writing
conditional expressions - logical functions - lookup and reference functions- VlookUP with
Exact Match, Approximate Match- Nested VlookUP with Exact Match- VlookUP with
Tables, Dynamic Ranges- Nested VlookUP with Exact Match- Using VLookUP to
consolidate Data from Multiple Sheets

Unit-II Data Validations - Specifying a valid range of values - Specifying a list of valid
values- Specifying custom validations based on formula - Working with Templates
Designing the structure of a template- templates for standardization of worksheets - Sorting
and Filtering Data - Sorting tables- multiple-level sorting- custom sorting- Filtering data for
selected view - advanced filter options- Working with Reports Creating subtotals- Multiple-
levelsubtotal.

Unit- III Creating Pivot tables Formatting and customizing Pivot tables- advanced options
of Pivot tables-Pivot charts- Consolidating data from multiple sheets and files using Pivot
tables- external data sources- data consolidation feature to consolidate data- Show Value As
% of Row, % of Column, Running Total, Compare with Specific Field-Viewing Subtotal
under Pivot- Creating Slicers.

Unit- IV More Functions Date and time functions- Text functions- Database functions-
Power Functions - Formatting Using auto formatting option for worksheets- Using
conditional formatting option for rows, columns and cells- What If Analysis - Goal Seek-
Data Tables- Scenario Manager
Unit -V Charts - Formatting Charts- 3D Graphs- Bar and Line Chart together-
Secondary Axis in Graphs- Sharing Charts with PowerPoint / MS Word, Dynamically-
New Features Of Excel Spark lines, Inline Charts, data Charts- Overview
of all the new features.

Book for Study:

1. Excel 2019 All


2. Microsoft Excel 2019 Pivot Table Data Crunching
Books for Reference:
1. John Michaloudis , Bryan Hong (2022),” 101 Best Excel Tips & Tricks”, MyExcel
online,1st Edition.
2. Alan Murray, (2022), Advanced Excel Formulas: Unleashing Brilliance with Excel
Formulas, Apress,1st Edition,.
3. Lokesh Lalwani, (2019), Excel 2019 All-In-One: Master the new features of Excel
2019 / Office 365BPB publications, New Delhi, 1st Edition.
Web Resources / E. Books:
1. https://sunsreynat.files.wordpress.com/2014/06/excel-2010-advanced.pdf
2. https://www.tutorialspoint.com/advanced_excel/advanced_excel_tutorial.pdf
3. http://www.advancedexcelbook.com/

You might also like