Play all

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

Description:

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.

Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

The Organic Chemistry Tutor

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Data Manipulation #Spreadsheets #VLOOKUP #Flash Fill

0:00 / 0:00