About Excel

Excel is a program that is used widely by industries, universities, academic institutions and many more. Excel is having very powerful functions that can be easily used in our routine life like pivot table, lookup, conditional formatting, data visualizations, and many more. It also can be used for data entry, data cleaning, data restructuring, etc.

Schedule

• Date: 16th  Jul to 18th Jul 2021
• Timing: 4:30 PM to 6:30 PM

Benefits

• Suitable for beginner, intermediate level
• Experienced faculty
• Hands-on experience
• Email support after training
• Access to Session Recording for 6 months
• E-Certificate upon clearing the exam

Content

• Introduction to Excel
  • Overview of Excel & Its History
  • Uses of Excel
  • Advantages 
  • File extension
• Getting Started with Excel
  • Opening of Excel
  • Understanding File Menu
• Understanding of Excel Interface
  • Quick Access Bar
  • Ribbon
  • Row, Column, Cell & Cell Address & Cell Content
  • Formula Bar
  • Worksheet Options (Rename/Hide/Unhide/Protect etc.)
  • Window Options (View Tab)
• Basic Formulas & Functions
  • Mathematical Operations using Formulas
  • Basic Formulas (Text, Date & Time) 
  • Creating Functions (Sum, Average, Count, Max, Min Etc.)
  • Functions Library
• Relative and Absolute Cell References
  • Concept of Relative and Absolute Ref.
  • Create and copy a formula using relative references
  • Create and copy a formula using absolute references
• Advanced Formulas & Functions
  • IF Statement, Nested IF Statement,
  • Vlookup,
  • Hlookup,
  • Index Match
• Data Validation
  • What is data validation
  • When to use data validation
  • Applying Validation criteria
• Conditional Formatting
  • Applying & modifying built-in options
  • Create & manage custom rule
  • Applying Data bar, Color Scale & Icon
• Excel Table & Excel Chart
  • Converting raw data into Excel Table Format
  • Benefits of converting raw data into Excel Table Format
  • Inserting & Modifying Excel Charts
• Pivot Table, Pivot Chart, Slicers & Timeline
  • Converting Table data into Pivot Table
  • Pivot Table Fields
  • Adding, modifying Data into Pivot Table
  • Creating Pivot Chart
  • Inserting slicers & Timeline
  • Inserting Sparkline (Line, Column, Win/Loss)
• Dashboard
  • What is Dashboard
  • Types of Dashboard
  • Things to be consider
  • How to create a dashboard in Excel
• Q&A Session
• Exam