Overview
Microsoft Excel For Office 365 (Desktop or Online) Part 2
This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course, and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization which can compete at a high level.
Prerequisites
Microsoft Excel for Office 365 Part 1, or possess skills detailed in Part 1 outline.
Course Outline
- WORKING WITH FUNCTIONS
- WORKING WITH LISTS
- ANALYZING DATA
- VISUALIZING DATA WITH CHARTS
- USING PIVOTTABLES AND PIVOTCHARTS
- MANAGING WORKBOOKS
Why Microsoft Excel For Office 365 training?
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation to be able to make informed, intelligent, organizational decisions.
The DVIRC Difference
This interactive instructor led workshop, with hands on exercises, will provide you with an advanced skillset to enhance your Microsoft Excel capabilities. Specifically, this course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.
Key Learning Outcomes
- Work with functions
- Work with lists
- Analyze data
- Visualize data with charts
- Use PivotTables and Pivot Charts
Who Should Take This Course
This course is designed for students who already have foundational knowledge and skills in Excel, and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Benefits
Microsoft Excel for Office 365 Part 2 provides the additional skills needed in today’s environment to store data, share, and analyze data with advanced Excel spreadsheets in a greater capacity. You will learn the skills needed to work with spreadsheet functions, visualize charts, and work with multiple workbooks and receive an introduction to Pivot Tables. A must have/ go to class for those who want to increase their application toolset with Excel or whose job role requires using Excel on a daily or increasing basis.
Cancellation Policy
Cancellations received up to 5 business days prior to class start date will not be charged the training fee, or will be refunded if payment has already been submitted. Cancellations 1-3 business days prior to class will be charged the training fee. As a courtesy, we will allow you to apply 50% of your payment towards a future training course within one year of the cancellation date. No refund will be provided for same-day cancellations and no-shows; customer is responsible for full payment without future training credit. Registrant substitutions may be made at any time. Cancellations must be submitted via email to jenoch@dvirc.org or by phone at 215-552-3827.
COVID-19 Policy
DVIRC recommends all guests be vaccinated against COVID-19.
Unvaccinated visitors must take a rapid test (which may be supplied by DVIRC) and receive a negative response. Considering the test will take about 15 minutes to process, all unvaccinated guests should arrive 15 minutes early to ensure they can take the rapid test and receive negative results before they proceed to the training room or to their scheduled meeting within the building.
