Simon Sez IT

Learn the essentials of spreadsheets with this comprehensive course on Microsoft Excel 2019. Knowing the ins and outs of key features and functions of Excel will help you to facilitate your daily work, whether it’s doing simple calculations or tracking almost any kind of information. 

When you have a solid foundation of Excel knowledge and skills, you can feel confident tackling the toughest data organization challenges. Upon completion of this introductory course, you'll know how to create and use basic spreadsheets.

Intro to Excel

This video is part of the Microsoft Excel 2019 Beginners course and provides an overview of the new features in Excel 2019. The target audience is beginners who want to gain a solid grounding in the basics of Excel. The video covers four new features, including the ability to deselect cells, an accessibility checker, a translate function, and the CONCAT function. The CONCAT function allows users to merge cells together and has the ability to merge multiple cells into one cell. The video concludes with a course overview and what to expect in the upcoming videos.

Whats New In Excel 2019

Course Overview

This video is part of the Microsoft Excel 2019 Beginners course and provides an overview of the Excel window, including the Quick Access Toolbar, title bar, tabs, work area, cells, fill handle, name box, formula bar, scroll bar, and views. The video also briefly explains how a computer screen works, including pixels and resolution, and how to adjust the screen view by zooming in or out. Additionally, the video covers the basic functions of a computer mouse, including the left and right buttons and scroll wheel. This video is ideal for beginners who need a solid grounding in the basics of Excel and computer usage.

Overview of the Excel window

This video is part of a Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video focuses on teaching the viewer about the different features of a mouse in Excel. The instructor explains the importance of recognizing the different ways the mouse changes what it looks like and goes on to explain the four different ways the mouse will look in Excel. The video emphasizes that paying attention to these different features will make life easier in Excel. The video then moves on to discuss the backstage view and how it works. Overall, this video provides a solid grounding in the basics of Excel.

Mouse-Features

This video is part of a beginner's course on Microsoft Excel 2019. The target audience is those who are new to Excel and want to learn the basics. The video is a tutorial on how to use the Backstage view in Excel, which is an area where users can access different options such as saving files, creating new ones, and changing Excel options. The tutorial covers how to access the Backstage view, create a new workbook, save options, printing options, and other options available in the Backstage view. The video concludes by encouraging users to start creating new workbooks and moving on to Module 2.

Back Stage View

<a href="https://ssi-exercise-files.s3.amazonaws.com/office-2019/Excel-2019-Beginner/Excel+2019+Beginner+Course+Exercise+Files.zip">Click here to download the exercise files to accompany this course</a>

Course Exercise Files

The transcription consists of the entire course transcribed word-for-word, organized by chapter, and with a Table of Contents. This downloadable &amp; printable transcript provides another learning option - if you prefer reading but don’t have time to take notes.

DOWNLOAD ME: Course Transcript

Chapter 1: Intro to Excel

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a step-by-step guide on how to create a new workbook in Excel from scratch. She explains how to add column headings, enter text and numbers in cells, and use the fill handle to fill in a series of months. The video also covers formatting numbers, editing text, and introduces the concept of formulas. Overall, this video provides a solid foundation for beginners to become more confident with spreadsheets.

Entering Text and Numbers

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video provides a tutorial on how to create basic formulas in Excel. The presenter explains that formulas are mathematical calculations used to add up numbers or perform any kind of math with the data. The video covers how to write formulas in Excel, how to use cell addresses instead of typing in numbers, how to fix errors, and how to calculate profits. The video is presented in a clear and easy-to-understand manner, making it accessible to beginners.

Creating Basic Formulas

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains the concept of relative references in Excel formulas and demonstrates how to use the fill handle to copy a formula across columns and rows. He also explains the need for absolute references in certain situations. The video concludes with a brief introduction to the order of operations in Excel. This tutorial is perfect for beginners who want to gain a solid understanding of the basics of Excel.

Relative References

