Mastering Excel 2019 - Basics

Name: Mastering Excel 2019 - Basics
Rating: 4.6 (176 reviews)

There are two kinds of people: Those who are masters at Excel, and those who wish they were

Created byBigger Brains

Last updated 2/2021

English

EnglishSpanish

What you'll learn

Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
Perform calculations using formulas and functions
Insert and delete rows and columns
Apply formatting to text, numbers, and cells including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
Customize your instance of Excel including adding Groups to the Ribbon and modifying the Quick Access Toolbar.

Course content

7 sections • 41 lectures • 4h 26m total length

Introduction2:09
Navigate the Excel interface and create and save workbooks. Enter data, use flash fill and auto fill, and build basic formulas with sum and average for beginners.
Navigating the Interface8:34
Explore the Excel 2019 basics interface and learn the Quick Access Toolbar, Ribbon, Name Box, Formula Bar, and zoom and scroll features.
Selecting Data9:15
Master efficient data selection in Excel using mouse and keyboard: create cell ranges like A1 to C2, use Shift and Ctrl shortcuts, select columns or rows, and deselect non-adjacent cells.
Using Commands7:14
Navigate Excel commands via the ribbon, tabs, and groups, and customize quick access toolbar. Use Alt key tips, search box, and right-click context menus for tasks like data validation.
Creating a New Workbook8:04
Create and save a new workbook in Excel 2019 using the File tab and blank workbook; enter data via the formula bar and explore save options, templates, and compatibility conversions.
Entering Cell Data5:59
Identify the three data types—numbers, text, and dates—and observe the formula bar, then copy with Ctrl+C, paste with Ctrl+V, and undo with Ctrl+Z.
Using AutoFill7:27
Explains how to use auto fill and fill series in Excel to generate months, days, numbers, and dates by dragging the fill handle, including weekdays.
Using Flash Fill4:59
Master flash fill basics: detect patterns to split or combine cells, trigger with control e to auto fill, and format data, such as converting names to all caps.
using Excel Help2:05
Explore how to access Excel help from the File tab or F1 shortcut, use the search tool, and find auto fill guidance to answer questions on your own.
Knowledge Check

Creating Formulas7:57
Learn to create accurate Excel formulas with the equal sign and cell references, perform add, subtract, multiply, and divide, and apply order of operations for simple projections.
Inserting Functions8:14
Learn to insert functions in Excel 2019 basics, using AutoSum and common functions like sum, average, max, and min, and master keyboard shortcuts such as Alt + =.
Copying Formulas and Functions7:09
Master practical Excel 2019 techniques for copying formulas and functions across rows and columns, using AutoFill, drag and drop, and transpose paste to reorient headings with relative references.
Using Absolute Reference9:51
Master how absolute references lock critical values while copying formulas in Excel, using F4, manage relative and mixed references, reference across sheets, and diagnose common errors.
Knowledge Check

Inserting and Deleting Cells8:50
Insert or delete cells, rows, and columns with right-click or the home tab, and adjust width with autofit while hiding and unhiding columns as needed.
Searching and Replacing7:54
Master find and replace in Excel to locate and update data with match entire cell contents and match case, search workbook, and use go to special for formulas and notes.
Using Proofing and Research Tools6:57
Explore Excel's built-in proofing and research tools, including spell check, AutoCorrect, and dictionary management, plus thesaurus and Smart Lookup for in-sheet editing and quick web research.
Knowledge Check

Applying Text Format8:35
Learn to format text in Excel with font options, colors, and sizes; use format painter and borders to create professional, readable headings and well-styled data.
Applying Number Formats7:24
Apply currency formatting to show dollar signs, commas, and decimals, compare currency and accounting formats, and understand how formatting affects the numbers used in totals.
Customizing Number Formats7:46
Learn built-in and custom number formats in Excel, including date, zip code, phone, and social security formats, and apply, customize, and clear formats efficiently.
Aligning Cell Contents7:17
Center headings and align cells to improve readability, using horizontal and vertical alignment options. Apply orientation, indent, wrap text, and merge center to center across selections and refine headings.
Applying Cell Styles5:20
Apply preset cell styles in Excel to keep headings and data consistent. Create and save custom styles to reuse across workbooks and merge styles from other files.
Applying Themes3:48
Explore how themes control colors, fonts, and effects in Excel 2019, using the page layout tab on the ribbon to apply, customize, and save a consistent company-wide style across workbooks.
Inserting Hyperlinks6:30
Learn to insert hyperlinks in Excel 2019, linking to web pages or local files, set display text, test links, and edit or remove them for shared drives or SharePoint access.
Applying Conditional Formatting6:45
Apply conditional formatting to highlight cells that meet criteria, using greater than, less than, top/bottom rules, and above or below average. See how the formatting updates dynamically as data changes.
Applying Conditional Formatting to Text and Dates7:56
Learn to apply conditional formatting to text and dates in Excel, highlighting the word manager, identifying duplicates, and flagging hire dates and ten-year anniversaries for the current month.
Applying Comparative Analysis Formatting7:22
Master analysis formatting in Excel 2019 by using data bars, color scales, and icon sets to compare numbers across a dataset and adjust thresholds with manage rules.
Using Templates6:01
Learn to use built-in and custom Excel templates to streamline workbooks, save as a template, and create new files from that template to reuse formats and headings.
Knowledge Check

