Learning Excel 365 - Advanced (TOSA) https://DevCourseWeb.com MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 55 lectures (5h 35m) | Size: 4 GB
There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were
What you'll learn
Create and use named ranges
Insert functions into spreadsheets including: Date and Time functions, Conditional functions, Database functions, Lookup functions, and Subtotals
Perform custom and advanced filtering
Apply advanced charting tools and create a chart template
Create a Pivot Table and apply advanced Pivot Table features, as well as filter data using Slicers and Timelines
Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links and Consolidate
Collaborate with others using Co-Authoring and Compare and Merge
Prepare a document for sharing by adding a digital signature, as well as use multiple ways to protect your worksheets and workbooks from changes
Keep your data consistent and accurate with Data Validation and automate tasks with Macros
Provide quick and easy access to navigate, modify, and enter data using Forms and Form Controls
Requirements
People working toward their TOSA certification, who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data