From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Prepare for the test and review learning objectives - Microsoft Excel Tutorial
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Prepare for the test and review learning objectives
- [Instructor] Let's talk about how to prepare for the MOS exam. First of all, what to study. Well, we've inserted into your chapter one file folder a list of objectives for the Excel Associate exam. Here is a list of the objectives, and the numbers listed for each objective correspond to the numbers in the video series. So for example, starting with chapter two, Manage Worksheets and Workbooks. You'll be watching videos where you will have a chance to practice importing text/CSV, JSON, XML, PDF, and web formats. You'll also practice searching for data within a workbook. Navigating to name ranges, and using hyperlinks. Inserting and removing hyperlinks. Formatting worksheets and workbooks. Customizing headers and footers. Managing the Quick Access Toolbar. Displaying and modifying worksheets in different views. Modifying built-in workbook properties. Inspecting and exporting workbooks.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.