TOIT Training

Intermediate

Mastering Excel 365 – Intermediate (2022)

Overview
Curriculum

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn great tools to modify your data and refine your workbook.  Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options. 

And if you need to know more about forecasting, you’ll learn how to conduct What-If analysis using Excel’s special features. 

Curriculum

  • 37 Sections
  • 3h 33m Duration
Expand All
Introduction
    Flash Fill
      Text to Columns
        Find and Replace
          Sort and Filter
            Proofing and Researching Tools
              Group Mode
                Workbook Properties
                  Freeze and Split Windows
                    Workbook Views
                      Custom Views
                        Custom Number Formats
                          Conditional Formatting for Text and Dates
                            Comparative Analysis with Conditional Formatting
                              Customizing Conditional Formatting
                                Functions in Conditional Formatting
                                  Nested Functions
                                    Logical Functions
                                      Statistical Functions
                                        Chart Elements
                                          Chart Formats
                                            Sparklines
                                              Graphics
                                                SmartArt
                                                  Creating Tables
                                                    Table Styles
                                                      Summarizing Data in Tables
                                                        Managing PivotTables
                                                          Web Queries
                                                            Hyperlinks
                                                              Compare and Merge
                                                                Track Changes
                                                                  Share a Workbook
                                                                    Comments
                                                                      Goal Seek
                                                                        Forecasting with Data Tables
                                                                          Analyze Data Tool

                                                                            Deleting Course Review

                                                                            Are you sure? You can't restore this back

                                                                            Course Access

                                                                            This course is password protected. To access it please enter your password below:

                                                                            Buy for group

                                                                            Mastering Excel 365 – Intermediate (2022)
                                                                            No groups Found

                                                                            You don't have any groups yet

                                                                            Create a group and add group members. Sync Group(s)