{"id":1232,"date":"2022-02-20T07:18:26","date_gmt":"2022-02-19T23:18:26","guid":{"rendered":"https:\/\/www.excelchamp.net\/?page_id=1232"},"modified":"2022-02-20T22:18:34","modified_gmt":"2022-02-20T14:18:34","slug":"excel-data-analysis-waitinglist","status":"publish","type":"page","link":"https:\/\/www.excelchamp.net\/excel-data-analysis-waitinglist\/","title":{"rendered":"Excel Data Analysis MasterClass: Waiting List"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Registration For \nData Analysis With Excel MasterClass \nis Closed Currently.\n<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Join The Waiting List<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

If you want to be the first one to get notified once we launch, please sign up for the waiting list here.<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n<\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

The Challenges of Data Analysis <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Data analysis can be hard. Whenever my boss used to give me some data and ask me to analyze it and present the findings<\/em>\u00a0to him in a matter of hours or a few short days, I dreaded it. I had no clue where to start, what to do, and what to present…<\/p>

If someone asks me to sort the data, filter it, or add it all up, I understand, and I can do it quickly. These are tangible things that can be easily achieved.<\/p>

But when it comes to \u201canalyzing data\u201d, I was completely clueless. There used to be no magic formula that could quickly analyze the data in Excel. So I\u2019d stare at the data, hoping to find some hidden insight that would emerge magically.<\/p>

\"A<\/p>

You see, one can spend 2 hours or 2 days or 2 months or even 2 years analyzing data, and still be looking for insights. There is no clear indication that the analysis is now complete.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

How I Stumbled Upon the Data Analysis Techniques<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Back in the early 90’s, there was no Internet, no Google, and really not much help was available. So I’d pour over the F1 Help within Microsoft Excel. I devoured the whole manual a couple times, searching for Data Analysis Techniques. There was no mention of data analysis anywhere… \ud83d\ude41<\/p>

But I began to find some formulas that could help me find the things I was looking for. So I experimented with them, and tried many features. With some trial and error, I began to get a hang of it.\u00a0<\/p>

I was wondering, Why doesn’t Microsoft have a section for “Data Analysis” within Excel?\u00a0<\/p>

Actually, Excel has hundreds of hidden features that are extremely helpful in everyday management decision making and data analysis, but they are not labelled as such.\u00a0<\/strong><\/p>

After all, Microsoft is more of a software company that keeps adding features, but they don’t teach people how to use them, or how to use them effectively for data analysis.<\/p>

It is up to us to figure out the how…<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

Microsoft Excel Comes To The Rescue<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

It is not difficult to learn how to analyze data with Microsoft Excel, once you learn a few tips and tricks, formulas, and hidden features of Excel well. <\/span><\/p>

Actually, as I spent the time looking for insights, I experimented with several Excel features, and began to find amazing results that almost everyone overlooked, or simply didn\u2019t notice.<\/span><\/p>

As I began to find these insights and started to present them to the management, they started to notice. Soon I was consistently generating ideas based on solid data analysis, and not by just “gut feel”.<\/p>

Others were amazed at how I was able to garner amazing insights from the same dataset that they had, but could not find anything interesting.<\/p>

As I tried different methods, began to play with data & do all things data – cleanup, reporting, data visualization and began finding insights, I was amazed at how most people ignored the simplicity of Excel and were always looking for the tool that will analyze the data for them.<\/p>

They did not look at Excel as a Data Analysis Tool.\u00a0Instead, they went from Crystal Reports to Hyperion, to Informatica, to Business Objects, to SAP, SAS, QlikView, Tableau and Power BI<\/strong><\/em> type of “Business Intelligence” tools.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

It's Not the Tool, but what you do with the tool that makes the difference.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Sadly, most companies do not have the budget for these expensive BI tools, or the time to learn the intricacies of bringing in the data, creating the \u201ccube\u201d, data model, and creating the reporting views.<\/p>

As such, the adoption of such BI tools is pretty minimal, and a year later, they are sitting on a shelf. And most people are either looking for an new, simpler tool, or are back at using Microsoft Excel.<\/p>

The management was impressed by my insights and asked me to teach others in my department. I was already doing it… I was also tasked to setup a Reporting practice within the company, and teach Data Analysis to all Executives and Managers within the company.\u00a0<\/p>

\"Data<\/p>

I enjoyed this job the most. I got all the time to find more and better ways to analyze data and loved to share the gems that I found with my colleagues.<\/p>

Over the years, I rose in this Reporting role to become the Director of Business Intelligence, overseeing a team of over 250 professionals that I had personally groomed into being excellent data analysts that helped our company grow fastest with exponential growth due to its edge in data analytics and information science.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

I Can Help You Become a Better Data Analyst Too!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

I am here to help you Become a Better Data Analyst<\/strong>.<\/p>

Yes. Now you can learn to analyze data like a pro and amaze your clients and colleagues too!!!<\/em><\/strong><\/p>

I’ll teach you the Key Tools, Techniques, Shortcuts, and my Trademark “secrets” that can help you to analyze any data within minutes, and present it like a Pro!<\/em><\/p>

Here, I’d like to Introduce my Data Analysis With Excel MasterClass<\/em> to You, which has helped thousands of Executives, Managers, and Data Warriors like you over the past 30+ years.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

Data Analysis With Excel MasterClass For You<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

The Data Analysis With Excel is a 6 week live online course<\/strong> where I\u2019ll teach you everything I know about how to analyze data – from importing it, to cleaning & analyzing the data, to converting it into actionable information.<\/p>

The course consists of weekly lectures and assignments<\/strong>.<\/p>

Each week, we\u2019ll have a combination of live Zoom lectures, Q&A Office Hours, and homework assignments<\/strong> to help YOU learn the techniques and begin to apply them in your work.<\/em><\/p>

Core Live Lectures will run twice a week, on Mondays and Thursdays at 13:00 GMT \/ 08:00 EST \/ 18:30 IST \/ 21:00 SGT<\/strong>. Each live session will have 60-90 minutes of teaching, followed by an open Q&A with me.<\/p>

All the sessions will be recorded (and you’ll have lifetime access to them) so you can always work through stuff at your own pace if you prefer that approach.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

We're currently closed and preparing for the next Batch of Data Analysis With Excel<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n<\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

By the end of the 6-week course...<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t