Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Name: Microsoft Excel 2016 Bootcamp - Zero to Hero Training
Author: Daniel Scott

Daniel Scott, Adobe Certified Trainer & UI/UX Expert

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

125 students are watching this class

Project Description

Download the exercise files here

Create a quote & invoicing form. Cleaning & formatting messy imported data. Inventory spreadsheet. Pivot tables Regional Sales Report Profit & loss spreadsheet. GST & Tax calculations Graphs for use in Word, PowerPoint, InDesign & Illustrator Creating spreadsheets that work within Word documents.

See more less