What are the secret tips or tricks that can make anyone an Excel expert?

Keen Interest and Practice of formulas.

short cut keys and programing

exploring, your willingness into it and interest to know everything!

 

What matters here is the application of whatever you have learned consistently. If its not used, it remains stagnant

Open More Than One File At a Time

1.learning the shortcuts.2.preparing reports.3.shifting sheets.4.compiling and sorting data.5.learning new formulasand trying them on regular jobs

Working with the system, trying things out and not being afraid to fail and ask for help.

Excel is a very good system that has huge possibilities and even getting to know a few by unravelling the formulas contained in work you come across can teach you a lot. 

Get your hands dirty with formulas and enjoy playing with it and soon you will be an expert!

formula and shortcut keys is best ways.

1. Learning the shortcut keys . 2. Preparing reports . 3. Shifting sheets . 4. Compiling & Sorting Data . 5. Learning new formulas and trying them on regular jobs . 6. Browsing helpful websites relating excel operations .

Using short cut keys and clicks

Using shortcut keys as much as possible with the help of inbuilt help itself and using macros of similar routine work, which completes hours of work in minutes and seconds and saves lot of time