Description
The Accounting Information Systems exercise is the final step in the Pathway to Excel Certification. The exercise covers roughly 25% of the material on the Microsoft Office Specialist Excel certification exam (MOS 200). 42 different Excel concepts are taught:
- Opening XLSX workbook
- Managing table styles
- WordArt feature
- Saving XLSM document format
- Split Window command
- Text Box feature
- Print to PDF
- Create pivot table
- Formatting shapes
- Using Excel templates
- Sparklines feature
- Set workbook properties
- Saving as XLS for backwards compatibility
- Remove Duplicates command
- Customize ribbon
- Import CSV file
- Quick Analysis feature
- Customize Quick Access Toolbar
- Hiding columns
- Create a chart
- CONCAT function
- Table feature
- Duplicating charts
- COUNTIF function
- Adding total row to tables
- Switch rows/columns in chart
- IF function
- Date formats
- Chart styles and borders
- IFNA function
- Filter feature
- Create organizational chart
- ISNA function
- Reapply command
- Macro Recorder feature
- MATCH function
- Inserting worksheets
- Creating macro shortcuts
- NOT function
- Workbook themes
- Enabling macros/macro security
- VLOOKUP function
Users carry out three unguided activities to reinforce material covered in the exercise:
- Changing worksheet names
- Hiding worksheet columns
- Adding worksheets
If you get stuck simply email ask@davidringstrom.com for assistance.
