Microsoft Excel 2016 Bootcamp - Zero to Hero Training - Skillshare

Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Daniel Scott, Adobe Certified Trainer & UI/UX Expert

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
147 students are watching this class