This video is part of a beginner's course on Microsoft Excel 2019. It explains the order of operations in math and how it applies to Excel formulas. The target audience is those who are new to Excel and want to become more confident with spreadsheets. The video provides an example of how not following the order of operations can lead to incorrect results and explains how to use parentheses to ensure that Excel performs the desired operations first. The video concludes by mentioning nested functions and how they work. It is intended to help learners understand how to use Excel formulas correctly.

Order of Operations

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to work with ranges in Excel, which are groups of adjacent cells that can be used for formatting or formulas. The video covers selecting ranges, avoiding deselection, and using the sum function to add up numbers in a range. The video ends by introducing the next module on saving work in Excel.

Working with Ranges

Module 2 - Practice Exercise

Chapter 2: Creating Workbooks

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the basics of saving workbooks in Excel, including the importance of saving to avoid losing information and formulas. The instructor explains the two options for saving a file, Save and Save As, and demonstrates how to save files to OneDrive, Microsoft's cloud storage service. The video also provides tips on how to update work and how to save files to a specific location on the computer. The next section will cover file extensions and other options for saving files.

Working with the Save and Save As Commands

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a comprehensive guide on how to save workbooks in different formats such as CSV and PDF. He also explains how to share files with others through email or SharePoint server. The video also covers exporting files and publishing them using Power BI, a tool that allows users to create reports and dashboards without relying on the IT department. The next module will cover working with larger workbooks and searching for specific data.

File Extensions, Share, Export and Publish Files

Module 3 - Practice Exercise

Chapter 3: Saving Workbooks

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a solid grounding in the basics of Excel and guides the user towards becoming more confident with spreadsheets. The video is divided into two sections. In the first section, the instructor explains how to open files in Excel and how to pin frequently used files to the list for easy reference. In the second section, the instructor explains how to work with larger files, navigate between different sheets in the workbook, link cells between different sheets using a formula, and work with larger files by zooming in on the worksheet and using the Freeze Panes option. Overall, the video provides a comprehensive overview of how to navigate through different workbooks in Excel and work with larger files.

Opening a File

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to navigate through larger files in Excel using the scroll bar, Home and End keys, and the name box. The video also covers how to use the Find and Select option to search for specific words or numbers in the workbook and how to use the Find and Replace feature to replace specific text or numbers. The Freeze Panes option is also briefly mentioned to keep headings visible while scrolling through the data.

Working with Larger Files

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video provides a tutorial on how to use the Freeze Panes and Split Screen options in Microsoft Excel. The Freeze Panes option allows users to freeze columns or rows so that they remain visible while scrolling through the rest of the worksheet. The Split Screen option allows users to split the worksheet into two or four panes, each with its own scroll bars. The video provides a step-by-step demonstration of how to use both options, making it a helpful guide for Excel users who want to improve their productivity and efficiency when working with large worksheets.

Freeze Panes Option

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video explains how to use the Split Screen option in Excel, which allows users to view two different parts of a workbook simultaneously without having to scroll back and forth. The instructor demonstrates how to use the Split Screen option and how to turn it off. The video also shows how to split the screen horizontally, allowing users to view four different sections of the workbook. The video concludes by introducing Module 5, which covers page setup and print options.

Split Screen Option

Module 4 - Practice Exercise

Chapter 4: Navigating Workbooks

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at individuals who are new to Excel. The video provides a comprehensive introduction to the basics of Excel, including how to navigate the interface, create and format spreadsheets, and perform basic calculations. The expert author guides learners through each step, providing a solid foundation for becoming more confident with spreadsheets.

Headers and Footers

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to set up print titles in Excel, which is useful when printing spreadsheets with multiple pages. The instructor demonstrates how to select the rows that contain the column headings and set them up to be printed on every page. The video concludes by introducing the next section, which will cover working with comments. This video is perfect for beginners who want to learn how to set up print titles in Excel.

Print Titles

