Excel Microsoft 365 Advanced Macros, Tables, Lists, Management

Excel Macros

Excel Pivot Tables

Excel Lists, Data Analysis Tools

Excel Data Management

Should have basic/intermediate knowledge of Microsoft Excel software

A able Test Quiz is included with enclosed answer key.

Table of Contents

Microsoft Excel 365 Advanced course - Steve Paulick

000 Introduction Excel 365 advanced

001 Overview of entire course Excel 365 advanced

Chapter 1: Introduction to Macros

002 Overview

003 Understanding and creating macros part 1

004 Understanding and creating macros part 2

005 Running and editing a macro

Chapter 2 Pivot Tables

006 Overview

007 Creating Pivot Tables

008 Chag and Manipulating Pivot Table Data

009 Grouping by date and

010 Grouping by other factors

011 Using slicers to clarify and manipulate fields

012 Using Pivot Charts

Chapter 3 Working with lists

013 Overview

014 Query Data with Database functions

015 Outline and Subtotal data Part 1

016 Outline and Subtotal data Part 2

017 Outline and Subtotal data Part 3

Chapter 4 Data Analysis tools

018 Overview

019 Using goal seek

020 Using solver

021 Using scenario manager

022 Using data tables

Chapter 5: Data management

023 Overview

024 Sorting data

025 Using filters

026 Splitting data into multiple columns

027 Using flash fill

028 Removing duplicate records

029 Using validation tools

Chapter 6 Exchag Excel data with other programs

030 Overview

031 Embedding objects from Excel

032 Linking objects from Excel

033 Importing objects into Excel

034 Working with Raw data

035 Conclusion

able Test Quiz is included with enclosed answer key

Business, or individuals wanting to learn advanced features of Excel 365




DOWNLOAD
uploadgig.com


rapidgator.net


nitro.download