KEMBAR78
Intermediate & Advanced Excel Course Outline | PDF | Computers
Scribd
Upload
110 views2 pages

Intermediate & Advanced Excel Course Outline

The document outlines the topics covered in Intermediate Excel and Advanced Excel 2-day training courses. The Intermediate Excel course covers moving and selecting data, functions, referencing, paste special, introduction to functions, conditional formatting, data validation, charts, and logical functions. The Advanced Excel course focuses on mathematical and statistical functions, database functions, advanced charting, pivot tables, data validation, information functions, lookup and reference, what-if analysis, scenario manager, goal seek, macros, and relative referencing macros.

Uploaded by

Sandip kumar
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
110 views2 pages

Intermediate & Advanced Excel Course Outline

The document outlines the topics covered in Intermediate Excel and Advanced Excel 2-day training courses. The Intermediate Excel course covers moving and selecting data, functions, referencing, paste special, introduction to functions, conditional formatting, data validation, charts, and logical functions. The Advanced Excel course focuses on mathematical and statistical functions, database functions, advanced charting, pivot tables, data validation, information functions, lookup and reference, what-if analysis, scenario manager, goal seek, macros, and relative referencing macros.

Uploaded by

Sandip kumar
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/ 2

Intermediate Excel – 2 full days (8 hours/day)

• Moving and Selection Techniques • Database Management In Excel


• Working With Functions • Date Functions
• Referencing in Excel • Text Functions
• Learn options in Paste Special • Using the new AI feature Flash Fill
• Introduction to functions • Pivot Table Basics
• Analyzing Data Using Pivot Tables and enhancing Pivot
• Learning Function Categories (Mathematical & Statistical)
Tables
• Conditional formatting

• Data Validation
• Working With Charts
• Customizing Excel Windows
• Using Logical Functions like:

• Look Up Functions:
Advanced Excel – 2 full days (8 hours/day)
• Learning Functions: Mathematical & Statistical - Sumifs, Countifs, Averagifs, MaxIfs, MinIfs
• Database Functions - DSum, DCount, DAverage, DGet etc.,
• Advanced Charting
• Advanced Pivot Tables
• Data Validation (Advanced)
• Information functions - Isblank, Isnumber, Istext, Isnontext, Iseven, Isodd, Iserror, Iserror, Isna
• Advanced Look Up & Reference
• Performing Spreadsheet What - If Analysis
• Using The Scenario Manager
• Using Goal Seek
• Automating Tasks Using Macro
• Using relative reference Macro

You might also like