Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Daniel Scott, Digital Designer & Premiere specialist!

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

      1:43
    • Exercise Files

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

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

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

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

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

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

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

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

      3:52
    • Using pre made templates

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

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

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

      2:25
    • Remove duplicates in Excel 2016

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

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

      2:29
    • Repeating formulas in Excel

      2:31
    • Practise exercise

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

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

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

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

      17:23
    • Excel 2016 Cheat Sheet & Shortcuts

      4:29