Introduction to Excel
Security
Short Keys
Practice Data Sheets
Data Formats
Conditional Formatting
Format as Table
Data Sorting
Data Filtering
Remove Duplicates
Data Validation
Text-To-Columns
Data Consolidation
What-if-Analysis
Grouping
Absolute & Relative Referencing
Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
Task1 - Mathematical Formulas
Logical Functions - IF, IFERROR, AND, OR
Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
Vlookup Formula
Task2 - Vlookup Problems
Vlookup with Match Formula - Dynamic Duo
Vlookup using (*) example
Vlookup with Running Countif
Task3 - Vlookup, Running Countif Problem
Lookup Functions - Hlookup, Index Match
Lookup Functions - Indirect, Offset
Vlookup-Indirect Example
Sumif, Indirect, Offset, Match Example
Array Functions
Task4 - Array Problem
Advanced Conditional Formatting using Formula
Data Validation using Indirect Function
Charts, Waterfall Graph
Pivot Table, Dashboards

Powered by GitBook

On this page

Was this helpful?

Short Keys

PreviousSecurity NextPractice Data Sheets

Last updated 5 years ago

Important Short keys

Ctrl + Down Arrow key - Jump down till the break point
Ctrl + Right Arrow Key - Jump right till the break point
Ctrl + Page Down - Switch worksheet from Sheet1 to Sheet2
Ctrl + Page Up - Switch worksheet from Sheet2 to Sheet1
Alt + I + R - Insert Row
Alt + I + C - Insert Column
Ctrl + (minus) - Delete Row/ Column
Alt + E + S - Paste Special

Concept Of ALT Key (Very Important)

Almost all Short keys in excel are driven by ALT key concept Press Alt and Release For File - press F, Home - H, Insert - N, etc

For home, press H and you will find short key for all the excel operations

Short key for

Font --> Alt + H + FF

Highlight --> Alt + H + H