Microsoft Excel Functions Training Overview
This online Microsoft Excel training course teaches attendees how to master using the Text, Date, and Management functions in Excel.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Clean up improperly structured text information
- Calculate deadlines and durations
- Set up automatically updating configurations
- Handle dates numerically and present them in various ways
Prerequisites
All students must have some experience with Excel functions.
Outline
Expand All | Collapse All
Introduction to Presentation and Structure Functions
- Course Introduction
- Function Family Overview
- Use Cases for These Functions
Text-Part Functions
- Trimming Functions
- Capitalization Functions
- Concatenation
- Text Segmentation
- Text Function Alternatives
Date Functions
- Date-Part Functions
- Date Formatting Functions
- Deadlines and Durations
Dynamic Labeling
- Creating Dynamic Text Components
- Dynamic Data Labeling
- Dynamic Titling
- Dynamic Diagrams
Conclusion
Training Materials
All Excel training attendees receive comprehensive courseware.
Software Requirements
All attendees need a full installation of Office 365, including Microsoft Excel.
