The Excel Advantage - Basic to Advanced Microsoft Excel

Name: The Excel Advantage - Basic to Advanced Microsoft Excel
Rating: 4.4 (22 reviews)

Microsoft Excel Course compatible with MS Excel and suitable for beginners and intermediate users

Created byKenneth Ogbebor

Last updated 11/2022

English

English [Auto],

What you'll learn

Build a solid understanding on the Basics of the Microsoft Excel software
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, Pivot Tables and Pivot Charts
Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
Create Interactive Dashboards, applying slicers

Course content

3 sections • 19 lectures • 4h 35m total length

Introduction14:58
Explore the Excel interface and navigation, from the ribbon and menus to cells, worksheets, and quick access toolbar. Learn how to use the status bar, zoom, and basic workbook structure.
Entering Data19:17
Enter data into Excel cells by clicking, typing, and using enter or tab; use the formula bar for edits, autofill for series, and undo to correct mistakes.
Working with Rows and Columns16:47
Learn to work with rows and columns in Excel, and use selection, moving, and copying to manage cells, insert and rename worksheets, and hide or unhide worksheets.
Copying and Moving Data6:41
Master copying and moving data in Excel using copy, cut, paste, and drag-and-drop, including keyboard shortcuts and text box insertion for organizing data.
Formatting Worksheets24:23
Master Excel formatting to make data legible and print-ready by adjusting fonts and colors, merging titles, applying borders, wrapping text, setting currency, and alignment.
Conditional Formatting10:06
Explore conditional formatting in Excel by applying color, icons, and custom formats to cells based on values, text, or database rules, including top/bottom and duplicate highlights.

Text and Data Cleaning Functions27:38
Master text and data cleaning in Excel using find and replace, remove duplicates, flash fill, and essential text functions, plus text-to-column and paste values.
Working with Data- Sort and Filter11:52
Convert a data range to a table to enable sorting and filtering in Excel; use headers, table styles, and multi-level sorts by date, region, or product.
Basic Calculations15:51
Master basic Excel calculations by writing your first functions, using sum, average, max, min, and count, while exploring auto sum and dynamic ranges.
Basic Calculations 26:11
Learn to perform salary schedule calculations in Excel, including total deductions, monthly and annual net pay, weekly pay, and deduction percentages, using drag copy and dynamic updates.

Data Validation12:54
Learn data validation in Excel to restrict cell inputs with ranges and drop-down lists, set input messages and error alerts, and enforce limits like registration numbers between 200 and 300.
Named Ranges11:25
Learn to create and use named ranges in Excel with the name manager, enabling faster, clearer formulas for cost of goods sold, sales price, profits, and averages.
Cell Reference22:11
Explore the four cell references in Excel—relative, direct, absolute, and mixed—and learn how formulas adjust when copying data.
Paste Special and Transpose11:56
Explore paste special and transpose in Excel: paste values, transpose data via array formula (ctrl-shift-enter), and dynamic direct reference with find and replace.
Logical Function14:08
Learn to use Excel's logical functions, starting with the if function, to test conditions like gender, experience, and education, returning bonuses or adjusted salaries, and applying countif, sumif, and averageif.
Tables and Running Total6:21
Convert your data range to a table using the insert tab, with headers, then apply table styles and automatic formatting as you calculate a running total with a sum formula.
Data Entry Form6:04
Convert your data to a table and use a data form on the Quick Access toolbar to enter multi-column records quickly and accurately in Excel.
Charting15:26
Master charting in Excel by selecting appropriate chart types—from pie and bar to combo and column—edit, format, and apply recommendations to convey data clearly.
Printing and Sharing21:18
Master printing and sharing in Excel by setting print areas, adjusting margins and orientation, inserting page breaks and repeatable titles, and exporting to pdf for easy client-friendly documents.

Requirements

A computer or laptop with Windows (some techniques might not work on Mac)
No prior Excel knowledge is needed.
Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details)
Willingness to learn.
Let's do this!

Description

Description

Get the Excel Advantage.

Knowledge of Excel will set you at an advantage on the job, in your business or as a freelancer.

This course will give you a complete understanding of the basics of Excel from the interface and features, through intermediate functions and formulas to advanced excel functions and analytics.

This course will not teach you formulas and functions in isolation, instead you will learn through practical application of the Excel formulas and functions.

By the end of the course, you will be able to write simple, complex and elegant formulas from scratch.

This will help you to:

Easily calculate and analyze data with Excel.
Easily build dynamic tools & Excel dashboards to filter your data
Create your own formula-based Excel formatting rules
Manipulate dates, times, text, and arrays
Create charts and visuals in Excel

We'll dive into a broad range of Excel formulas & functions, including:

Statistical functions
Formula-based formatting
Date & Time functions
Logical operators
Dynamic Array formulas
Text functions

I have seen the power of Excel in the course of my work as an Engineer and it give me great joy to teach others the immense power and functionality of Excel.

My teaching style is practical, conversational, authentic and to the point, and I help student grasp complex concepts in a way that is clear and easy to comprehend.

If you're looking for the ONE course with all of the basic and advanced Excel formulas and functions that you need to know to use Excel to your advantage, you've found it.

See you in the course!

-Kenneth Ogbebor

Who this course is for:

This course is for everyone looking to take their Excel skills from beginner or intermediate level to advanced level and beyond.
It is good for people looking to pursue a career in data analytics, business analytics or similar fields
Excel users looking to build powerful analytical thinking and business intelligence skills
Excel users hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

The Excel Advantage - Basic to Advanced Microsoft Excel

What you'll learn

Explore related topics

Course content

INTRODUCTION TO MICROSOFT EXCEL6 lectures • 1hr 32min

WORKING WITH EXCEL4 lectures • 1hr 2min

ADVANCED EXCEL9 lectures • 2hr 2min

Requirements

Description

Who this course is for: