- How to convert dates into readable form even if you are not an Excel expert.
- Do this 1 thing and it will gurantee that you will save hours off your report generation.
- The more data rows you have, the more time you have to spend working on it, right? Wrong! I will show you how you can literally spend just minutes working on the data whether you have a small or big database.
- 1 trick you must learn to boost your speed by at least 25X.
- 1 way to copy and paste large number of cells in seconds even if you do not have a computer mouse.
- How to identify any value or word in your worksheet instantly.
- Say goodbye to endless hours staring on the computer screen adding up the sales numbers.
- Say goodbye to the countless reports you have to prepare week after week, month after month.
- Say goodbye to drawing charts for your presentation.
- How to tabulate your SUBTOTAL instantly even if you do not know what is Pivot Table.
- 2 ways to group your data into your pre-designated categories.
- Say goodbye to duplicated records in your database.
- What to do if all your data is squeezed into one column.
- Why storing your data in multiple worksheets may not be the best option? And how you can prepare your report in just one minute even if you do not have the data stored in multiple worksheets.
- How to identify which version of Excel you are working with even if you do not go to options.
- How to NEVER create a single chart for your presentation ever again.
- What you should NEVER do when you prepare your data for analysis.
- How to NEVER rank your sales and customers for your receipients ever again.
- The Truth about your data records. Here’s how you should organise your data and generate any reports you want.
I am also going to give you my step-by-step manual which I will show you how to overcome each part of the challenge, from downloading the data from the system to reporting. You will get the chance for me to hand-hold you during the workshop so that you are able to acquire the skill and become effective immediately during the training.
I will personally correct all the wrong Excel habits you have.
As a basic Excel user, you will get to learn the complete guide to analyse any data in your possession. As a seasoned Excel user, you get to pick the parts you like best and build further into what you are already doing.
Either way, you will leave with nothing but 200% FULL CONFIDENCE and CLARITY on data analysis, with your boss loving you ever more.
THIS IS NOT a seminar on basic, intermediate or advanced Excel training course. You can sign up for these courses with any other training company, including NTUC Learning Hub or community centers around Singapore.
THIS IS ALSO NOT the typical Excel course which showed you some tips and tricks on Excel.
This Hidden Secrets of Data Analysis workshop is for ANALYST. This is about cleaning your raw data, turning it into reports and offer powerful insights into the business, without you breaking a sweat to achieve all these.