Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for the advanced level MS Excel 2016 Complete, MS Excel 2019 CompleteĮxcel Pivot Tables: Master all the features of Excel pivot tables, including little-known options and settings, layouts, calculated fields, multi-level subtotals, Pivot Charts, Timelines, and Slicers. Explore the analytical features of Excel, running and recording macros, SmartArt graphics, and conditional formatting with graphics.Įxcel Advanced, MS Excel 2016 Advanced (online), MS Excel 2019 Advanced (In-Person), MS Excel 2019 Advanced (online).Įxcel Complete: A combination of the Excel 2016 Introduction, Intermediate, and Advanced courses in one comprehensive course. Excel Intermediate, MS Excel 2016 Intermediate (In-Person), MS Excel 2016 Intermediate (online), MS Excel 2019 Intermediate (In-Person), MS Excel 2019 Intermediate (online)Īdvanced: Learn advanced formulas, lookup functions, data validation and database functions, importing and exporting data, and how to query external databases. Also covered are advanced charting techniques, worksheet auditing and protection, file sharing and merging, workbook templates, and PivotTables and PivotCharts. Intermediate: Learn how to use multiple worksheets and workbooks efficiently, and work with more advanced formatting options including styles, themes, backgrounds, outlines and subtotals, create and apply cell names, work with tables, save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email.
Create, edit, format, and print basic Excel worksheets.Įxcel Introduction, MS Excel for Office 365 Introduction for Office 365, MS Excel 2016 Introduction, MS Excel 2019 Introduction
Introduction: Learn the basic functions and features of Excel: spreadsheet terminology, the Excel environment, and the Help system. Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for intermediate and advance levels
0 kommentar(er)
