Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Daniel Scott, Adobe Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
24 Lessons (1h 54m)
    • 1. Introduction

      1:43
    • 2. Exercise Files

      1:44
    • 3. Setting up a US letter or A4 sized page in Excel 2016 so it can be printed

      2:37
    • 4. How to add an image or logo to an Microsoft Excel 2016 spreadsheet

      1:39
    • 5. Adding text to our Excel Quote & aligning text & numbers

      7:16
    • 6. How to display the date correctly in Excel for the month first or month second formats

      3:43
    • 7. Adding borders & lines around cells in Excel 2016

      5:12
    • 8. Use these formulas to calculate a quotation or invoice with sales tax GST or VAT in Excel 2016

      5:26
    • 9. Making a quote or invoice template in Excel 2016

      4:48
    • 10. Printing your Excel quote or invoice to one page plus exporting a Excel PDF for emailing

      3:52
    • 11. Using pre made templates

      1:42
    • 12. Cleaning up Tidy up messy spreadsheets in Excel 2016

      4:02
    • 13. Cleaning up date formatting & currency formatting in Excel 2016

      3:56
    • 14. Remove blank line rows columns from Excel 2016 spreadsheets

      2:25
    • 15. Remove duplicates in Excel 2016

      4:27
    • 16. Splitting or seperating names into separate columns in Excel 2016

      4:17
    • 17. Sorting & Reordering a Excel spreadsheet by name price or date

      2:29
    • 18. Repeating formulas in Excel

      2:31
    • 19. Practise exercise

      2:29
    • 20. How to create a graph in Excel 2016

      7:33
    • 21. Create chart in Excel for use in Word & Powerpoint, InDesign & Illustrator documents

      7:22
    • 22. Microsoft Excel Pivot Table Tutorial for Beginners Excel 2016

      11:00
    • 23. How to make a profit & loss spreadsheet in Excel with drop down menus

      17:23
    • 24. Excel 2016 Cheat Sheet & Shortcuts

      4:29
360 students are watching this class
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

109 of 110 students recommend this class