Overview

Master key Excel functions and features that are in demand today. The Microsoft Excel - Rookie to Confident Crash Course is designed to do exactly what it's called, take you from an Excel Rookie to a Confident Excel User fast.The course will first teach you the fundamental Excel skills you need to learn which will give you the foundation to master Excel. This includes key topics such as:Understanding the Excel InterfaceRelative and Absolute Cell ReferencingKey Excel Terminology You Need to KnowThe Proper way to Write FunctionsOnce you have grasped these key topics we will move on to more advance and powerful features. This will include:Using popular and advance dynamic functions like - VLOOKUP, IF, SUMIFS, IFERROR, INDEX MATCH and more to boost your productivity and make your life easier literally x 100.Apply conditional formatting to highlight key data, help viewers to visually interpret your reports and beautify them.Utilize macros to automate repetitive tasks.Use pivot tables to summarize and obtain key insights from large volumes of data.Learn many other key Excel features that are highly sort after.If you're looking to negotiate a better salary with your Boss or significantly expand your job opportunities this course is great for you. I will use my years of experience as an Excel Solutions Consultant and Corporate Excel Trainer to teach you the key skills and features in Excel you need to know to feel confident.I not only benefited greatly from this course but I truly enjoyed every minute of it! Kerron did a stellar job in teaching with clarity and simplicity. It's super easy to follow along and he is very motivating! Hands down one of the best instructors I have come across in Microsoft Excel, can't wait for the next course! - David SamarooI would 100% recommend this course. Kerron teaches in a clear and easy to follow manner. The course is filled with quizzes and practice exercises and solutions which helps you to be able to apply what you learned in the real world. I am feeling really confident in Excel now! - Kyle RodrickResearch shows that key Excel skills that you should be aware of which this course covers includes:The Fundamentals of Writing FunctionsFinding Data with Lookup FunctionsUsing Logical Functions to Perform Actions Based on ConditionsManipulating Text with Text FunctionsHighlighting Key Data with Conditional FormattingAutomating Tasks with MacrosUsing Pivot TablesWhat's Included in the Course:70 plus videos packed with golden nuggets 5 Hours of concise and to the point topic coverageQuizzes designed to test your understanding and fill in your gapsReal life practice exercises with solutions so you can take what you learned and apply it todayStill reading? This shows that you believe this course provides the knowledge and skills in Excel you want to learn. Then I recommend you enroll because the course delivers everything you read and more. Looking forward to see you inside.Best regards,Kerron DuncanFounder of Excel Galaxy

Skills

Reviews