Course Description: Excel 2019 is the spreadsheet application in the Microsoft Office 2019 suite. In this 5-video course, "Excel 2019: Getting Started," learners are able to explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Begin the course by learning how to find the application on the desktop and open it. To get the most out of Excel, you need to understand how the interface is laid out, so the course next explores the application. This leads into the zoom function, which can be...
Course Title 23: Creating & Editing Macros
Course Description: In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document. In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.
Course Title 22: Getting to Know Macros in Excel
Course Description: If you have tasks in Excel 2019 that you do repeatedly, you can record a macro to automate those tasks. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works. Key concepts covered in this 10-video course include how to record macros and perform actions that can be implemented in Excel workbooks, how to save a workbook with macros and an Excel macro-enabled workbook, how to find and use macro tools that...
Course Title 21: Managing Data
Course Description: Excel offers a set of tools that allows you to explore more in detail data analysis and complex formulae. In this 8-video course, you will learn how to use different formulae to make calculations when you have multiple conditions imposed. You will also become able to forecast data by using the NPER function. Key concepts covered in this course include how to import, edit, and update data from a text file; how to import, edit and update data from a .csv file; and how to use the LOOKUP, MATCH, and INDEX functions to extract data...
Course Title 20: Configuring Options & Settings
Course Description: Get more out of Excel by customizing it to your own needs. In this 10-video course, you will learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Key concepts covered in this course include how to configure your account and services, including connecting multiple services to your account; how to install an add-in, access to manage it, and install add-ins from the Office Ribbon; and how to create...
Course Title 19: Finding & Analyzing Information with Formulas
Course Description: A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest...
Course Title 18: Using Conditional Formulas
Course Description: Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own in this 8-video course. Key concepts covered in this course include how to insert a conditional sum formula to perform a sum calculation on certain data values in your range; how to insert a conditional message formula which can be used to display one message if a condition is met, and another if a condition is not met; and how...
Course Title 17: Working with Data in PivotTables
Course Description: Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the...
Course Title 16: Inserting PivotTables
Course Description: Excel includes powerful tools to summarize, sort, count, and chart data. In this 11-video course, you will learn how to create, edit, and format pivot tables, sort, filter, and group data, and work with slicers and timelines. Key concepts covered in this course include how to create and insert a PivotTable; how to edit the source data and field setup in a PivotTable; how to use predefined styles and formatting tools to change the appearance of a PivotTable; and how to copy and move a PivotTable within a workbook. Next, learn how to...
Course Title 15: Working with Excel Tables
Course Description: Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data, as well as change its appearance and formatting. Key concepts covered in this 6-video course include how to convert a data range into an table and edit its contents, giving you greater control over the inserted information; and how to perform calculations and manipulate data in an table such as create calculated columns to perform automatic...
Course Title 14: Working with Different Chart Styles
Course Description: Excel offers a variety of different chart types and styles for presenting and analyzing data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. Key concepts covered in this 6-video course include how to insert and edit pie charts, helpful when working with percentages; how to create and edit scatter charts be used to cross-reference values and combine different data types; land how to create and edit a bubble chart used to cross...
Course Title 13: Creating Charts & Graphics
Course Description: Analyze and present your data in a more visually attractive manner in Excel 2019. Excel features several different chart types, each of which can be customized to suit your needs. In this 9-video course, you will learn how to insert and customize charts; to create chart templates and work with different chart types; and how to use trendlines. Key concepts covered in this course include how to insert, edit, and remove charts; how to customize chart labels including adding a chart title and data labels; land how to change a chart...
Course Title 12: Forecasting & Solving Problems
Course Description: Discover how to go further with your Excel document through understanding potential formula errors, use intelligent data types, and set goals to reach targets as well as problem-solve with the Solver and Forecast tools offered by Excel 2019. Key concepts in this 7-video course include how to identify formula errors and to understand the wide range of formula error messages; how to check for and evaluate formulas in a workbook; and how to use formulas to estimate loan-related costs and help you estimate and managed...
Course Title 11: Referencing Data
Course Description: Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to...
Course Title 10: Finding & Grouping Data
Course Description: Excel 2019 includes a number of methods for locating, displaying, and manipulating data entries. In this 8-video course, learners observe how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools. Begin by learning how to find items in a worksheet, by using the Find tools to jump to locations in a worksheet and find items with basic search queries. Then learn how to use advanced Find tools to customize and refine search queries; the Selection tools to locate and select...
Course Title 9: Sorting & Filtering Data
Course Description: The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column...
Course Title 8: Custom & Conditional Formatting
Course Description: To customize data, you can use the built-in formats in Excel 2019, or you can use your own. In this 10-video course, learners will observe how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting. To begin, discover how to customize your number formats, formatting currency, percentages, and phone numbers for data values. Next, observe how to customize your text formats, changing the text format by adding or modifying a text element's appearance...
Course Title 7: Sharing & Collaborating on a Document
Course Description: In this 7-video course, "Excel 2019: Sharing and Collaborating on a Document," learners will discover how Excel 2019 enables one to easily share documents via email or upload them to OneDrive and SharePoint to collaborate with a team. Stay in the loop with document comments, version history, and track change tools. Begin by learning how you can use the integrated email function to send your Excel spreadsheet to other users via email. The email is quickly created, email recipients can be adjusted, and different...
Course Title 6: Using Basic Formulas
Course Description: The power of Excel 2019 is the support provided for using formulas on your data. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following...
Course Title 5: Illustrating Documents
Course Description: An Excel 2019 worksheet can contain more than just numbers and text. In this 7-video course, "Excel 2019: Illustrating Documents," learners will discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature. Begin by learning how to insert an image or photograph, which can be used to illustrate your table, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You can adjust its brightness, contrast...
Course Title 4: Formatting Data
Course Description: Formatting data makes it easier to see and work with. In this 14-video course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format their data, the tools of which can be used to change the appearance of text in tables. Then move on to aligning your data, by using tools to change where text appears within its respective cell. Next, observe how to...
Course Title 3: Inserting & Manipulating Data
Course Description: Excel contains a number of features to aid in data insertion and manipulation. In this 17-video course, learners can explore various ways to insert, edit, and manipulate data, including undo and redo, Flash Fill, spell check, and transposing a data range. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to...
Course Title 2: Creating & Saving Workbooks
Course Description: In Excel 2019, it is easy to create and save new workbooks. This 15-video course demonstrates how to create, manage, and save documents, insert headers and footers, edit document properties, and protect Excel workbooks from unwanted edits and use. You will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save a...
