Seat time: 3 hours
About the course:
This course covers topics included in the MOS Expert exam 77-728. This includes using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools.
Modules:
- Logical and Informational Functions
- Time and Mathematical Functions
- Lookup Functions
- Consolidating Workbooks
- Auditing Tools
- Protecting Workbooks
- Sharing Workbooks
You'll learn:
Logical and Informational Functions
- IF Function
- OR Function
- AND Function
- Help for Error Messages
- Nested IF Functions
- IS Functions
- ISERROR Function
Time and Mathematical Functions
- Using Functions
- Insert Function Box
- TODAY Function
- Displaying Dates as Numbers
- DAY Function
- MONTH Function
- YEAR Function
- COUNT Function
- COUNTA Function
- COUNTIF Function
- SUMIF Function
- AVERAGEIF Function
- ROUND Function
- Nesting Functions
- Circular Functions
- Iterative Calculations
Lookup Functions
- VLOOKUP Function
- Creating Lookup Tables
- Inserting Functions
- VLOOKUP Arguments
- LOOKUP Function
- Modify Lookup Data
- HLOOKUP Function
Consolidating Workbooks
- Consolidating Data
- What is Consolidation
- Selecting Destination Area
- Consolidating Workbooks
- Creating Links
- Updating Linked Data
- Outlining Features
Auditing Tools
- Using Auditing Tools
- Trace Precedents
- Trace Dependents
- Removing Tracer Arrows
- Tracing Errors in Formulas
- Correcting Formula Errors
- Viewing Formula Locations
- Show Formulas
Protecting and Sharing Workbooks
- Protecting Worksheets
- Removing Protection
- Protecting Workbooks
- Opening Protected Workbooks
Sharing Workbooks
- Sharing Methods
- Share with People
- Uploading to OneDrive