Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel for Office 365: Intermediate

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

Description

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

Course Outline

Lesson 1: Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date and Time Functions
  • Work with Text Functions
Lesson 2: Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
Lesson 3: Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Prerequisites

Prior Course Recommendation: Microsoft Excel for 365/2019: Part 1

Similar courses

Introduction to DAX for Power BI

Using Data Analysis Expressions to solve common business problems in Power BI

More Information
Microsoft Excel for Office 365: Advanced

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information
Microsoft Excel for Office 365: Beginner

Provides a foundation for Excel knowledge and skills

More Information
Microsoft Outlook for Office 365/2019: Advanced

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information
Microsoft Access 2019/2021: Intermediate

Expand basic database management skills

More Information
Microsoft Word for Office 365: Intermediate

Tackle more advanced features of Word

More Information
Microsoft Power BI: Data Analysis Practitioner

Analyze business data, visualize insights, and share those insights across the enterprise

More Information
Microsoft Project 2019/2021: Advanced

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information
Microsoft Project 2019/2021: Beginner

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information
Microsoft Excel for Office 365/2021: Data Analysis with Power Pivot

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information
Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information
Microsoft PowerPoint for Office 365: Advanced

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

More Information
Microsoft PowerPoint for Office 365: Beginner

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.

More Information
Microsoft SharePoint for Site Owners (Modern)

SharePoint provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location

More Information
Tableau Part 2

In this course, you will perform advanced data visualization and data blending with Tableau.

More Information
Microsoft Word for Office 365: Advanced

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information
Microsoft Word for Office 365: Beginner

You will learn fundamental Word skills

More Information
Microsoft Outlook for Office 365/2019: Beginner

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information
Microsoft Access 2019/2021: Beginner

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

More Information
Adobe Acrobat Pro: New Experience

This course is for individuals who are new to Adobe Acrobat Pro DC, but need to create and share PDF files and PDF portfolios.

More Information
PL-400T00: Microsoft Power Platform Developer

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information
Formatting Technical Documents

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

More Information
Microsoft® Teams® for Business Users

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

More Information
Microsoft® SharePoint® Modern Experience: Site Basics

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

More Information
Getting the Most from Your Spreadsheets with GenAI

In this course, you will use generative AI to assist you as you work with spreadsheets.

More Information
Programming and Data Wrangling with VBA and Excel

In this course, you will develop and deploy VBA modules to solve business problems.

More Information
Adobe Forms

This course provides comprehensive training on creating and modifying forms using Adobe Acrobat. Participants will learn to design, customize, and optimize interactive forms, both automatically and manually. The course covers essential techniques such as adding various form fields, working with actions, adjusting tab order, and implementing calculations.

More Information
Microsoft Office 365 Online (with Teams for the Desktop)

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps including Yammer™, Planner, and Delve® that can be used in combination by teams for communication and collaboration.

More Information
PL-300T00: Microsoft Power BI Data Analyst

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

More Information
Getting the Most from Your Presentations with GenAI

In this course, you will use generative AI tools to help you develop business presentations.

More Information
Adobe Illustrator CC

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text, draw complex illustrations, enhance artwork by using painting tools, customize colors and swatches, format type, enhance the appearance of artwork, prepare content for deployment, set up project requirements and prepare graphics for the web.

More Information
Adobe InDesign CC

In this course, you will use Adobe® InDesign® to create and deliver professional looking printed and interactive documents. You will also learn advanced InDesign techniques to enhance the look and functionality of your documents.

More Information
Adobe Photoshop CC

This two-day course will prepare you to use the most common basic and advanced features of Adobe Photoshop.

More Information
Getting the Most from Your Documents with GenAI

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

More Information

Press enter to see more results