Excel Tables 5 – Good Data Checklist
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify
Because of these two villains, millions of people waste their life struggling in Excel. Read on to find out how to handle them and eliminate them from your life.
Existing formatting is not removed by Table Auto-Formatting. Here is how to handle the situation.
Select regular data and choose Insert – Tables or Press CTRL T. Agreed. But there is more to it. Read on to find out the nuances…
This is a series about Excel Tables. I have covered this topic in the past but now we need more details. So let us start at the beginning. What are
Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge
Presentation download with reference links Download the Presentation (3 MB). I have added lots of links to related articles and external references including books written by stalwarts in Excel analytics
Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions. Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60
Data Analytics Webinar In just one hour, learn how to gather data, how to clean it quickly and smartly, how to summarize, visualize and analyze it and share your results
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
