Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas
Offered By: The Organic Chemistry Tutor via YouTube
Course Description
Overview
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 .
Taught by
The Organic Chemistry Tutor
Related Courses
Análisis de datos: Llévalo al MAX()Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera