Overview
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. 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.
Prerequisites
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 environment and be able to use Windows® 10 to manage information on their computers. Specific tasks the students should be able to perform include opening and closing applications, navigating basic file structures, and managing files and folders.
Why Microsoft Excel For Office 365 training?
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks that will help you analyze the data that is critical to the success of your organization.
The DVIRC Difference
This interactive instructor led workshop, with hands on exercises, will provide the foundational elements to enhance your Microsoft Excel skills.
Key Learning Outcomes
- Get started with Microsoft Excel
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbooks
- Manage workbooks
Who Should Take This Course
This course is intended for students who wish to gain the foundational understanding of Microsoft Excel for Office 365™ that is necessary to create and work with electronic spreadsheets.
Course Outline
- GETTING STARTED WITH EXCEL
- PERFORMING CALCULATIONS
- MODIFYING A WORKSHEET
- FORMATTING A WORKSHEET
- PRINTING WORKBOOKS
- MANAGING WORKBOOKS
Benefits
As the most widely used spreadsheet application today, Microsoft Excel has a lot of benefits for anyone who uses the application and begins down the road to mastering spreadsheet skills. Microsoft Excel for Office 365 is a great way to get a skills refresher in the areas of performing calculations, printing reports, and formatting a spreadsheet, as well as helpful shortcuts to save you time. Folks who have moved to Office 365 will benefit by learning the different features of Excel for the mobile user in Office 365.
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.
