This Excel class is comprehensive guide during which you will learn a whole host of topics. It represents the most common Excel "stuff" used in modern business and understanding the content within will arguably catapult you into the upper echelon of Excel users.
During the class you will learn by watching the instructor actually demonstrate the topics on screen using annotations to make sure you don't get lost, along with providing full, detailed explanation of the subjects. This class starts at absolute square one, and then gradually walks through the remaining topics explaining the most relevant aspects of Excel in a simple, east, yet light-hearted, fun approach.
The "secret" to Excel is this-- realize there are NO such categories like Basic, Intermediate and Advanced Excel. They simply do not exist. With Excel you learn the basics, from there it's nothing but another layer of fundamentals. Phrased differently, the Excel curriculum is topical, not progressive. Meaning the order in which you learn things does not matter since all the topics are not interrelated. Therefore, knowing this fact, when you look at the class as nothing more than a bunch of individual topics that have been strung together, Excel becomes a breeze!
Last, no matter what version of Excel you are using there has always been some core topics that represent the "need to know". Phrased differently, all the material in this class contains the essentials and is transferable to all versions of Excel- 2007, 2010, 2013 and even 2016. Sure there are some differences between the versions, but they are not so drastic as to really mess you up. :)
In this segment we will look at three functions- the basic IF Statement, the 'IF AND' and IF OR'. If you are unfamiliar with the AND/OR condition, please make sure you watch the "Advanced Filtering | For When The Basic Filter Won't Cut It" tutorial first, since it provides and in-depth explaination of the AND/ OR condition.
Dave McCubbin has been engaged in computer training over the past 15 years and is the founder and CEO of The People's Trainer.com. During which time he has been fortunate to work with many great people, and been able to impact them through his unique, laid-back, fun, yet quirky, learning style. He has trained extensively on domestically and internationally, along with personally training over 100,00 people.
He does not believe in overly polished, eloquent presentations. Rather he focuses on a more conversational approach to learning. Subsequently, he does NOT consider himself and expert by any stretch. Why? Simply because that term reeks of arrogance and is not his modus operendi. Instead he views himself as a perpetual apprentice in the computer field and believes there is always something new to be learned, no matter how long you've been doing "it".
True to form, he would like to thank the people that have mentored him throughout the years.