Excel Microsoft 365 Advanced
What you'll learn
- Excel Macros
- Excel Pivot Tables
- Excel Lists, Data Analysis Tools
- Excel Data Management
Requirements
- Should have basic/intermediate knowledge of Microsoft Excel software
Description
This Advanced Excel 365 class will teach you how to create and use Macros, Pivot tables, Lists, Data analysis tools, Data management, Exchanging excel data with other programs. A Downloadable 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 Changing and Manipulating Pivot Table Data
009 Grouping by date and time
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 Exchanging 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
Downloadable Test Quiz is included with enclosed answer key
Who this course is for:
- Business, or individuals wanting to learn advanced features of Excel 365
Instructor
- 4.2 Instructor Rating
- 25 Reviews
- 77 Students
- 3 Courses
Steve Paulick is a Microsoft Certified Professional and CompTIA A+ Computer consultant. He has been the President and owner of Computer Physicians, LLC computer repair, networking and software company in Colorado USA for the past 20 years. He is also the creator of Song Director music software. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals.