Useful Excel Shortcuts
  • Useful Excel Shortcuts
Conditional Formatting (Highlight / Color data on the basis of Criterias)
  • Conditional Formatting (Part 1) Formatting data on the basis of Criteria
  • Conditional Formatting (Part 2)
  • Advanced Conditional Formatting using Formula (Highlight Entire Row)
Deleting Blank Rows from huge database (3 Methods)
  • 3 Methods of Deleting Blank Rows from your Sheet
Sorting & Filtering
  • Sorting (Arranging data in proper order)
  • Filter data according to your requirement
Creating Beautiful Charts
  • Create Column Chart
  • Creating Dynamic Chart & Line Chart
  • Pie and Sales vs Target Line Chart
  • Thermometer Chart and Linking Chart to PowerPoint
PIVOT Table - Creating Dashboard - Summary Report with Pivot Table
  • Creating 1st Interactive Report with Pivot Table
  • Creating Yearly and Quarterly Report with Pivot
  • Creating Summary Report (All Reports on 1 Sheet)
  • Creating Interactive Dashboard with Charts
Paste Special
  • Convert Formulas into value
Validation
  • Create Drop Down in cells & Restrict invalid values in cell
  • Setting Error Alert in Validation
  • Data Validation on Numbers
Macros Recording and Running
  • Automate your regular activities with Macro recording
Sub total & Text to Column (To Seperate First Name & Last Name)
  • Create Subtotal of Huge data
  • Seperate First & Last Name
Hyperlink
  • Hyperlink Part 1 Linking to other Sheet
  • Hyperlink Part 2 Linking in Same Sheet
  • Hyperlink Part 3 Linking other file
Protecting Data
  • 1) File Level Protection
  • 2) Sheet Level Protection
  • 3) Workbook Level Protection
  • 4) Cell Level Protection
Basic Formulas
  • Sum and SubTotal Formula
  • Find Minimum, Maximum and Average from Data
Count IF and SumIF Function
  • COUNTIF Function
  • SumIF Formula
IF Condition
  • IF Condition & Multiple IFs
Vlookup (To pull the data from other file)
  • 1) Vlookup (Pulling data from other file) - Part 1
  • 2) Quick Vlookup by Adding $ Sign
  • 3) Fully Automated Vlookup (Vlookup with Match Formula)
Convert your Text in First Letter Capital, small or all CAPITAL
  • Convert your Text in First Letter Capital, small or all CAPITAL
Other Regular used Functions
  • Calculate days between two dates
Combine First Name and Last Name
  • Combine First Name, Last Name, Email ID and Mailing Address
Hide Text in the Cell (Interesting Trick)
  • Hide Text in the Cell
Magical Fill in Excel
  • Flash Fill (Hours of Work in Seconds)
Excel Reference Materials
  • Useful Excel Shortcuts
  • Excel Tips and Tricks & Reference Material