Excel 2007 Tips and Tricks

The complete change in the Excel 2007 interface has jolted many Excel users out of their comfort zone as they struggle to locate and familiarize themselves with the regular functions they have been using for many years. Most Excel users tend to stick to the regular functions that they have been using to get their job done and may not be aware of shorter and more productive methods of working with the new version of Excel. As such, more than 30 Tips and Tricks have been specially identified and compiled in this video recording. Each of the Tips and Tricks has the potential of saving you hours of cleaning up the data manually, drastically changing the way you use Excel.

1              Customize The Quick Access Toolbar (QAT)

2              Double Click On The Ribbon To Hide Them

3              Quick Access To Frequently-Used Files

4              Tracking Real-Time Changes With Excel Camera

5              Jump Instantly To The End Of Your Database

6              Searching And Entering Formula With AutoComplete

7              Create Attention Grabbing Comments

8              Using Customised Pictures In Charts

9              Add Pop-Up Comments Using Data Validation

10           Highlight Data All At One Go With Find All

11           Finding Duplicates With Conditional Formatting

12           Filter Dates In Groups

13           Removing Inconsistent Date Format Using TEXT to COLUMN

14           Converting Inconsistent Date Format Using Formulas

15           Highlight Dates Later Than Today Using Conditional Formatting

16           Duplicating Pivot Table On The Fly

17           Removing Email Hyperlinks All At One Go

18           Removing Unwanted Objects All At One Go

19           2 Rows Into One – Part I

20           2 Rows Into One – Part II

21           Convert Dates Using Formula

22           Creating A New Worksheet Using Mouse

23           Filling In Pockets Of Blank Cells With Data

24           Presenting Your Numbers In Coloured Bars

25           Using REPT Formula To Create In-Cell Scale

26           Removing Duplicates

27           Adjusting The Formula Bar Using The Mouse

28           Remove Unnecessary Spaces In The Description

29           Clear All The Filters At One Go

30           Tables, Autofill Formulas, Present Insert Cells, Auto Calculate The Total, Row Numbering

31           Auto-Refresh With Tables And Pivot Tables   47

32         How To Create A Dropdown List – Data Validation, Limit Cell Entry