- Introduction
- Udemy Platform
- Walk though VLOOKUP formula
- Have you left Feedback?
Online
₹ 449 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹3,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Overview of the Excel Programme
- Introduction: Overview of the Excel Programme
- Workbooks and Sheets
- Cells and Ranges
- The Ribbon
Quick Keys
- Excel Options
- Quiz: Excel Programme
- Moving Around
- Introduction to Quick Keys
- Common Quick Keys
- Function Keys
- Formatting and Other
- Quiz: Quick Keys
Introduction to Formulas
- Introduction: Formulas
- Entering Formulas
- Characters Used in Formulas
- SUM and COUNT
- IF Functions
- AND, OR
- SUMIF and SUMIFS
- COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS
- AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS
- MIN, MINA, MINIFS, MAX, MAXA, MAXIFS
- LARGE, SMALL
- SUBTOTAL
- IFERROR
- ROUND, ROUNDUP, ROUNDDOWN, MROUND
- Introduction to Formulas Exercise Overview
- Introduction to Formulas Exercise Solution
Formatting
- Introduction: Formatting
- Fonts, Colours, Fills
- Boarders
- Manipulation Columns and Rows
- Format Painter
- Conditional Formatting
- Illustrations
- Text Boxes and Word Art
- Links
- Notes and Comments
- Paste Special
- Protection
- Formatting Exercise Overview
- Formatting Exercise Solution
Data Categories
- Data Categories: Introduction
- General, Number, Text and Others
- Date and Time
- Currency and Accounting
- Data Categories Exercise Overview
- Data Categories Exercise Solutions
View and Printing Spread Sheets
- View and Printing Sheets: Introduction
- Views
- Printing - Page Setup
- Printing - Scaling and Sheet Options
- Viewing and Printing Sheets: Summary
Organising Data
- Introduction: Organising Data
- Sorting
- Auto Filter
- Advanced Filter
- Grouping
- Data Validation
- Text to Columns
- Find and Select tools
- Tables
- Tables Formulas
- Organising Data Exercise Overview
- Organising Data Exercise Solutions
Math Functions
- Math Functions: Introduction
- PI
- Deg, Radions
- SIG, COS, TAN
- SQRT, SQRTPI
- POWER
- CONVERT
- Math Functions Quiz
Text Functions
- Introduction: Text Functions
- CONCAT and &
- LEFT, RIGHT, MID
- LEN
- SUBSITUTE
- UPPER and LOWER
- SEARCH and FIND
- Text Functions Exercise Overview
- Text Functions Exercise Solutions
Date and Time Functions
- Date and Time Functions: Introduction
- TODAY(), NOW()
- YEAR-MONTH-DAY-HOUR-MINUTE-SECOND Functions
- DATE
- WEEKDAY, WEEKNUM
- NETWORKDAYS, NETWORKDAYS,inlt
- WORKDAY, WORKDAY.inlt
- YEARFRAC
- Date and Time Functions Exercise Overview
- Date and Time Functions Exercise Solutions
Lookup and Reference Formulas
- Introduction: Lookup and Reference Formulas
- VLOOKUP, HLOOKUP
- MATCH
- INDEX
- MATCH and INDEX Formulas
- XLOOKUP
- XLOOKUP Tips and Tricks
- INDIRECT
- COLUMN, ROW
- ADDRESS
- OFFSET
- Lookup and Reference Formulas Exercise Overview
- Lookup and Reference Formulas Exercise Solutions
Analysing Data
- Analysing Data: Introduction
- What if Analysis - Goal Seek
- What if Analysis - Scenario Manager
- What if Analysis - Data Table
- Pivot Tables
- Analysing Data Exercise Overview
- Analysing Data Exercise Solutions
Charts
- Introduction: Charts
- Note on the National Statistics Sheet
- Creating Charts and Selecting Data
- Adding Elements
- Quick Layouts and Chart Styles
- Formatting Charts
- Formatting Axis and Data Series
- Map Charts
- Pivot Charts
- Recommended Charts
- Ideas
- Charts Exercise Overview
- Charts Exercise Solution
Tips and Tricks
- Tips and Tricks Introduction
- Week Commencing Date Formula - Aug-2019
- Easy formula to convert a list of numbers to cumulative - Sept 2019
- Remove Duplicates and SUMIF wildcards!
- Quickly Remove Unwanted Characters
- 2 Tricks to Remove Blank Cells from Your Data
- 3 ways to reduce Excel file size without losing data
- Select Visible Cells Only Quick Key