Excel - Get going fast Tutorial

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.

1:38
3738 views

Available in Microsoft365

Objectifs :

This video aims to provide an overview of the new features and changes in Excel, particularly focusing on the user interface, file formats, and functionalities that enhance productivity and ease of use.

Chapitres :

Introduction to Excel Changes
When you first open Excel, you will notice several changes that enhance your user experience. This video will guide you through these updates, helping you to navigate the new interface effectively.
The Ribbon Interface
One of the most significant changes is the introduction of the Ribbon, which replaces the traditional menu bar. The Ribbon organizes all your favorite commands in a more accessible way. For instance, formatting buttons are conveniently located here, allowing for quick adjustments to your spreadsheet.
Review Tab and Spelling Check
To check spelling in your document, you can easily navigate to the Review tab. This tab houses various tools that assist in ensuring your content is error-free.
Analysis and Design Tools
Excel now offers new ways to utilize analysis and design tools. For example, charts are readily available on the page, making it easier to visualize your data. This feature enhances your ability to present information clearly and effectively.
New File Format
The file format has also changed. When you save a new workbook, it will be saved as an .xlsx file instead of the older .xls format. However, you can still open and save .xls files, ensuring compatibility with users who may be working with Excel 2003.
Backstage View
Clicking on 'File' and then 'Manage Workbook' will take you to the Backstage view. This area is crucial for managing your files, as it is where you can save, open, share, and export your workbooks. The Backstage view streamlines these processes, making file management more intuitive.
Conclusion
In summary, this video has provided a quick overview of the significant changes in Excel. Understanding these updates will help you navigate the software more efficiently and take full advantage of its new features.

FAQ :

What is the Ribbon in Excel?

The Ribbon is a user interface element in Excel that organizes commands and tools into tabs, replacing the traditional menu bar for easier access to features.

How do I check spelling in Excel?

To check spelling in Excel, go to the Review tab in the Ribbon and click on the 'Spelling' button to initiate the spell check process.

What is the difference between .xlsx and .xls file formats?

.xlsx is the newer file format used by Excel that supports more features and larger data sets, while .xls is the older format used in Excel 2003 and earlier versions.

How can I access the Backstage view in Excel?

You can access the Backstage view by clicking on the 'File' tab in the Ribbon, which provides options for managing files, including saving, opening, and sharing workbooks.

Can I open .xls files in newer versions of Excel?

Yes, newer versions of Excel can open and save .xls files, allowing compatibility with users who still use Excel 2003 or earlier.

Quelques cas d'usages :

Creating a Financial Report

Use Excel's Ribbon to access formatting buttons and charts to create a visually appealing financial report. The new .xlsx format allows for larger datasets and advanced features, improving the report's effectiveness.

Collaborating on a Project

Utilize the Backstage view to share and export workbooks with team members. The ability to open .xls files ensures that collaboration is seamless, even with users on older versions of Excel.

Data Analysis with Charts

Leverage the chart tools in the Ribbon to analyze data visually. This can enhance presentations and reports, making complex data easier to understand for stakeholders.

Reviewing Documents

Use the Review tab to check spelling and add comments to documents. This is particularly useful in collaborative environments where multiple users contribute to a single workbook.

Glossaire :

Ribbon

A user interface element in Microsoft Excel that replaces the traditional menu bar, providing quick access to various commands and tools organized into tabs.

Formatting buttons

Tools located in the Ribbon that allow users to change the appearance of cells, text, and other elements in an Excel worksheet.

Review tab

A section in the Ribbon that contains tools for reviewing and editing content, including spell check and comments.

Charts

Visual representations of data in Excel that help users analyze and present information effectively.

File format

The structure in which data is stored in a file. In Excel, the new format is .xlsx, which allows for more features compared to the older .xls format.

Backstage view

A feature in Excel that provides access to file management options such as saving, opening, sharing, and exporting workbooks.

Excel 2003

An earlier version of Microsoft Excel, which used the .xls file format and had a different user interface compared to newer versions.

00:00:07

First, there is a ribbon where the menu bar used to be,

00:00:11

all of your favorite commands are still there but now they're easier to get to.

00:00:15

For example, here's where your formatting buttons are

00:00:18

and here's where you insert things like tables and pictures,

00:00:24

here to check spelling,

00:00:25

go to the Review tab.

00:00:30

Look at this,

00:00:32

styles, pictures, diagrams,

00:00:39

tables,

00:00:42

new ways to use analysis and design tools

00:00:47

like charts,

00:00:49

the commands and options to work with the chart are right there on the page.

00:00:55

The file format is new, now when you save a new workbook,

00:00:59

you'll create an xlsx file not an xls file

00:01:03

but don't worry you can open and save xls files

00:01:06

just in case you need an open workbook from someone working in Excel 2003.

00:01:12

Look what happens now when you click File,

00:01:16

this is the backstage where you go to manage workbook in Excel options.

00:01:22

The backstage is also where you go to save and open files

00:01:26

and also where you go to share and export your workbooks.

00:01:32

So we've just shown you a quick overview of what's changed.

00:01:35

Now let's go into more detail.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2796 Views

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introduct...

ALL COURSES