Excel 2016 from Scratch tutorials

• Introduction to the tutorials

• Terms, navigation and other basics you need to know if you have never used Excel before
  • Introduction and navigation
  • Columns, rows and navigation
  • Enter values in cells
    
    
• Copy
  • Copy cell data by Filling Right or Down
  • Copy Cell Data
    
    
• Format cells
  • Format cells according to content
  • Create Text Boxes
  • Conditional Formatting
    
    
• Formulas
  Use Excel formulas that calculate cell values
  • Introduction to formulas
  • The benefits of using formulas
  • Calculate house costs with formulas A
  • Calculate house costs with formulas B
  • Calculate house costs with formulas C
  • Calculate sums A – Exercise
  • c Calculate sums B – Exercise
  • Calculate sums C – Exercise
  • Calculate sums D – Exercise
  • Calculate house costs with formulas D
  • Relative Cell References – Exercise
  • Multiply cell values – Exercise
  • Percentage and sums – Exercise
  • Maximum, minimum and average values – Exercise
  • Calculate Sum, Total, Max and Min – Exercise
  • Sum, Average, Max and Min – Exercise
  • Formulas – repetition – Exercise
  • Sums, Max, Average, Median – Exercise
  • Time Differences Max, Min and Median – Exercise
  • Bind Datasheets A – Exercise
  • Bind Datasheets B– Exercise
  • Absolute Reference – Exercise
  • Lock cells – Exercise
  • Unlocked input cells – Exercise
  • The Logical IF Function – Exercise
  • Vertical Lookup A – Exercise
  • Vertical Lookup B – Exercise
  • Vertical Lookup C, Fuction Guide
  • Vertical Lookup D, Search – Exercise
  • Custom Number Formats A
  • Custom Number Formats B – Exercise
  • Modify Numbers – the TRUNC and ROUND functions – Exercise
  • What-If-Analysis A – Scenario Manager, Goal Seek, Data Table
  • What-If-Analysis B – Exercise, Scenario Manager
  • What-If-Analysis C – Exercise, Scenario Manager, Goal Seek
    
    
• Visualization, charts
  • Quick Analysis – Exercise
  • Visualization A – Exercise
  • Visualization B – Exercise
  • Visualization C – Exercise
  • Visualization D – Exercise
  • Visualization E – Exercise
  • Visualization F – Exercise, Repetition
  • Visualization G – Exercise, Charts and Sparklines
  • Visualization H – Exercise, Table, Subtotal, Slicer
  • Visualization I – Exercise, Pivot Table, Grouped View
  • Visualization J – Exercise, Pivot Table and Graph, Slicer
  • Visualization K – Exercise, Pivot Table and Graph, Databars, Slicer
  • Visualization L – Exercise, Slicers, Pivot Table and Chart
  • Visualization M – Exercise, Pivot Table and Chart, Conditional formatting
  • Visualization N – Exercise, Pivot Data Validation, Pivot Table and Chart
  • Visualization O – Exercise, Pivot Table and Chart, Percentage
  • Timeline
  • Power View
    
    
• Miscellaneous
  • Import Text
  • DAVERAGE and DSUM Calculation + Visualization – Exercise
  • Time Spans and Averages Calculation + Visualization – Exercise
  • Week Days and Numbers + Visualization – Exercise
  • Conditional Formatting with Slider – Exercise
  • Export to SharePoint – Exercise
  • Create a team calendar in Excel