Mastering Excel 365 - Beginner (2024)

Name: Mastering Excel 365 - Beginner (2024)
Rating: 4.7 (21 reviews)

Learn to use the world’s most popular tool for analyzing and reporting on data.

Created byBigger Brains

Last updated 1/2024

English

English [Auto],

What you'll learn

Navigate the interface including accessing commands and selecting and entering data
Create and save a new workbook
Perform calculations using formulas and functions
Format text cells and apply Conditional Formatting

Course content

6 sections • 19 lectures • 2h 7m total length

Introduction1:50
Master Excel 365 beginner guides you to navigate the interface, enter and manage data, create formulas and charts, format cells, apply conditional formatting, print, and sort and filter data.
Navigating Excel9:58
Master the basics of navigating Excel 365: explore the interface, ribbons, and quick access toolbar, master workbook, sheets, and cells, and use keyboard shortcuts to move, zoom, and view data.
Using Commands6:54
Navigate the Excel ribbon, tabs, and groups to access commands, dialog boxes, and formatting tools; customize quick access, use alt keyboard shortcuts, and explore contextual and mini toolbars.
Selecting Data7:16
Master efficient data selection in Excel 365 by using mouse drag, shift and ctrl shortcuts, including Ctrl A, Shift-click, and Ctrl-Shift arrows to define data sets.
Knowledge Check

Creating a New Workbook5:33
Create a new blank workbook for a budget worksheet, enter data using enter and tab, and save to OneDrive with autosave enabled.
Entering Cell Data9:54
Enter and edit data in Excel 365 by typing in cells. See how the formula bar reveals truth, spillover text, and how to move, copy, undo, redo, and clear data.
Using AutoFill8:53
Learn to use AutoFill in Excel to auto populate months, days, quarters, and patterned numbers by dragging the fill handle; customize with fill series, dates, weekdays, and 14-day intervals.
Getting Help4:08
Use Excel's built-in help and contextual guidance via the search box and help pane to find commands like insert icon and spell check, and access Microsoft support.
Knowledge Check

Creating Formulas8:05
Learn to create formulas in Excel 365 beginner that convert yearly income to monthly figures, compute net amounts, and use cell references with order of operations for automatic updates.
Inserting Functions10:28
Insert and master the sum function and other common functions to create dynamic formulas, verify ranges like C2 through F2, and ensure totals update automatically.
Copying Formulas and Functions7:13
Copy and fill formulas across rows and columns with autofill and relative references. Use quick shortcuts like Alt+= for autosum, and transpose headings when needed.
Knowledge Check

Applying Text Formats4:43
Learn to enhance readability and emphasis in Excel 365 by applying text formats such as bold, italics, underline, font size, color, and font choices to headings, totals, and key cells.
Applying Cell Styles6:27
Apply and customize cell styles in Excel by using the cell styles list, applying heading and total styles, duplicating and modifying styles, and using repeat to speed formatting.
Applying Basic Conditional Formatting6:17
Apply conditional formatting in Excel 365 to highlight high and low values using greater than, less than, and top bottom rules, with above/below average and a legend for dynamic updates.
Printing Workbooks8:40
Master how to preview and print your Excel workbooks using print preview, set print areas, adjust orientation, margins, and printer options to print active sheets, selections, or entire workbooks.
Knowledge Check

Creating Charts5:48
Turn monthly food and beverage sales into charts by selecting the right data and excluding averages or totals, then use shortcuts to create dynamic, updatable charts.
Inserting Graphics3:17
Insert graphics in Excel to highlight data using shapes, arrows, icons, and pictures. Place an oval around a high value, adjust fill, and resize icons beside headings for visual appeal.
Knowledge Check

Requirements

No prerequisites required to take this course.

Description

Learn how to use the world’s most popular software tool for analyzing and reporting on data.

When you master Excel, you have one of the most practical and valuable skill sets in modern business. You will learn to work wonders with your data—from organizing lists to creating charts and interactive reports. Excel will help you answer critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.

This is our most requested training course!

Topics covered include:

Navigating the interface
Creating and saving workbooks
Selecting and entering data
Performing calculations
Formatting data
Adding charts and graphics
Sorting and filtering lists

Over two hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Objectives

You will be able to:

Navigate the interface including accessing commands and selecting and entering data
Create and save a new workbook
Perform calculations using formulas and functions
Format text cells and apply Conditional Formatting
Print workbooks
Add charts and graphics to your workbook
Sort and filter data in a list

Target Audience: Users who are new to Microsoft Excel and want to learn foundational tools of Excel can take this course.

Who this course is for:

Users who are new to Excel and want to learn foundational tools.

Mastering Excel 365 - Beginner (2024)

What you'll learn

Explore related topics

Course content

Getting Started4 lectures • 26min

Data Entry4 lectures • 28min

Formulas and Functions3 lectures • 26min

Formatting and Printing4 lectures • 26min

Charts and Graphics2 lectures • 9min

Working with Lists2 lectures • 12min

Requirements

Description

Who this course is for: