MS Excel - Top Excel Tips, Excel Tricks, Excel Shortcuts
  • Introduction to Excel reports
  • Shortcut Key Function - F6
  • Shortcut Key Function - F10
  • Formatting Text and Numbers
  • F2 and Shit Plus F2
  • CTRL Plus Apostrophe
  • CTRL Plus Shift Plus Tilde
  • Entering a Formula
  • Entering a Function
  • Operator Precedence
  • Name and Formula in Excel
  • Count functions in Excel
  • Sum Functions in Excel
  • More in Count Functions in Excel
  • Counts of Logical Values in Excel
  • Sum Product Function in Excel
  • Average Counting Blank and Non Blank
  • Offset and Concat Function in Excel
  • Relative Reference in Excel
  • Absolute and Mixed Reference in Excel
  • Logically if Function in Excel
  • Logically AND & OR Function in Excel
  • Nested if and Switch Function
  • Example of Logical Function
  • Basic of Date and Time Format
  • Dated if and Weekday Function
  • Network Day Function
  • Work Day Function
  • Example of Date and Time Function
  • String Concentration Function
  • Upper and Lower Function
  • Lenth of the Function
  • Trim and Clean Function
  • Search and Concat Function
  • Vertical Lookups (v LOOKUPS)
  • Horizontal Lookups (H Lookups)
  • Match Function
  • Left V Lookups
  • Tow Ways Lookup
  • Tow Ways Lookup Continues
  • Example of Lookups
  • PMT Financial Function
  • Loan with Different Terms
  • Loan with Different Terms Continues
  • PPMT and IPMT
  • Example of PPMT and IPMT
  • Average and Average If Function
  • Random Number and rank Function
  • Random Number and rank Function Continues
  • Percentile and Quadrilles
  • Round and Even Odd Function
  • Trendline and Trend Analysis
  • Trendline and Trend Analysis Continues
  • Round up and Round Down Function
  • INT and TRUNC Function
Excel Charts - Data Visualization with Excel Graphs & Charts
  • Introduction to Excel Charts and Smart Art Graphics
  • Learning the HR Database
  • Sales Productivity Database
  • Learning how to insert pictures
  • Study on Clip Arts
  • Utilizing the Screenshot option
  • Creating Shapes in Excel
  • Creating Venn Diagram
  • Training on Charts
  • Groupings for percentages and ratios
  • Applying groupings to database
  • Formulas in Excel Chart
  • Layout of the Chart
  • Learning the show data table
  • Different types of columns
  • Understanding the Horizontal Bar Charts
  • Pie charts for arts and graphics
  • Label positioning in pie chart
  • Line charts for trends over time
  • Different options in Line charts
  • Analyzing on the Doughnut chart
  • Area chart for illustrating the magnitude
  • Variation in bubble chart
  • Rating and tenure in bubble chart
  • Surface or surface area chart
  • Example in surface chart
  • Learning the Pyramids chart
  • Example in Pyramid chart
  • Mosaic or Mekko charts
  • Graphical method in Radar chart
  • Sunburst chart a multilevel pie chart
  • Factors in Sunburst chart
  • Aspect of Scatter plot
  • Histogram a part of piechart
  • Combo charts for arts and graphics
  • Dashboard Chart
  • Dashboard Chart Continue
  • Thermometer Chart
  • Map Chart
  • Tips to Make Your Graph Perfect
  • Deciding Which Type of Chart to Use
  • Sparklines
  • Sparklines Continue