Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel Mastery: Beginner to Pro Success

Name: Microsoft Excel Mastery: Beginner to Pro Success
Rating: 4.4 (26 reviews)

Unlock Excel Mastery: Learn Efficient Navigation, Formulas, Formatting, and Advanced Functions for Success.

Created byYassine Blh

Last updated 3/2024

English

What you'll learn

Master Excel Fundamentals: Navigate Excel confidently, utilize the ribbon, and grasp essential keyboard shortcuts for efficient spreadsheet management.
Effective Data Formatting: learn to format data easily, resize rows, apply font and number formatting, creating polished and professional-looking spreadsheets.
Formula Proficiency: Master formulas, troubleshoot, understand absolute and relative references, and confidently use formulas like SUM VLOOKUP and IF functions.
Advanced Data Manipulation: Explore advanced functions (TEXT, SUBTOTAL), efficiently manage and analyze data, including text extraction and custom sorting.

Course content

9 sections • 58 lectures • 5h 10m total length

Day 1: Excel Essentials for Beginners4:56
Day 2: the RIBBON - Exploring what it is and what is on it11:39
Day 3: UNDO and REDO - learn the basics1:49
Learn the basics of undo and redo in Excel with the quick access toolbar or back and forward arrows. Use keyboard shortcuts ctrl+z and ctrl+y to navigate recent actions.
Day 4: COPY and PASTE - the basics of using the clipboard in Microsoft excel4:43
Day 5: FIND and REPLACE2:18
Master find and replace in Excel to update values and fix spellings, using Ctrl+H, find next, and replace all, with options for sheet or workbook scope, formulas, case, and formatting.
Day 6: KEYBOARD NAVIGATION - work in excel using just your keyboard5:52
Navigate an Excel workbook using the keyboard to move between cells with arrow keys, edit formulas with F2, and use Enter, Shift+Enter, and Shift+Tab for quick navigation and switch worksheets.
Day 7: KEYBOARD SHORTCUTS - some of my most used shortcuts8:44

Day 1: RESIZING rows and columns - viewing your data in excel4:05
Day 2: FONT FORMATTING - learn the basics2:56
Explore basic font formatting in Excel, including changing font type and size, applying bold, italics, and underline with shortcuts, and using color fills and custom RGB to style headings.
Day 3: NUMBERS FORMATTING - learn the basics4:28
Explore formatting numbers in the home tab, applying currency and accounting formats, adjusting decimals and thousand separators, and converting values to percentages and date formats.
Day 4: CELL ALIGNMENT - learn the basics4:36
Day 5: FORMATTING from the home tab - preset options2:10
Day 6: Cell FORMATTING Learn how to add borders, colours and patterns4:16
Discover advanced cell formatting in Excel, including borders, shading, colors, and patterns. Learn to use the format cell box (Ctrl+1) and fill tab, and see how conditional formatting enhances visuals.
Day 7: SORTING and FORMATTING - the basics4:49

DAY 1: PRINTING EXCEL - using WORKBOOK VIEWS to setup your print!4:01
Learn to prepare worksheets in Excel by using workbook views, page break preview, and page layout to fit data on one sheet, adjust margins, scale, and add headers or footers.
DAY 2: WORKSHEETS options and working with several Excel Tabs5:26
DAY 3: EXCEL BASICS - AUTOFILL and inputting data2:54
Master autofill and inputting data in Excel by dragging to extend dates and formulas across rows and columns, and use paste special and shortcuts to copy formulas down and right.
DAY 4: FLASH FILL - learn how to use it!3:09
Master the flash fill feature in Excel to quickly separate first and last names and fill data across columns, using the home tab's editing group.
DAY 5: EXCEL DROP DOWN LIST - tutorial for beginners5:12
DAY 6: TRANSPOSE - find out how with this free excel tutorial3:24
DAY 7: IMPORT data from the web - learn how with this excel tutorial3:08
DAY 8: Naming data in excel and how to use in formulas and lists (named ranges)18:37

Day 1: FORMULAS and OPERATORS Learn the basics of Excel formulas and functions9:23
Day 2: SUM and SUMIF formulas - the basics of adding in Microsoft Excel4:32
Day 3: FORMULAS - Understanding basic division in Excel1:57
Day 4: ABSOLUTE and RELATIVE cell references6:07
Day 5: ABSOLUTE CELL REFERENCE: learn the shortcut!3:10
Day 6: FUNCTIONS - SUM, AVERAGE, COUNT and COUNTA8:10
Day 7: ERROR checking and calculating FORMULAS8:07

Day 1 : IF function - learn how to use it with our introduction tutorial4:27
Day 2 : IFERROR function - learn the basics with our excel tutorial1:59
Day 3: VLOOKUP tutorial: everything you need to know about VLOOKUP in Ms Excel2:51
Day 4 : VLOOKUP tutorial: learn to VLOOKUP with approximate values3:32
Day 5 : AND function - learn how to use it with our beginners tutorial!2:10
Day 6: OR function - learn how to use it with our beginners tutorial!2:00
Day 7: NOT function - learn how to use it with our beginners tutorial1:27
Day 8 : What is XLOOKUP and why is it a good alternative to VLOOKUP?8:30
Day 9 : XLOOKUP & Named Ranges: use them together to read functions easily6:47
Master XLOOKUP and named ranges to clarify what you look up in a workbook, replacing VLOOKUP and HLOOKUP with readable, named ranges and table data.

