Seat time: 2 hours
About the course:
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to add comments and share workbooks. You will also sort data and apply filters, use custom and conditional formats as well as validate data.
Modules:
- Using Comments
- Sharing Workbooks
- Sorting and Filtering Data
- Custom and Conditional Formats
- Validating Data
You'll learn:
Using Comments
- Insert New Comments
- Read Comments
- Edit Comments
- Display Comments
- Hide Comments
- Navigate Comments
- Delete Comment
Sharing Workbooks
- Sharing Methods
- Share with people
- Uploading to OneDrive
Sorting and Filtering Data
- Filter Data
- Apply Multiple Search Criteria
- Customise Filters
- Sort with AutoFilters
- Remove Filters
- Sort on Multiple Columns
- Add and Remove Subtotals
- Display Unique Values
- Remove Duplicate Entries
Custom and Conditional Formats
- Apply Numeric Formats
- Apply Currency Formats
- Apply Accounting Formats
- Create Custom Formats
- Use Conditional Formatting
- Create Formatting Rules
- Display Icon Sets
- Clear Rules
- Use Data Bars
Validating Data
- Use the Data Validation feature
- Set Validation Criteria
- Create Input Messages
- Create Error Alert Messages
- Create Named Ranges
- Create Data Entry Lists
- Enter Data Using Lists