This video is part of a beginner's course on Microsoft Excel 2019. The target audience is those who are new to Excel and want to learn the basics. The video focuses on the comment feature in Excel, which allows users to add comments to any cell in a spreadsheet. The video explains how to add, edit, and delete comments, as well as how to resize and move them. It also covers how to print comments and view the cell numbers they refer to. The video concludes by mentioning that users can move on to Section 4 to learn about different page setup options.

Comments

This video is part of the Microsoft Excel 2019 Beginners course and is a tutorial on Excel's page setup and print options. The instructor covers various options such as headers, footers, margins, orientation, print area, breaks, and background images. The video also demonstrates how to adjust the printout's size, print grid lines, borders, row and column headings, and choose the page order. The target audience is beginners who want to customize their spreadsheets for printing. Overall, the video provides a comprehensive overview of Excel's page setup and print options, making it easier for users to create professional-looking spreadsheets.

Page Setup Options

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor demonstrates how to make everything print on one page in Excel. She explores two options to get everything to fit on one page, including adjusting the scaling and changing the orientation. She also shows how to use the page break preview to adjust the scaling automatically. The video is informative and helpful for those who want to learn how to print their Excel spreadsheets efficiently.

Fit to Print on One Page

This video is part of a beginner's course on Microsoft Excel 2019. The target audience is those who are new to Excel and want to learn the basics. The video focuses on printing workbooks in Excel and explains how to access print options, including Print Preview and Page Setup. The instructor demonstrates how to choose what to print, such as specific sheets or sections, and how to customize printing options like scaling, margins, and paper size. The video concludes by introducing the next module on adding rows, columns, and cells to existing workbooks.

Printing Workbooks

Module 5 - Practice Exercise

Chapter 5: Page Setup & Print Options

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a step-by-step tutorial on how to work with rows, columns, and cells in Microsoft Excel. The video covers how to add and delete rows and columns, insert cells, and change the width of rows or columns. The instructor emphasizes the importance of selecting cells rather than entire rows or columns when inserting cells to avoid affecting other parts of the table. Overall, this video provides a solid grounding in the basics of Excel and is perfect for beginners.

Adding and deleting rows columns and cells

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to change column and row widths in Excel to avoid pound symbols and cut-off text. The video demonstrates how to adjust column and row widths by dragging the column header or double-clicking the line between columns. The instructor also explains how numbers and text behave differently in Excel and shows how to undo pound symbols by making the column wider. The video concludes by introducing the next module on moving data around using cut, copy, and paste, and copying formulas.

Changing Column and Row Widths

Module 6 - Practice Exercise

Chapter 6: Working with Rows, Columns and Cells

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video tutorial explains the basic function of cut, copy, and paste in Microsoft Excel. The instructor demonstrates how to move data from one location to another by selecting the data and dragging it to the desired location. The video also explains the difference between cut and copy and how to turn on the clipboard. The video concludes by introducing the next section, which will cover copying formulas in Excel.

Cut Copy and Paste

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at individuals who are new to Excel. The video provides a comprehensive introduction to the basics of Excel, including how to navigate the interface, create and format spreadsheets, and perform basic calculations. The expert author guides learners through the process of becoming more confident with spreadsheets, making it an ideal resource for anyone looking to improve their Excel skills.

Copying Formulas

Module 7 - Practice Exercise

Chapter 7: Moving Data

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the basics of formulas and functions in Excel. It explains that a formula is a mathematical calculation that tells Excel what to do, and that Excel is powerful when it comes to formulas. The video provides examples of basic formulas and how to use functions to make life easier. It emphasizes the importance of using functions to write formulas, especially when dealing with a large amount of data.

Overview of Formulas

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video provides a tutorial on how to use formulas and functions in Excel. The instructor explains the difference between a formula and a function and demonstrates how to use the "Auto Sum" button to quickly add up a range of numbers. The video covers over 200 built-in functions in Excel and how to use the "Insert Function" button to search for a specific function. The video emphasizes the importance of selecting the correct range of cells when using functions and formulas. The video ends with a prompt to continue to the second part of the tutorial.

Create Formulas Using Functions part1

This video is part of a beginner's course on Microsoft Excel 2019. It focuses on formulas and functions, providing a solid grounding in the basics of Excel. The target audience is those who are new to Excel and want to become more confident with spreadsheets. The instructor explains how to create formulas using functions and goes through a list of popular functions in Excel, including the COUNT, MAX, MIN, and SUM functions. The video also covers the function library, copying and pasting formulas, and using function arguments to specify the range of cells. Overall, the video provides a comprehensive overview of Excel functions and how to use them in formulas.

Create Formulas Using Functions part-2

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains the concept of absolute values in Excel and when to use them. They use an example of a company with different divisions to demonstrate how relative reference can give incorrect results when formulas are copied down. The instructor shows how to use absolute values by inserting dollar signs in front of the column and row reference of the commission rate. The video concludes by introducing Module 9, which covers working with sheets in Excel.

Absolute Values

Module 8 - Practice Exercise

Chapter 8: Formulas & Functions

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a tutorial on how to work with sheet tabs in Microsoft Excel. The video covers how to add, delete, and rename sheets, navigate between sheets, and move them around. The instructor also cautions against moving sheets on the other side of the summary sheet, as it can affect 3-dimensional formulas. The video concludes by mentioning additional sheet tab options that will be covered in the next section.

Adding Deleting and Renaming Sheets

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor covers the basics of working with sheet tabs in Excel, including inserting, deleting, and renaming sheets. She also demonstrates how to move or copy a sheet tab to a new location within the workbook or to a new workbook entirely. The video also covers how to protect a sheet with a password, change the tab color, and hide a sheet. The instructor concludes by explaining how to select all sheets in a workbook and make changes that will apply to all sheets simultaneously.

Additional Sheet Tab Options

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The tutorial covers how to use three-dimensional formulas in Excel, which are formulas that calculate data from other sheets and put the answer on the sheet that you're on. The video explains how to set up a three-dimensional formula by selecting a range of sheets and using the SUM function. It also demonstrates how to write a three-dimensional formula by adding cell B4 from all four sheets and putting the answer on the summary sheet. The video emphasizes the importance of setting up the sheets exactly the same way to use a range of sheets and encourages viewers to practice using three-dimensional formulas.

3 Dimensional Formulas

Module 9 - Practice Exercise

Chapter 9: Working with Sheets

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers formatting worksheets in Microsoft Excel, including formatting cells and formatting numbers. The instructor demonstrates how to change the font, size, color, and style of cells, as well as how to align text within cells and add borders and shading. The video also covers how to format numbers as currency, percentages, and dates. By the end of the video, viewers will have a solid understanding of the formatting options available in Excel.

Formatting Cells part 1

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. In this video, the instructor continues to discuss formatting cells in Excel, specifically focusing on the Alignment grouping. The video covers options such as wrap text, merge and center, shrink to fit, and text direction and orientation. The instructor demonstrates how to use each option and notes that there is more formatting to do, encouraging the user to move on to section 2. Overall, the video provides a brief overview of some of the formatting options available in Excel and demonstrates how to use them.

Formatting Cells part 2

Formatting Numbers

This video is part of a beginner's course on Microsoft Excel 2019. The target audience is those who are new to Excel and want to learn the basics. The video focuses on formatting worksheets in Excel using borders and shading. The instructor explains how to add borders to cells, customize them with different styles and colors, and use shading to add color to cells with different patterns and effects. The video also covers how to draw custom borders using the draw border tool and format tables in Excel. The video provides step-by-step instructions and visual demonstrations to help users understand how to format their worksheets effectively.

Borders and Shading

This video is part of a beginner's course on Microsoft Excel 2019. It is perfect for those who are new to Excel and want to learn the basics. The video covers different ways to format a worksheet in Excel, including formatting cells, numbers, borders, and shading options. The instructor also demonstrates how to convert a range of cells into a table and customize it using pre-built options. The video explains how to use drop-downs to filter data and how to use the Table Tools contextual tab. It also covers different table styles and how to create custom styles. Overall, the video provides a comprehensive overview of formatting options in Excel and how to use them effectively.

Format as Table

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers formatting worksheets in Excel using styles. The instructor explains that styles are a quick way to format ranges and make them look nice. The video demonstrates how to use styles, how to edit formatting, and how to create new styles. The Format Painter option is also introduced, which allows users to copy formatting from one range to another. The video concludes by introducing the next section on how to use the Format Painter option.

Using Styles

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to use the Format Painter option in Excel to copy formatting from one cell to another, which can save time when formatting multiple cells. The video demonstrates how to use the Format Painter by selecting a cell with the desired formatting and clicking on the Format Painter icon. The instructor also shows how to use the Format Painter to apply formatting to a range of cells, but warns that the number of rows and columns in the selected range must match the target range. The video ends by mentioning that the next section will cover how to protect sheets in Excel.

Using Format Painter

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers how to protect cells, sheets, and workbooks in Microsoft Excel. The instructor explains the importance of protecting cells to prevent accidental or intentional deletion or editing of formulas. The video provides step-by-step instructions on how to unlock cells that need to be edited and then protect the sheet. The instructor also shows how to protect the entire workbook to prevent deletion of columns or rows, adding or deleting sheets, or moving things around. The video concludes by mentioning the upcoming discussion of the fill handle and custom lists in Excel.

Protecting Sheets

This video is part of a Microsoft Excel tutorial aimed at beginners. The instructor focuses on formatting worksheets and explains how to use the fill handle to copy cells and lists, including pre-designed lists such as days of the week and months of the year. The video also covers how to access and edit custom lists, which can be useful for repetitive data entry. The target audience is anyone who is new to Excel and wants to gain a solid grounding in the basics of the software.

Fill Handle and Custom Lists

Module 10 - Practice Exercise

Chapter 10: Formatting Worksheets

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to work with charts in Excel, using a company's quarterly sales report as an example. They demonstrate how to create basic column charts, charts with multiple selections, and embedded charts. The video also covers the terminology used in charts, such as axes, categories, values, and legends. The presenter shows how to change data in a chart and discusses different types of charts that can be created in Excel, including column charts, pie charts, line charts, and scatter charts. Overall, the video provides a solid grounding in the basics of working with charts in Excel.

Creating Charts

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video focuses on charts in Excel and introduces the different types of charts available. The instructor demonstrates how to create a column chart and an embedded pie chart, and how to access the different types of charts available in Excel. The video covers a range of chart types, including scatter charts, combo charts, and radar charts. The instructor also mentions the Templates folder, where users can edit and save charts as templates for future use. The next section will cover how to edit charts to make them look nicer.

Types of Charts

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video provides a comprehensive guide to editing charts in Excel. The instructor explains that there are several ways to edit charts and demonstrates how to add or remove chart elements, change chart styles, and apply filters. The video also explains how to add data labels, data tables, error bars, grid lines, and trend lines. The presenter shows how to use the add chart element option to add or remove chart elements and choose different chart styles and color schemes. Overall, the video is a tutorial on how to edit charts in Microsoft Excel.

Editing Charts Part 1

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video is a tutorial on how to work with charts in Microsoft Excel, specifically focusing on the different options available for editing charts. The presenter demonstrates how to change the color, add a picture, gradient, or texture to a chart, as well as how to change the line around the shape and add shape effects such as shadows, glows, soft edges, beveled looks, or 3D rotations. The video provides a useful guide for users who want to create visually appealing charts in Excel.

Editing Charts Part 2

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor demonstrates how to use drawing tools in Microsoft Office products to enhance charts. Viewers will learn how to use shapes to draw attention to specific areas in a chart, make them transparent, and draw arrows from one data point to another. The video also covers adding pictures and online pictures to charts. The next section will discuss how to link chart titles back to the data.

Using Graphics to Enhance Charts

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor teaches how to link chart titles to data in Excel, allowing the chart title to update automatically when the data is changed. The instructor demonstrates the process by linking the chart title to a specific cell and emphasizes the importance of selecting the chart title correctly. The video is informative and easy to follow, making it a great resource for beginners who want to learn how to use Excel effectively.

Linking Chart Titles

Module 11 - Practice Exercise

Chapter 11: Charts

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the names feature in Excel, which allows users to give a cell or group of cells a name for quick access to specific sections in a workbook and for use in formulas. The video provides step-by-step instructions on how to create range names, including selecting the range, typing the name in the name box, and hitting the enter key. It also explains how to manage range names, including how to delete or change what a range name refers to.

Creating Range Names

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to manage range names in Excel using the Name Manager feature. Viewers will learn how to edit, delete, and create range names, as well as how to access the Name Manager on the Formulas tab. The instructor also demonstrates how to create a new range name for a single cell and how to edit the name if it was misspelled. The video concludes by highlighting the benefits of using range names in formulas and teases the next section, which will cover how to use range names in formulas.

Managing Names

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the names feature in Excel, which allows users to use a range that they have already named in place of using actual ranges when writing a formula. The video demonstrates how to use arranged names and set them up in formulas, and shows how to use a name to pay each salesperson a 15% commission without showing it on the screen. The video concludes by introducing Module 13, which will cover sorting and filtering when working with longer lists of information.

Using Names in Formulas

Module 12 - Practice Exercise

Chapter 12: Working with Names

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to sort and filter data in Excel, starting with removing duplicates from a list of data. The video covers sorting data alphabetically, numerically, and by date, as well as sorting by multiple columns. The instructor also explains how to use the filter function to show or hide specific data based on certain criteria. Overall, the video provides a solid grounding in the basics of sorting and filtering data in Excel.

Remove Duplicates

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers sorting and filtering data in Excel, with the instructor explaining the importance of setting up data correctly before sorting and demonstrating how to do a single, double, or triple sort using different options. The video also covers sorting by date and how to format dates correctly. In addition, the instructor explains how to filter data in Excel, allowing users to view only the data that meets specific criteria. The video provides step-by-step instructions, making it easy for viewers to follow along.

Sort Data

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a comprehensive guide on how to filter data in Excel, including filtering by department, division, and number of hours worked. She also demonstrates how to use text filters to find specific letters and how to use the number filter to find data within a specific range. The video concludes with an introduction to advanced filters and how they can be used to filter data based on multiple criteria. This video is perfect for anyone who wants to become more confident with spreadsheets.

Filter Data

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to use advanced filters in Excel to find specific data that cannot be filtered using drop-down menus. The video demonstrates how to create a criteria table with column headings and criteria to match, and how to select the list range and criteria range. The instructor also explains how to add multiple sets of criteria and another column if needed. The video concludes by introducing the next module on outlining and subtotaling in Excel.

Advanced Filters

Module 13 - Practice Exercise

Chapter 13: Sorting and Filtering

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers creating an outline and subtotalling in Excel. The instructor explains how to create an outline with different levels of organization and how to show or hide certain levels. The video also covers subtotalling, which is used to group data and calculate subtotals for each group. The instructor demonstrates how to use the Subtotal feature and how to collapse and expand the groups using the outline. The video provides a solid grounding in the basics of Excel and is perfect for those who want to become more confident with spreadsheets.

Creating an Outline

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the outlining and subtotaling features in Excel. The instructor demonstrates how to use the subtotal feature to divide a list of information by a particular repeated value in a column and add subtotals for each of those values. The video also explains how to use different functions such as SUM and COUNT and how to show both the sum and count. The video is a step-by-step guide on how to use the subtotal feature in Excel to save time and effort when working with large amounts of data.

Subtotals

Module 14 - Practice Exercise

Chapter 14: Outlining and Subtotaling

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor provides a comprehensive guide on how to arrange multiple files and views in Excel. The video is divided into two sections, with the first section covering how to arrange multiple files using the View tab. The second section discusses the new window option in Excel, which allows users to open a new window of the same file. The instructor demonstrates how to use this option and how to arrange the windows side by side. Overall, this video provides useful tips for working with multiple files and views in Excel.