Day 1: TRIM function - Introduction2:04
Day 2: SUBTOTAL function - Explained!8:53
Day 3: ROUND, ROUNDDOWN and ROUNDUP functions - how to use them4:15
Day 4: MAX and MIN functions - learn how to find largest and smallest values2:09
Learn how to use Excel's max and min functions to find the largest and smallest values in a range, ignoring empty cells, with practical scoring examples and cross-column use.
Day 5: TEXT function - Explained !5:34
Master the text function to convert numbers to text, format dates as month and year or with two-digit year, display currency with the pound symbol, and concatenate values with text.
Day 6: LARGE and SMALL functions - how to find find and sort values by position4:52
Day 7: TODAY and NOW functions - how to use them with conditional formatting3:56

Day 1: UPPER, LOWER and PROPER functions (Changing sentence case in Excel )3:13
Day 2: Extracting text using LEFT, RIGHT and MID in Excel4:03
Day 3: Basics of the FIND and SEARCH functions in Excel3:40
Learn how to locate a character in a cell with the find and the search functions in Excel, including start positions and the caption's case sensitivity differences.
Day 4: Combining the FIND and MID functions in Excel3:35
Day 5: How to create a CUSTOM SORT LIST in Excel3:45
Day 6: SUMIF and How to fix issue with DATA SORTING.5:07
Day 7: using the RANK function in Excel3:29
Day 8: Advanced drop down lists with dynamic array formulas UNIQUE & FILTER4:48
Day 9: Dynamic array functions - FILTER function, the basics (Advanced filter)6:24

Requirements

No prerequisites! This course welcomes beginners. All you need is a computer with Microsoft Excel installed. Whether you're new to Excel or looking to enhance your skills, this course is designed for easy understanding and practical application.

Description

Excel Mastery: Elevate Your Skills, Transform Your Success!

Unlock the full potential of Microsoft Excel with our dynamic course designed for beginners and aspiring pros!

Dive into a hands-on learning adventure, mastering efficient navigation, formulas, and formatting. Whether you're starting fresh or aiming to level up, this course ensures you become a proficient Excel user.

What You'll Learn:

Week 1: Master Excel basics and navigation.
Week 2: Dive into essential formatting options.
Week 3: Learn data input, viewing, and management.
Week 4: Excel formulas and functions tips.
Week 5: Commonly used functions (IF, VLOOKUP, etc.).
Week 6: Visualize data with charts and illustrations.
Week 7: Advanced functions exploration.
Plus : Pivot tables, conditional formatting, and more.

Excel Version Compatibility: This course caters to Excel 2019, Excel 2016, and Excel for Microsoft 365, ensuring universal applicability with Excel 2010 and 2013. A comprehensive Power Query guide is included.

What You'll Master:

Efficient Navigation: Sail through Excel effortlessly with essential shortcuts.
Formulas & Functions: From basic operators to advanced functions like VLOOKUP and IF.
Advanced Techniques: Dynamic arrays, SUMIF, and dynamic dropdowns for next-level mastery.
Data Manipulation: Text transformation, custom sorts, and resolving sorting issues.

Why Excel Mastery?

Practical Learning: Real-world examples for hands-on proficiency.
Easy-to-Understand: Clear, engaging, and beginner-friendly content.
Proven Success: Join countless learners who've mastered Excel with our course.

Who's It For?

Beginners eager to grasp the Excel essentials.
Intermediates looking to polish and enhance their skills.

Why Choose This Course?

30-day money-back guarantee for risk-free learning.
Lifetime access to watch anytime, anywhere.
Receive a valuable certificate upon course completion for your resume.

What Awaits You? Unleash your Excel potential, boost your career, and stand out in a data-driven world. Enroll now and let's chart your course to Excel mastery together!

Invest in your Excel mastery journey today!

Enroll now and see you on the inside!

Who this course is for:

This course is ideal for beginners and intermediate users seeking to master Microsoft Excel. Whether you're a student, professional, or anyone wanting to enhance spreadsheet skills, this comprehensive course provides a step-by-step guide to unlock the full potential of Excel for personal and professional use.

Microsoft Excel Mastery: Beginner to Pro Success

What you'll learn

Explore related topics

Course content

Week 1: Excel Basics for Beginners7 lectures • 40min

Week 2: Basic formatting options in excel7 lectures • 27min

Week 3: Inputting, Viewing, and Managing Data8 lectures • 46min

Week 4: Introduction to functions and formulas7 lectures • 41min

Week 5: Commonly used FUNCTIONS in Excel (IF, IFERROR, VLOOKUP, AND, OR & NOT)9 lectures • 34min

Week 6: More Functions in Excel7 lectures • 32min

Week 7 :Managing data with functions and sorting data9 lectures • 38min

Week 8 : Mastering Pivot Tables and Pivot Charts3 lectures • 51min

Excel Mastery: Your Journey to Success1 lecture • 1min

Requirements

Description

Who this course is for: