OneDDL Posted August 7, 2021 Report Share Posted August 7, 2021 MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + srt | Duration: 36 lectures (2h 57m) | Size: 1.37 GB Excel Microsoft 365 Advanced Macros, Tables, Lists, ManagementWhat you'll learn: Excel Macros Excel Pivot Tables Excel Lists, Data Analysis Tools Excel Data ManagementRequirements Should have basic/intermediate knowledge of Microsoft Excel softwareDescription 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 keyWho this course is for Business, or individuals wanting to learn advanced features of Excel 365 Homepagehttps://www.udemy.com/course/excel-microsoft-365-advanced[b]Download (Uploadgig)[/b] https://uploadgig.com/file/download/6f9D3dd9dC6e27d9/dibyk.Excel.Microsoft.365.Advanced.part1.rar https://uploadgig.com/file/download/9e5fF78a728eD52d/dibyk.Excel.Microsoft.365.Advanced.part2.rar Download ( Rapidgator ) https://rapidgator.net/file/eae8094446066859a0da18dfaaa19a0b/dibyk.Excel.Microsoft.365.Advanced.part1.rar.html https://rapidgator.net/file/7517ed89d27f31d15a57b3c763106f69/dibyk.Excel.Microsoft.365.Advanced.part2.rar.html Download ( NitroFlare ) http://nitro.download/view/86D01FF26B38817/dibyk.Excel.Microsoft.365.Advanced.part1.rar http://nitro.download/view/2A76FDB86FCE248/dibyk.Excel.Microsoft.365.Advanced.part2.rarLinks are Interchangeable - No Password - Single Extraction Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now