Analyze Huge Data with Ease Using Microsoft Excel Filters!

Analyze Huge Data with Ease Using Microsoft Excel Filters!

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.
COURSE DELIVERY STYLE
I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.
WHAT YOU’LL LEARN IN THIS COURSE
This is an technique in Excel which allows you to control, reorganize, filter, trim and manipulate large sets of data with ease. Say goodbye to the days of scrolling through long lists of data. With this function you can you let Excel do the hard work. You tell Excel what type of filtering you want, and Excel does the rest.
I'll be covering in great detail how to set up your data for the filter as well as introducing a tracking technique which preserves the integrity of your data Then I'll show you how to re-organise data alphabetical, by colour, by value, by partial match, by ranking, by percentage and many more. We'll then finish the course off with combinations via the use of Conditional Formatting, Dynamic Charts and Array Fill.
Previous Post Next Post