Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Unleash Your Microsoft Excel Skills to an Advanced Level
Course Material Works in Excel 2007, 2010, 2013 and 2016
Using my 10+ years of Microsoft Excel training I will guide you through some of the most advanced tools Excel has to offer, including;
By engaging and completing this advanced Microsoft Excel course you will master tools that will blow the socks off of your boss and coworkers. You will learn how using these tolls will ultimately streamline you Excel experience boosting your productivity to the highest level.
Each section within this course also includes 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 and become an Advanced Excel Guru!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Microsoft Excel 103 Course Introduction|
Introduction to Topics in this CoursePreview
Course Exercise Files - Download this Excel File First!
|Section 2: Working with Excel's Conditional Functions|
Working with Excel Name RangesPreview
Using Excel's IF() FunctionPreview
Using Excel's COUNTIF() Function
Using Excel's SUMIF() Function
Using Excel's IFERROR() Function
|Section 3: Working with Excel's Lookup Functions|
Using Excel's VLOOKUP() Function
Using Excel's HLOOKUP() Function
Using Excel's INDEX() and MATCH() Functions
|Section 4: Working with Excel's Text Based Functions|
Using Excel's LEFT(), RIGHT() and MID() Functions
Using Excel's LEN() Function
Using Excel's SEARCH() Function
Using Excel's CONCATENATE() Function
|Section 5: Auditing an Excel Worksheet|
Tracing Precendents in Excel Formulas
Tracing Dependents in Excel Formulas
Working with the Watch Window
|Section 6: Protecting Excel Worksheets and Workbooks|
Protecting Specific Cells in a Worksheet
Protecting the Structure of a Workbook
Adding a Workbook Password
|Section 7: Mastering Excel's "What If" Tools|
Working with Excel's Goal Seek Tool
Working with Excel's Solver Tool
Building Effective Data Tables in Excel
Creating Scenarios in Excel
|Section 8: Automating Repetitive Tasks in Excel with Macros|
Understanding Excel Macros
Activating the Developer Tab in Excel
Creating a Macro with the Macro Recorder
Editing a Macro with VBA
Creating Buttons to Run Macros
|Section 9: Congratulations!|
Congratulations on Completing the Microsoft Excel 103 - Advanced Coruse
BONUS - Special Offer! Discount on any of my courses!
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!