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