On this intermediate course you will learn to manipulate data using sorting and filtering, conditional formatting, PivotTables and advanced charting. You will share data across multiple workbooks, add graphics and learn to collaborate with others.You will be learning Microsoft Excel from a live instructor.They will teach you step-by-step how to master Excel, using demonstrations, hands-on exercises and one-on-one help.Suitable for Excel 2016, 2019 & 365 users.Course OutlineManaging WorkbooksInserting and Deleting WorksheetsRearranging WorksheetsAdding HyperlinksLinking to other WorkbooksCustomizing ExcelNamed RangesUsing Names in FormulasOther ways to use Named RangesNaming ShortcutsManaging Named RangesFiltering and Sorting Data TablesSorting DataCustom SortsFiltering TablesUsing Auto-FilterRemoving Duplicate RowsWorking with Structured ReferencesData ValidationTransposing Rows and ColumnsSummarizing DataConsolidating DataUsing Sub-totalsPivotTablesAbout PivotTablesCreating PivotTablesFormatting PivotTablesManipulating PivotTablesViewing Subsets of PivotTable DataAdding SlicersCreating PivotChartsPresentation FeaturesConditional FormattingGraphical Conditional FormattingCustom FormatsAdding GraphicsAdding Smart ArtAdvanced ChartsSpecial Chart TypesInserting TrendlinesCombination ChartsChart TemplatesInserting SparklinesQuick Analysis OptionsCollaborationControlling Access with PermissionsProtecting and Securing WorkbooksShared WorkbooksAdding CommentsTracking ChangesMerging Shared WorkbooksOur outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
Overview
Taught by
Training Connection