Arranging Files

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor demonstrates how to use the new window feature in Excel to view multiple sheets of the same file at the same time. They explain that this is a great way to visually compare sheets in a file with multiple sheets. The instructor also notes that it doesn't matter which window is saved or closed, as they are both copies of the same file. This video provides a solid grounding in the basics of Excel and guides the viewer towards becoming more confident with spreadsheets.

New Window Option

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video focuses on working with different views in Excel, specifically the Custom Views option. It demonstrates how to create custom views using an example of a list of fruits and vegetables being sold, with figures for January through March and yearly totals. The video emphasizes the importance of creating an original view before creating custom views and how to delete or clear views. The video concludes by stating that all custom views are saved with the file and that the next module will cover linking files.

Custom Views

Module 15 - Practice Exercise

Chapter 15: Working with Views

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to link files in Excel and demonstrates how to create formulas between files. The video focuses on four files, Jane, Hanover, Monitor, and Summary, and explains how the sales, commission, item codes, price, and quantity are tracked in each file. The instructor shows how to add up the total sales and commissions from each salesperson in the Summary file. The video ends with a teaser for Section 2, where the instructor will cover different links and advanced techniques.

Creating Formulas Between Files

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains the linking files feature in Excel and how to write formulas between files and link them together. The video covers how to work with links, including finding them under the Data and Queries and Connections menu, updating values, changing the source, breaking the link, and opening the source. The instructor also explains the startup prompt and how to choose to display the alert or not. The video concludes by mentioning that links are used in many different places in Excel, and the next section will cover how to consolidate data.

Working with Links

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the topic of consolidating data in Excel, which is a feature that allows users to combine numbers from multiple files into a single file. The video explains the steps involved in consolidating data, including ensuring that all files are open and set up in the same way, selecting the function to use, and adding the references to the consolidation window. The video also explains how users can create links to source data to see the breakdown of the consolidated data. Overall, this video provides a solid grounding in the basics of consolidating data in Excel.

Consolidating Data

Module 16 - Practice Exercise

Chapter 16: Linking Files

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers advanced formula creation options in Excel, such as IF statements, VLOOKUPs, and data validation. The instructor explains how to create an IF statement using an example of a company's sales data and how to use VLOOKUP to compare sales data with a bonus table and calculate bonuses for salespeople who meet certain criteria. The video provides clear explanations and helpful tips to make the formulas easier to use and understand.

If Statements

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to use the VLOOKUP function in Excel, which allows users to compare a particular cell to a table and look up a value vertically or horizontally. The instructor demonstrates how to use VLOOKUP to calculate bonuses for salespeople based on their total sales, and advises on naming the table before writing the formula. The video also covers the four arguments required for the VLOOKUP formula and the optional range lookup. The instructor briefly introduces the concept of data validation and mentions the HLOOKUP function.

VLookups

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to use Excel's Data Validation feature to create drop-down lists and set restrictions on data entry. The video provides an example of a product list where users can enter the color of the product, but the entries are inconsistent and make it difficult to sort and filter the list. The instructor demonstrates how to set up input and error messages to guide users on what to enter and alert them when they enter incorrect data. The video concludes by introducing the next topic, formula auditing.

Data Validation

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers formula auditing in Excel, including how to use the auditing feature to find formulas and cells that are referenced in those formulas. The instructor explains common error messages that appear in Excel and demonstrates how to fix them. The video also covers the Formula Auditing section of the Formulas tab, including the Show Formulas button and Trace Precedents and Trace Dependents options. The video concludes with an overview of the formula auditing tools covered and encourages viewers to use them to create more advanced formulas.

Formula Auditing

Module 17 - Practice Exercise

Chapter 17: Advanced Formula Creation

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to create a pivot table in Excel, which is an interactive worksheet that allows users to get answers to questions that cannot be answered by formulas. The video uses an example of raw data to demonstrate how to create a pivot table by dragging and dropping column headings from the raw data to the pivot table. The instructor also shows how to filter the pivot table, change field settings, and format numbers. The video ends by mentioning that Pivotcharts will be covered in Section 2.

