Catalog

This course provides a comprehensive introduction to Microsoft Excel, focusing on the essential skills needed to manage and analyze data effectively. Participants will learn to create, modify, and format Excel worksheets and workbooks, aligning with the Microsoft Office Specialist Program exam objectives for both the Excel Associate (Office 365 and Office 2019) Exam MO-200 and the Excel Expert Exam MO-201. Throughout the course, participants will explore key Excel functionalities, including performing calculations, data formatting, and workbook management. Emphasis is placed on developing the practical skills necessary for accurate data manipulation and analysis, critical for organizational decision-making. By the end of the course, attendees will be proficient in using Excel to handle and analyze data, laying the groundwork for further advancement in Excel expertise. This course is ideal for professionals seeking to build a solid foundation in Excel and those preparing for certification exams.

##### Module 1 - Getting Started with Excel - Navigate the Excel User Interface - Use Excel Commands - Create and Save a Basic Workbook - Excel Online - Enter Cell Data - Use Excel Help ##### Module 2 - Performing Calculations - Create Worksheet Formulas - Insert Functions - Reuse Formulas and Functions ##### Module 3 - Modifying a Worksheet - Insert, Delete, and Adjust Cells, Columns, and Rows - Search for and Replace Data - Use Proofing and Research Tools ##### Module 4 - Formatting a Worksheet - Apply Text Formats - Apply Number Formats - Align Cell Contents - Apply Colors, Borders, and Styles - Apply Basic Conditional Formatting - Create and Use Templates ##### Module 5 - Printing Workbooks - Preview and Print a Workbook - Set Up the Page Layout - Configure Headers and Footers ##### Module 6 - Managing Workbooks - Manage Worksheets - Manage Workbook and Worksheet Views - Manage Workbook Properties