Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Discover 30 essential Excel 2016 tips, tricks, shortcuts, functions, and formulas in this comprehensive video tutorial. Learn time-saving techniques such as AutoFill, Flash Fill, and quick shortcuts for saving and printing. Master data manipulation with Text to Column, sorting, and filtering. Explore powerful functions like VLOOKUP, CONCATENATE, and various statistical operations. Enhance your spreadsheet skills with formatting shortcuts, conditional formatting, and chart creation. Ideal for both beginners and intermediate Excel users, this tutorial provides practical knowledge to boost productivity and efficiency in spreadsheet management.

Syllabus

1. Excel AutoFill Tutorial .
2. Flash Fill .
3. Quick Save Shortcut .
4. Quick Print Shortcut .
5. New Workbook Shortcut .
6. Concatenate & TextJoin Functions .
7. Text To Column .
8. Transpose Columns to Rows .
9. Sorting Data .
10. Filtering Data .
11. Freeze Rows and Columns With Freezepanes .
12. Extract Text From Cells Using The Left, Mid, and Right Functions .
13. AutoSum Function .
14. The Average Function .
15. Count, CountA, & CountBlank Functions .
16. Basic Math Operations - Addition, Subtraction, Multiplication, Division, Exponents, & Square Roots .
17. Basic Statistics - Max, Min, Median, Mode, & Standard Deviation Functions - .
18. Show Formulas - .
19. Excel VLookUp Function - .
20. Drop Down List With VlookUp - .
21. Shortcut Keys - Bold, Italicize, Underline & Strike through .
22. Insert Line Break Shortcut .
23. Autofit Column Width .
24. Insert Rows and Columns .
25. Moving Rows and Columns .
26. Find and Replace Tutorial With Shortcut Key .
27. Lowercase, Uppercase, & Proper Functions .
28. Excel Calendars .
29. Conditional Formatting .
30. Line Graphs & X Y Scatter Charts With Trendlines and Slope-Intercept Equations Plus The Forecast Function .