Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering Excel 2019 - Basics
Rating: 4.6 out of 5(176 ratings)
10,968 students

Mastering Excel 2019 - Basics

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

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
  • Navigating the Interface8:34
  • 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
  • Entering Cell Data5:59
  • Using AutoFill7:27
  • Using Flash Fill4:59
  • using Excel Help2:05
  • 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.

Report abuse