We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today!

Excel 2019

Advanced
Subscribe Now

Course Overview

Instructor: Edward McCrae
Subject: Excel 2019
Duration: 03 Hour 56 Minutes
Level: Advanced
Pre-requisites: Excel 2019 Introduction and Intermediate courses or equivalent experience.
CC Languages: Arabic, Chinese (Simplified) , English, French, German, Hindi, Japanese, Portuguese (Brazil), Russian, Spanish

Description

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Course Lessons

Introduction
Introduction1min 20sec
Customizing Excel Analyzing Data with Logical Functions Working with Lookup Functions Using Text Function Working with Date and Time Functions Formula Auditing What-If Analysis Tools Worksheet and Workbook Protection Automating with Macros Working with Form Controls Ensuring Data Integrity Collaborating in Excel Importing and Exporting Data to a Text File Conclusion
Course Recap1min 13sec

Edward McCrae

Instructor

Ed specializes in Excel Workbook development, Access Database Design, and SharePoint site creation and administration. Ed has been in the technical training industry since 2006 and has taught Microsoft Office 97-2016, Microsoft Project, SharePoint 3.0 – 2013, as well as a host of other applications and business skills classes.

Learn More About Edward McCrae