Printing Workbooks4:12
Learn how to print Excel 2019 workbooks using print preview, selecting active sheets, the workbook, or a selection, and adjust orientation, margins, and page size for clean layouts.
Setting the Page Layout6:34
Learn to configure page layout with the Ribbon and Page Setup dialog, adjust margins and orientation, set print areas, and repeat titles, rows, and columns across pages.
Inserting page Breaks8:38
Learn to insert and remove page breaks, use page break preview, and adjust the print area and scaling to control what prints in Excel 2019 basics.
Configuring Headers and Footers, Part 15:09
Configure headers and footers in Excel 2019 using page layout view for printing. Insert left, middle, or right codes for date, page number, file name, and sheet name.
Configuring Headers and Footers, Part 24:04
Configure headers and footers in Excel 2019 via the page setup dialog and the header and footer tab, using built-in or custom header and footer options, including different first page.
Knowledge Check

Managing Worksheets, Part 15:02
Learn to manage worksheets in Excel 2019 basics: add, insert, delete, and rename sheets; use Shift+F11 for quick insertion and organize up to 256 sheets.
Managing Worksheets, Part 27:39
Rearrange and manage worksheets with drag and drop or copy, including moving between workbooks, color-coding tabs, and hiding or unhiding sheets for data control.
Creating a Custom View3:47
Discover how to save and switch between Excel custom views to hide and show data, adjust print settings, and apply filters across sheets with ease.
Managing Worksheet Views6:01
Learn to keep headings visible with freeze panes—top row, first column, or both—and use split panes for independent scrolling to compare sections.
Managing Workbook Views6:22
Learn to view and compare multiple workbooks in Excel by tiling, side-by-side, or in new windows, with synchronized or independent scrolling and copy and paste data.
Managing Workbook Properties4:14
Manage workbook properties to track file details such as creation and modification dates, and add custom properties like title, tags, and category in the backstage file, info view.
Knowledge Check

Customizing General Options3:58
Customize Excel 2019 general options to fit your workflow by adjusting the mini toolbar and quick analysis, and setting defaults for new workbooks, including font, views, and starting sheets.
Customizing the Ribbon7:02
Customize the Excel ribbon by adding commands to existing tabs or creating new tabs and groups. Learn to rename and populate them with tools like freeze panes and print preview.
Customizing the Quick Access Toolbar6:50
Master the quick access toolbar in Excel 2019 by adding, removing, and rearranging commands for faster access, including using right-click and customize options, and adding superscript and subscript.
Knowledge Check

Requirements

A copy of Microsoft Excel 2019 is recommended.

Description

You will be able to:

Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
Perform calculations using formulas and functions
Insert and delete rows and columns
Apply formatting to text, numbers, and cells including using Cell Styles and Conditional Formatting
Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
Manage multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
Use View features to compare workbooks, compare worksheets, or save Custom Views
Customize Excel by adding Groups to the Ribbon and modifying the Quick Access Toolbar

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

When you master Excel, you have one of the most practical and valuable skillsets in modern business. You can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering 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
Managing multiple worksheets
Customizing your options

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

Who this course is for:

People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets.

Mastering Excel 2019 - Basics

What you'll learn

Explore related topics

Course content

Getting Started9 lectures • 56min

Performing Calculations4 lectures • 33min

Modifying Worksheets3 lectures • 24min

Formatting Worksheets11 lectures • 1hr 15min

Printing Workbooks5 lectures • 29min

Managing Workbooks6 lectures • 33min

Customizing options3 lectures • 18min

Requirements

Description

Who this course is for: