Microsoft Excel 2024 - Beginner To Advanced In 3 Hours
Published 9/2024
Duration: 1h56m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.15 GB
Genre: eLearning | Language: English
==========
Unlock the Power of Excel: From Basic Formulas to Advanced Data Analytics. Learn and Apply Excel Formulas Effectively
What you'll learn
Become a Pro in Excel in less than 3 hours
Learn Advanced Microsoft Excel Techniques
Seamlessly create functional Reports, Charts and Pivot Tables
Save time through report automation
Craft powerful and dynamic formulas from scratch
Easy-to-follow, Step-by-Step Lessons
Requirements
No prior experience required - Covers everything from the bascis.
Compatible with any version of Excel - 2013, 2016, 2019, 2021 (Microsoft 365)
Description
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 you already know or how little you know.
We practice with real-life examples to make learning fun and useful.
What you'll learn in this course
Basic Number Functions
How to calculate percentages
Sorting Data - Single Level, Multi Level, Custom List, Own List, Icons (Colors Coding), How to Unsort Data
Filter - Basic Filter and Advanced Filter (including Regex's and IF/OR Conditions)
Data Validation - How to create a list, how to create text and date validations, and create a Dynamic List with Excel Tables.
Cell Reference - Relative, Absolute, and Mixed Referencing
IF Functions - SUMIF(S), COUNTIF(S), IF, Nesting IF with AND / OR Function
Lookup Functions - VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP
Text Functions - Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, Text
Flashfill - How to use FlashFill correctly
Custom Number Formatting - How to Format Numbers with your own custom icons and present data efficiently
Pivot Tables - Basics of Pivot Tables including Conditional Formatting
Pivot Tables - Slicers - Intro to creating Dashboards with Pivot Tables and Slicers
SUMIF(S) & COUNTIF(S) - Using custom conditions/criteria. Eg. Regex Match
Lookup - Extract data based on Regex Match, otherwise known as Wildcard Lookup.
Index & Match with Multiple Headers - Use Index & Match when you have more than 1 header in your dataset
Array Formulas - Learn to use formulas like - UNIQUE, FILTER, and SORT
Embark 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!
Who this course is for
Anyone trying to get better with Excel
Anyone using excel for more than an hour in a day
Looking for a simple, structured and interactive training
Anyone looking to upskill personally or professionally
Who wants to become the Ultimate Excel Ninja
Homepage
Screenshots
Reply With Quote