PivotTables

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video explains how to create a PivotChart in Excel, which is a chart format of the information in a PivotTable. The video provides step-by-step instructions on how to create a PivotChart, including how to choose the type of chart desired and how to filter the data by product, salesperson, and store. The video concludes by introducing Module 19, which covers additional Excel features. Overall, this video is a useful tool for anyone who wants to learn how to create PivotCharts in Excel.

Pivot Charts

Module 18 - Practice Exercise

Chapter 18: PivotTables

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains the use of slicers and goal seeker in Excel. Slicers are a visual way to filter data from pivot tables, and the instructor demonstrates how to create and use slicers to filter data. The goal seeker is a tool that helps users find the input value needed to achieve a goal or desired result. The instructor explains how to use the goal seeker to adjust the input value until the desired result is achieved. These features can be useful for creating dashboards and analyzing data in Excel.

Slicers

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the Goal Seek and Text to Columns features of Excel. The Goal Seek feature is useful for determining the value of a variable based on a known value, while the Text to Columns feature is useful for splitting data in a cell into separate columns. The video demonstrates how to use these features and they are part of the What If Analysis and Data tabs in Excel. This video is perfect for beginners who want to become more confident with spreadsheets.

Goal Seeker

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video covers the Text to Columns option in Excel, which allows users to separate information in one column into multiple columns. The video explains how to use this feature and mentions the concatenate function, which allows users to condense data or put it back together. The video also briefly touches on the watch window, which is a feature that allows users to monitor specific cells or formulas while working on other parts of the worksheet. Overall, this video provides a solid grounding in the basics of Excel for beginners.

Text to Columns

This video is part of a beginner's course on Microsoft Excel 2019. The target audience is those who are new to Excel and want to learn the basics. The instructor explains how to use the watch window in Excel, which is a tool that allows users to monitor specific cells in a worksheet while working on a different sheet. The video covers how to add a watch, customize the window, and move it around. The instructor also briefly discusses customizing ribbons and tabs in Excel. This video is perfect for those who want to become more confident with spreadsheets.

Watch Window

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The instructor explains how to customize ribbons and tabs in Excel by adding buttons or tools that are not on the ribbon and how to add specific tools or buttons to tabs. The video demonstrates how to customize the ribbons and tabs in Excel by going to the File tab and selecting the Customize Ribbon option. The instructor also shows how to add a button called Hide Columns to the Home tab by creating a new group and adding the button to it. The video ends by mentioning that the next module will cover some Excel shortcuts.

Customizing Ribbons and Tabs

Module 19 - Practice Exercise

Chapter 19: Additional Excel Features

This video is part of the Microsoft Excel 2019 Beginners course and is aimed at those who are new to Excel. The video provides ten Excel shortcuts that can help users save time and work more efficiently. The tips include creating multiple sheets at the same time, turning a range of cells into a table, selecting and formatting an entire sheet, clearing formats all at once, navigating multiple sheets, a quick way to print, using the Quick Analysis tool, sending an email from Excel, a quick way to save a file, and creating hyperlinks. These tips can help users become more confident with spreadsheets and work more efficiently.

Excel Shortcuts Every User Should Know

Chapter 20: Shortcuts

Closing Video

Chapter 21: Closing

Course Quiz

This video forms part of the course Introduction to Google Docs. The course is perfect for those brand new to Google Docs, with an expert instructor who gives you a solid grounding in the basics of Google Docs and guides you toward becoming more confident with documents.

Course Wrap Up

Chapter 22: Quiz

Mastering Excel Features

Using Excel Shortcuts

This video course with practice exercises is for students with basic computer skills who would like to learn the basics of Microsoft Excel 2019, including creating and formatting workbooks and basic functions and formulas.

Microsoft Excel 2019 Beginners

What you'll learn

Explore more technology skills