Go Beyond the Basics
**************** Course Material Works in Excel 2010, 2013 and 2016 *******************
Ready to take your Microsoft Office Excel skills to the next level? Then you've come to the right course. Enroll now and you will receive step by step mentoring on mastering Microsoft Excel at an intermediate level and beyond. You will learn how to work with some of the most powerful tools Excel has to offer.
Using my 10+ years of Microsoft Excel training I will guide you through these tools preparing you for the most advanced features used my Excel office workers.
At completion of this Excel Intermediate course you will have mastered the above mentioned tools and more, supercharging your Excel knowledge and skills to a whole new level of expertise.
Each section also includes a quiz to test the knowledge you will gain and exercise files for you to download and practice with. These are the same files that are used in the video lectures.
So, what are you waiting for, enroll now and take the next step in mastering Excel on your way to becoming an Excel Guru!
During this lecture you will be introduced to a few key concepts of building an effective and well formatted list in Microsoft Excel
During this lecture you will how easy it is to sort a list by a single column, making the list more accessible and easy to find the data you are looking for
During this lecture you will take sorting a list to the next level by introducing the multi-level sort window. This window will allow you perform multiple column sorts on your Excel lists
During this lecture you will learn one of the hidden features found in Excel, a custom list sort.
During this lecture you will be introduced to using filters to assist in finding specific records in a list.
During this lecture you will learn how to use the built subtotal tool within Excel. With just a little input from you Excel will create the subtotals for you.
During this lecture you will learn how to format a simple list as a table.
During this lecture you will learn how to use conditional formatting to highlight duplicate records in your list
During this lecture you will learn how to remove duplicate records from a list using the remove duplicates feature that was introduced in Excel 2010
Test the knowledge you have learned about working with lists in Microsoft Excel
During this lecture you will learn how to use the DSUM function within an Excel list.
During this lecture you will learn how to use the DAVERAGE function within an Excel list.
During this lecture you will learn how to use the DCOUNT function within an Excel list.
During this lecture you will learn how to use the SUBTOTAL function to create more dynamic calculations.
During this lecture you will learn how to activate the installed PowerPivot AddIn within Microsoft Excel.
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;
Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.
Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.
Some of the clients Kyle has provided training for include:
What Students have said about Kyle:
In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.
Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.
In His Spare Time:
Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!