Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This class 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 class 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.
Notice: Per City guidelines, masking will be strongly recommended but not mandatory. Wearing a high-quality mask such as KN95 or N95 mask, or double masking, is strongly encouraged. It is important to wear a mask that is well-fitted. For information on proper masking, including how to double mask, please read this guidance from the CDC: https://www.cdc.gov/coronavirus/2019-ncov/your-health/effective-masks.html.
1: Getting Started with Microsoft Office Excel 2019
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views Topic C: Manage Workbook Properties
Upon completion of this workshop students will know how to:
· Get started with Excel 2019.
· Perform calculations.
· Modify a worksheet.
· Format a worksheet.
· Print workbook contents.
· Manage large workbooks.
Handouts will be provided by the instructor.