microsoft partner logo color
8245  Reviews star_rate star_rate star_rate star_rate star_half

Excel Functions: Text, Date, and Management

This Excel course teaches learners to confidently manipulate text and date data to create efficient, insightful, and professional-looking spreadsheets. Learners discover how to clean and structure...

Read More
Course Code OFC-128-HF
Duration 4 hours
Available Formats Classroom

This Excel course teaches learners to confidently manipulate text and date data to create efficient, insightful, and professional-looking spreadsheets. Learners discover how to clean and structure text, calculate deadlines and durations with precision, and use dynamic labeling for charts, diagrams, and titles.

Skills Gained

  • 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.

Course Details

Training Materials

All Excel training attendees receive comprehensive courseware.

Software Requirements

All attendees need a full installation of Office 365, including Microsoft Excel.

Outline

  • 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