Overview

Learn everything about Microsoft Excel, from the basics to the super advanced stuff, in this online course. After taking this class, you'll become an Excel expert!Here's how it works:We explain Excel in a simple way so it's easy to understand.We go through all the tools and features in Excel, paying close attention to details.We follow a step-by-step approach. So that it's easier for you to grasp all the concepts.This course is made for everyone, no matter how much or little you already know.We practice with real-life examples to make learning fun and useful.Topics covered in the course:Basic Number FunctionsHow to calculate percentagesSorting Data - Single Level, Multi Level, Custom List, Own List, Icons (Colors Coding), How to Unsort DataFilter - Basic Filter and Advanced Filter (including Regex's and IF/OR Conditions)Data Validation - How to create a list, text and date validations, and a Dynamic List with Excel Tables.Cell Reference - Relative, Absolute, and Mixed ReferencingIF Functions - SUMIF(S), COUNTIF(S), IF, Nesting IF with AND / OR FunctionLookup Functions - VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUPText Functions - Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, TextFlashfill - How to use FlashFill correctlyCustom Number Formatting - How to Format Numbers with your custom icons and present data efficientlyPivot Tables - Basics of Pivot Tables including Conditional FormattingPivot Tables - Slicers - Intro to creating Dashboards with Pivot Tables and SlicersSUMIF(S) & COUNTIF(S) - Using custom conditions/criteria. Eg. Regex MatchLookup - Extract data based on Regex Match, or Wildcard Lookup.Index & Match with Multiple Headers - Use Index & Match when you have more than 1 header in your datasetArray Formulas - Learn to use formulas like - UNIQUE, FILTER, and SORTEmbark on a journey into the world of Excel with our genuine passion for sharing knowledge. In this Udemy course, we cover everything from basics to advanced topics, offering hands-on practice with spreadsheets. We guarantee to turn you into an advanced Excel user. Suitable for people with all skill levels, we focus on practical learning, emphasizing the importance of practice, a readiness to learn new methods, and the application of skills to real-world scenarios. Take this course to get a head start on your path to becoming an Excel pro!

Skills

Reviews