Excel : A Beginner's Guide to Mastering Excel in 1h30 Mins

Name: Excel : A Beginner's Guide to Mastering Excel in 1h30 Mins
Rating: 4.7 (7 reviews)

From zero to Excel hero—learn the basics, master the essentials, and make Excel work for you

Created bySalah Eddine Sabouni

Last updated 10/2024

English

What you'll learn

Navigate and utilize the Excel interface to manage workbooks and worksheets efficiently.
Enter, format, and organize data in Excel for clear and professional presentation.
Create and apply basic formulas and functions to perform essential calculations.
Develop simple charts, graphs, and PivotTables to analyze and visualize data effectively.

Course content

8 sections • 23 lectures • 1h 22m total length

Welcome and Course Overview2:54
Master essential Excel basics, navigate interfaces, enter and format data, and use formulas and functions. Create charts, analyze data with pivot tables, and apply skills for personal and professional tasks.
Introduction to Excel - Why It's Important2:09
Navigating the Excel Interface3:43
Simple Navigation Practice0:12
Now that we’ve covered the basics of navigating the Excel interface, it’s time to put that knowledge into practice. In this exercise, you’ll get hands-on experience navigating through an Excel workbook. We’ll go through tasks like renaming sheets, using the ribbon to format cells, and adjusting the view

Introduction to Formulas4:09
Master core Excel formulas by learning the equal sign, cell references, and arithmetic operators, then apply auto-updating total sales by multiplying units sold by price per unit.
Basic Arithmetic Operations3:23
Common Functions (SUM, AVERAGE, MIN, MAX), VLOOKUP as a bonus!!9:14
Learn common excel functions such as sum, average, min, max, and the bonus vlookup to quickly calculate totals, identify extremes, and apply data from multiple sheets.
Formulas and Functions Practice0:03
Please download the practice file provided and complete the following tasks step-by-step.

Sorting and Filtering Data6:58
Data Validation4:42
Introduction to Tables3:25
Data Management Practice0:15
Now that we’ve learned how to sort, filter, validate, and manage data using tables, it’s time to put everything together in a comprehensive practice session. In this exercise, you’ll work through a set of tasks that require you to apply everything you’ve learned so far about working with data in Excel.

Download the practice file provided and complete the following tasks step-by-step.

Creating Simple Charts (Bar, Line, Pie) and Customizing Chart Elements15:57
Explore creating bar, line, and pie charts in Excel, customize chart elements, add data labels and comments, and use insights and KPIs to support strategic decisions.
Chart Creation Practice0:08
Now that we’ve learned how to create and customize charts, it’s time to put those skills into practice. In this comprehensive exercise, you’ll create several charts, customize them, and analyze the data they represent

Introduction to PivotTables6:42
Learn to create and customize pivot tables to summarize and analyze data, revealing patterns and trends with fields dragged to rows, columns, filters, and values for quarterly sales.
Basic Data Analysis Techniques5:38
Use Excel's built-in tools to analyze data with functions, conditional formatting, sorting, and filtering. Practice with a beginner exercise using pivot tables on a sales data set.
Data Analysis Practice0:10
Now that we’ve covered basic data analysis techniques, it’s time to put those skills into practice. In this comprehensive exercise, you’ll apply various data analysis tools and techniques to a dataset, allowing you to draw meaningful insights and make informed decisions

Download Your Excel Shortcuts Document0:14
Unlock the full potential of Excel with our comprehensive Excel Shortcuts Document, available in multiple languages! This resource includes an extensive list of keyboard shortcuts for Excel on both Mac and Windows, meticulously organized for easy reference. Whether you're a beginner or an advanced user, you'll find shortcuts for every task, helping you save time and enhance your productivity.

Requirements

No prior Excel experience needed. This course is designed for absolute beginners.
Access to Microsoft Excel (any version) is recommended to follow along with the exercises.

Description

Ready to Finally Conquer Excel? Let’s Do This Together!

Are you tired of feeling lost every time you open Excel? Whether you're completely new to it or just need a refresher, this course is designed to take you from feeling overwhelmed to confidently using Excel in your daily life.

What You’ll Get Out of This Course:

Learn the Essentials: We’ll start with the basics, like navigating Excel’s interface, and move step-by-step through data entry, formatting, and simple calculations.
Practical Skills You Can Use Right Away: By the end of this course, you’ll know how to organize data, create charts, and use formulas that will actually make your life easier—whether you’re managing your personal finances, handling work projects, or studying for school.
Become More Efficient: Discover shortcuts and tricks that will save you time and make Excel feel less like a chore and more like a tool you actually enjoy using.
Make Your Data Look Good: Learn how to turn dull data into eye-catching, professional-looking spreadsheets that you’ll be proud to share.

Why This Course?

This isn’t just another dry, boring Excel course. We’re going to make this fun, relatable, and easy to follow. I’ll guide you through each lesson as if we’re sitting side by side, working on Excel together. No jargon, no complicated tech talk—just clear, simple instructions that anyone can follow.

Who Should Join?

Complete Beginners: If you’ve never touched Excel before, or have but it left you feeling confused, this course is for you.
Professionals: If you want to get better at using Excel at work, this course will help you boost your productivity and impress your boss.
Students: Excel is a must-have skill in many fields. Start mastering it now and give yourself a head star.
Let’s Make Excel Work for You!
No more feeling stuck or frustrated. By the end of this course, you’ll have the confidence to tackle any Excel task that comes your way. So, let’s get started and turn you into an Excel hero!

Who this course is for:

Individuals who are new to Excel and want to build a strong foundation in its essential features.
Students, professionals, and small business owners who need to improve their Excel skills for work or personal projects.
Anyone looking to enhance their productivity and data management capabilities with Excel.

Excel : A Beginner's Guide to Mastering Excel in 1h30 Mins

What you'll learn

Explore related topics

Course content

Module 1: Introduction to Excel4 lectures • 9min

Module 2: Basic Data Entry and Formatting4 lectures • 8min

Module 3: Simple Formulas and Functions4 lectures • 17min

Module 4: Working with Data4 lectures • 15min

Module 5: Basic Charts and Graphs2 lectures • 16min

Module 6: Basic Data Analysis3 lectures • 13min

Module 7: Final Project1 lecture • 4min

Module 8: Excel Shortcuts (Additional Module)1 lecture • 1min

Requirements

Description

Who this course is for: