Microsoft Excel TOSA Excel 2019 E-Learning
TOSA Excel 2019 E-Learning
Order this unique E-Learning course TOSA Excel 2019 online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.
Acquire the skills needed to utilize Microsoft Excel in a work environment as you prepare for the TOSA
Excel 2019 and TOSA Excel 365 certification exams.
Getting Started with Excel for Office 365
Get started with Excel Office 365. This course explores the interface and some of it's features and functions. See how to Find Excel from your Windows 10 search bar, and start menu; pin the Excel icon to the task bar for easy access. Familiarize yourself with the Excel interface. Discover Excel’s features and functions, such as the ribbon with multiple tabs, the status bar, and the Quick Access toolbar. Zoom in on your work, or zoom out to get the big picture. Preview page breaks, page layout, and enter data in normal mode. Open multiple worksheets simultaneously. Finally, explore how to adjust and move between views.
Inserting & Manipulating Data
1 hour 17 minutes
Delve into data manipulation techniques with Excel Office 365 for Windows. In this course, learners can explore numerous ways to insert, edit, replace or delete data. Key concepts covered in this course include; how to insert a text character or symbol if this is not located on your computer; how to perform simultaneous edits of data cells with the same cell locations, but found on different worksheets. Learn how to simultaneously edit cells across multiple worksheets; undo previous actions; create an automatic data series; and flash fill data ranges, based on patterns. Other topics include how to limit values and speed up data entry with drop down menus; how to use and configure spell check and autocorrect; edit the dictionary and copy and paste data. Explore how to format values and formulas within spreadsheets, between spreadsheets, or within workbooks; transpose a data range. Finally, familiarize yourself with how to extract data from multiple worksheets and consolidate.
Formatting data makes the data easier to see and work with. Refine your data's appearance, with Excel Office 365 for Windows. During this course, you will learn how to align data, use colors, and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of data. You will learn how to organize your data into a table, format, sort, and apply filters and themes, and format a title. Explore topics such as how to adjust color, outlines, rotation, shadows, glows, and reflections; resize columns and rows; insert new columns and rows; change cell styles. Add cell borders. Alter background and data colors. Standardize your data's typographical appearance. Adjust the vertical and horizontal alignment of data. Adjust font effects. Employ text conversion formulas, to change capitalization and proper nouns. Transfer your format to another data selection.
An Excel for Office 365 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature. Key concepts covered in this 7-video course include how to insert images and photographs to illustrate a table; how to insert a screenshot and to move, resize, or crop it; and how to edit an image by adjusting its brightness, contrast, and saturation levels and even adding a border. Next, you will learn how to create diagrams by using shapes and adding shape effects; learn how to insert and modify icons in a worksheet; and learn the best practices for inserting a hyperlink into your sheet. Finally, you will learn how to use the Smart Lookup tool to quickly access additional information about words used in your document and see images, definitions, and information appearing on the Web, related to the selected word, by using this tool.
Using Basic Formulas
Formulas in MS Excel for Office 365 are useful in helping you visualize data. This course explores the large collection of formulas available in the Excel searchable library. Learn how to program each data cell to perform calculations, insert subtotals, create automated cumulative totals, and apply a formula to a large number of entries with the fill down function. Observe how to employ the COUNTA, COUNTIF, number rounding, and replacement formulas. Other topics explore how to rank a value with the rank function; convert between binary and hexadecimal number systems; factorize division results with the QUOTIENT and MODE formulas, and generate random values.
Custom & Conditional Formatting
In this 10-video course, learners can explore how to use built-in formulas in Excel for Office 365, and how to create their own formats. This course demonstrates how to properly display a value—for example, a fraction, currency, or telephone number. You will then learn how to use the custom text format menu to insert additional data into cells, and to change the appearance of existing text. You will learn to use a variety of date and time formats built into Excel, how to create a customized format, and how to modify the color applied to data in a spreadsheet. This course demonstrates how to use Conditional Formatting highlights by adding visual indicators to data values, for example, to highlight specific cells, rows, or columns. You will learn how to use several Conditional Formatting tools to analyze data, and to use advanced conditional formatting by highlighting specific data criteria. Finally, learn how to set the hierarchical order of the Conditional Formatting rules apply, and how to resolve rule conflicts in Excel.
Sorting & Filtering Data
This 10-video course offers learners an in-depth exploration of Excel's sorting and filtering tools used to analyze data in a spreadsheet. You will learn how to control what is displayed in a data range, and how the values are organized in a worksheet. This course then demonstrates how to sort a data range by alphabetical order, and in value ranges. Learn how to include or exclude a header, and change the sort orientation from vertical to horizontal. Then learn how to create multiple sort levels to change how data are presented. You will learn how to create a custom sort list, and how to use column filters to show or hide different data values in your data range. You will learn to filter the data of a range and show values to meet specified criteria. This course demonstrates how to apply color coding to data items in a table, and how to use these codes to sort and filter data. Finally, learners observe how to create advanced filter criteria by using a separate table.
Explore how to use reference cells in Excel for Office 365 in this 10-video course, which shows learners how to use cell coordinates to extract specified cell values, to reference individual cells, a range of cells, and entire columns and rows. First, learn how to reference data stored in different workbooks. Then you will examine when to use absolute, relative, and mixed cell references using the Fill function, or to copy formulas to a different cell or spreadsheet. You will learn how to name data ranges, how to refer to them in later calculations, and how to edit, adjust, and manage named ranges. This course demonstrates how to visualize, edit, and remove name ranges. You will learn how to use the INDIRECT formula to refer to a cell indirectly. You will learn how to use the Watch Window to monitor selected data entries from separate spreadsheets simultaneously, and how to activate and deactivate automatic updates. Finally, you will learn how to audit formulas in Excel.
Creating Charts & Graphics
Learners can explore the use of charts in Excel for Office 365 to enhance the look of data in this 10-video course, which demonstrates how to use several of Excel's charts, and how to customize charts for specific data. You will learn to use the Quick Analysis tool to insert a chart, and how to use visualized patterns to display data. This course then examines how to label charts, and how to choose which elements to show, including labels, legends, and titles. Learners will observe how to use the Formatting tools to change a chart's appearance. You will learn to customize your chart axes, how to adjust measurements, how to move maximum and minimum values, and how to change the point where the two axes cross in the chart. This course examines how to use Sparklines to represent an overall trend of a selected data range, and to format them further. Finally, you will learn how to select a color scheme, mark different data points, and even highlight the negative values in a trend.
Working with Different Chart Styles
In this 6-video course, you will explore the variety of chart types and templates available in Excel for Office 365 to visually enhance the displayed data. First, learn how to insert, format, and manipulate charts, starting with a pie chart. You will then learn how to insert and use a scatter chart to analyze correlations and relationships between different data series. This course demonstrates the use of bubble charts to reference three different types of information in a single chart. Learners will examine how to use a radar chart to plot five different data values, and how to compare the form and size of the shape created along the five different axes to get an overall representation of the data series. You will learn to use a combo chart to create a graphic that combines multiple data types. Finally, when you have data relating to regions, countries, or other locations, you will learn how to use the map chart to plot values on a geographic display.
This 11-video course provides learners with an in-depth exploration of how to use PivotTables in Excel for Office 365. PivotTables are highly customizable and can be used to extract patterns and trends that you may have initially missed in your data. You will learn how to create a PivotTable, and to modify it to change which fields have been inserted, and change the performing calculations. Next, you will learn to improve the appearance of your PivotTable by changing the style, color settings, and the fonts. This course demonstrates how to use the automatic sorting tools, drag and drop labels, and to sort your data by value. You will examine filters in Excel, and how label filters can be used to show and hide data based on the label associated with data values. You will observe how to use slicers to filter and manipulate data in a PivotTable, which provides a clear visual guide to the table's contents. Finally, you will learn to use the Timeline tool to work with dates in your PivotTable.
Working with Data in PivotTables
Explore ways to analyze data for trends by using a PivotTable in Excel for Office 365, in this 8-video course, which demonstrates how to organize fields, add extra levels of detail to data, and to insert multiple value fields in a single table. You will observe how to use a data model to pull data from multiple tables and build a relational data source inside a workbook. This course demonstrates how to pull data from external sources, for example, an Access database, and analyze it in a PivotTable. You will learn to insert calculated fields that use already inserted data in the PivotTable. You will also learn how to change a summary calculation or apply a comparison in a PivotTable, and how to visualize data rank as a percentage or as a difference. You will learn how to create a new PivotChart or convert already inserted data in a PivotTable. Finally, you to use PivotTable options to change how null data values and errors are displayed.
Using Conditional Formulas
This 8-video course explores how to use built-in formulas to perform a calculation on a range of values in Excel for Office 365. You will begin by learning how to insert a conditional sum using SUMIF formulas to perform a sum calculation on selected data values in your range. You will next learn how to use the IF function to determine whether a condition is met or not met, and to use the IF function in conjunction with other formulas. This course continues by demonstrating how to embed multiple IF formulas within one another to obtain multiple result options. You will learn to combine qualifying and alternate conditions using the IF and OR in conditional formulas. Next, learners will observe how to use Conditional Formulas to count value occurrences. You will learn to use reference positions in Conditional Formulas. Finally, this course demonstrates how to keep your table up to date with Conditional Formulas by using formulas such as COUNTA and OFFSET.
Finding & Analyzing Information with Formulas
Learners can explore the wide variety of tools available in Excel 365 for Office to retrieve, return, and calculate data in Excel, in this 9-video course. First, learn several formulas to automatically find a date for a specific month, day, or year. Then learn how to use Excel's RANK function to find a specific value in a data list, and how to use SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXT JOIN formulas to combine data from multiple cells into a single cell. You will observe how to use SUMPRODUCT formula to link calculations to produce a summary of a data table. Continue by learning how to use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists, and to find data in a table or data range in one list by using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform lookup operations with lists and return corresponding values.
Configuring Options & Settings
This 10-video course offers learners an in-depth exploration of how to customize Excel for Office 365 to their specific requirements. Learn how to connect to SharePoint, OneDrive and the Office Store from your Microsoft account. Then learn how to search the add-in store, install an add-in, and to manage installed add-ins from the Office ribbon. Learners will observe how to create a custom template, and make it a default template. This course demonstrates how to activate and deactivate the Live Preview function, to switch off the Quick Analysis tools, hide the mini-toolbar, and other customizations. You will learn to specify the number of worksheets in a new document, change the default font, and the View Mode. Continue by learning how to configure AutoSave, and to adjust the default Save format and location. This course demonstrates how to change the background and theme, customize your Office copy, change your window and status appearance, and language settings. Finally, you will learn how to add shortcuts with the Quick Access Toolbar, and customize the Office Ribbon.
- 11:21 hours
- Certificate of participation
- Online access
- 365 days
- Progress monitoring
- Award Winning E-learning
- Suitable for mobile
There are no reviews written yet about this product..