Title: Mastering Excel 365 - Advanced

Title

Mastering Excel 365 - Advanced

Package

Digitale SAP-Bibliothek

Platform

Your learning platform for SAP software

URL

https://et.training/dashboard/product/video/997 

Status

Deleted

Publication Type

Other

Medium

Empty

Language

First Author

Triple Tech LLC dba Bigger Brains

First Editor

Empty

Publisher Name

Empty

Date First in Print

Empty

Date First Online

2022-01-01

Access Start Date

Empty

Access End Date

Empty

Volume Number

Empty

Edition Statement

Empty

Access Type

Empty

Note

"There are two kinds of people: Those who are masters at Excel 365, and those who wish they wereWhen you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. Once you have completed this course, there are few things you won’t be able to do with Excel!Topics covered include:Collaborating and SharingEfficiency functionsAuditing FunctionsForecasting data and trendsLesson:IntroductionCreating Internal LinksCreating External LinksUsing Paste SpecialUsing Group ModeUsing 3D ReferencesConsolidating DataAdding CommentsTracking ChangesCo-Authoring, Part 1Co-Authoring, Part 2Using Sheet ViewsUsing Compare and MergePreparing to ShareAdding Digital SignaturesProtecting WorksheetsProtecting Workbook StructureProtecting a Workbook FileApplying Data ValidationAdding a Dropdown ListCustomizing Data ValidationRecording a MacroRunning a MacroEditing a MacroUsing VLOOKUP, Part 1Using VLOOKUP, Part 2Using XLOOKUPMore Lookup FunctionsUsing Array FormulasTracing FormulasAddressing Formula ErrorsWatching and Evaluating FormulasAdding Error HandlingWorking with Information FunctionsUsing Goal SeekForecasting with Data TablesUsing SolverForecasting with ScenariosForecasting Data TrendsInserting Symbols and Special CharactersCreating SparklinesCreating a Map ChartCreating a 3D Map TourCreating Custom ListsImporting and Exporting DataCreating a Web QueryUsing Data TypesWorking with FormsUsing ActiveX ControlsIdeas in Office 365"

Last Changed External

Empty