Excel

Tips and Tricks Microsoft Excel

1 - Rename Worksheet

2 - Ctrl + Enter

3 - Add Serial Numbers to Data Set

4 - Autofit Column Width

9 - Copy Worksheet

6 - Insert Symbols with Charmap

7 - Compare Two Data Sets

8 - Combine Two Strings

12 - Custom Font Color

11 - CSV Single column, many commas

10 - Create a Table

5 - Chage the Case of Text

13 - Customize Status Bar

14 - Data Entry Form Part 1

15 - Data Entry Form Part 2

16 - Date Format change US to UK

17 - Add Drop Down List to Excel Cell

18 - Excel Flash Fill Part 1

19 - Excel Flash Fill Part 2

20 - Excel Text Justify

21 - Change Worksheet tab color

22 - Filter Data using Excel Slicers

23 - Sort Data by Color

24 - Sort Data - Horizontal and Veritcal

25 - Format Painter

26 - Hide Active Window

27 - Show or Hidden Ribbon

28 - Hide the data in Excel cells

29 - Highlight Duplicates Part 1

30 - Highlight Duplicates Part 2

31 - Insert Multiple Rows and Columns

32 - Move Data - Drag and Drop

33 - Generate Random Numbers

34 - Sort Data Randomly

35 - Screen Clipping Tool

36 - Selection using Shift + F8

37 - Multilevel Data Sort

38 - Strikethrough Shortcut

39 - Swap Data - Office Clipboard

40 - Change Theme Color

41 - Transpose Columns into Rows

42 - Transpose Rows into Columns

43 - Undo Levels in Excel

44 - Scroll Lock Key - Arrow Keys

46 - Quick Format - Shortcut Keys

45 - Excel Advanced Find

47 - Show or Hide Columns and Rows

48 - Text to Columns

49 - VLOOKUP Wildcard Search

50 - Excel 3D Maps - Create Video