8781  Reviews star_rate star_rate star_rate star_rate star_half
Contact Us For Pricing
Duration 1 day
Course Code OFC-110-HF
Available Formats Classroom

Overview

Course Description

This Excel 365 course teaches learners how to efficiently set up Excel 365, create workbooks with automated features, and harness the power of tables, pivot tables, and charts for insightful data analysis. By the end of this course, learners will have the skills to navigate Excel 365 with confidence and leverage its tools for increased productivity.

Skills Gained

  • Set up Excel 365
  • Create a Workbook using automation
  • Work with Tables and Pivot Tables
  • Create and use Charts/Pivot Charts

Prerequisites

Prior experience with earlier versions of Excel is welcome, but prior experience with Excel is not presumed.

Training Materials

All attendees receive a short handout in electronic format and will be familiarized in class with Excel’s online documentation.

Software Requirements

Microsoft 365 (including Excel), a modern web browser, and Internet access.

Read Less

Course Details

Course Details

Outline

  • Introduction to Excel 365
  • Setting up Excel 365 for Efficiency
    • Setting up the QAT
    • Setting up the Ribbon
  • Creating a Workbook using Automation
    • Using AutoFill
    • Using AutoFit
    • Using AutoSum (and other formulas)
    • Using AutoFormat (and other formats)
    • Using Conditional Formatting
  • Excel 365 Tips and Tricks
  • Creating and Using Tables
  • Creating and Using Pivot Tables
  • Creating and Using Charts/Pivot Charts
  • New Features that Cannot be Missed!
    • Quick Analysis
    • Flash Fill Conclusion
  • Conclusion

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I liked the pace of the course. I like that I have more than instance to use the lab.

Good Course. We covered a lot of material in a short amount of time. This course had useful labs that built upon each other.

Very good couse and again we would like to see more videos on removing FRUs

The tool provided to practice the course teachings is very functional and easy to use.

The class and material is good. I think some of the software needs to be updated.