Continue to dive into the advance skills of Excel 365. This course will offer more detailed skills in pivot tables, data management and exchanging Excel data with other programs. After finishing this course you will be well versed in how to use Microsoft Excel 365 in any situation.
Skills you’ll gain
Microsoft ExcelData ManagementMicrosoft Office 365What You'll Learn
- Create, edit, and use macros to automate tasks in Excel 365
- Build and manipulate pivot tables, including grouping by date, time, and other factors
- Apply slicers and pivot charts to summarize and visualize data
- Use Goal Seek, Solver, Scenario Manager, and Data Tables for what-if analysis
- Manage data with tables by sorting, filtering, splitting columns, Flash Fill, and removing duplicates
- Exchange Excel data with other programs by embedding, linking, and importing objects
Key Takeaways
- This course covers advanced Excel 365 skills, building on prior Excel knowledge.
- It provides detailed instruction in pivot tables, data management, and exchanging Excel data with other programs.
- Learners practice creating and editing macros, outlining and subtotaling data, and using validation tools.
- The course includes data analysis tools such as Goal Seek, Solver, and Scenario Manager.
- On completion, learners will be well versed in using Microsoft Excel 365 in any situation.
Frequently Asked Questions
Who is this course for?
It is for learners who want to continue building advanced skills in Excel 365, offering more detailed skills in pivot tables, data management, and exchanging Excel data with other programs.
What topics does the course cover?
It covers creating, editing, and using macros, pivot tables and pivot charts, slicers, lists, outlining and subtotaling data, Goal Seek, Solver, Scenario Manager, data tables, sorting and filtering with tables, splitting data into columns, Flash Fill, removing duplicate records, validation tools, and embedding, linking, and importing objects to and from Excel.
What skills will I gain from this course?
You will gain skills in Microsoft Excel, Data Management, and Microsoft Office 365.
What will I be able to do after finishing the course?
After finishing this course you will be well versed in how to use Microsoft Excel 365 in any situation.
Transcript
Show transcript (free preview lesson)
Transcript of the free preview lesson. Remaining lessons unlock with the full course.
Hello, and welcome to KnowledgeCity's course on "Excel 365 Advanced" class. My name is Steve Paulick. I will be your instructor, teaching you this course. I have also taught the Excel 365 Beginner and Intermediate courses. I am a Microsoft certified professional and CompTia A+ computer consultant. I have been the president and owner of a computer repair, networking, and software company for the past 20 years. I have three college degrees in computers, which include computer science, programming, networking, and GIS. I have programmed, designed, and created professional software programs. I have helped and taught over 3,500 clients how to use Microsoft computer software, hardware, and peripherals. Now, let's go over what we'll be learning in this course. We'll be learning how to create and use macros, how to create and use pivot tables, working with lists, data analysis tools, data management, and also exchanging Excel data with other programs. So, stay tuned for the course.
Learn on the Go
Take your learning anywhere — the KnowledgeCity mobile app lets you watch lessons on the go.