Microsoft Excel 2016 Bootcamp - Zero to Hero Training
Daniel Scott, Adobe Certified Trainer & UI/UX Expert
-
-
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
-