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

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.…

Contents