Platform Banner

Excel - A first look at Excel 2016 Tutorial

In this video, you will learn about the new features and enhancements in Office 2016. The video covers the changes in Outlook, such as the ability to attach files from different locations and change permissions.
It also explores new charts and maps in Excel, including the ability to create tables based on geographical data.
Additionally, the video showcases the collaboration features in all Office applications, allowing users to share and edit documents simultaneously.
The video concludes by highlighting the "Tell me what you want to do" feature and the smart lookup function available in Office 2016. This tutorial will help you make the most of Office 2016 and improve your productivity.

3:22
4307 views

Available in Microsoft365

Description

Objectifs :

This video aims to introduce users to the Excel interface, highlighting the differences between Excel 2003 and newer versions, and demonstrating how to navigate the ribbon, utilize common commands, and convert files to the new xlsx format for enhanced functionality.

Chapitres :

Introduction to Excel Interface
When you open Excel for the first time, you are greeted with a unique interface that differs from the traditional blank worksheet. This video will guide you through the initial setup and options available.
Opening an Excel 2003 Workbook
Upon opening an Excel 2003 workbook, you will notice that it looks and functions similarly to the newer versions. The basic tools and features remain intact, allowing you to type and format text and numbers in a familiar manner, albeit with a different organization.
Navigating the Ribbon
In the newer versions of Excel, instead of selecting a menu item and clicking a command, you now select a tab on the ribbon. The Home tab is selected by default when you first open Excel, providing quick access to the most common commands for data management.
Changing Formatting
To change the formatting of your data, such as the background color and font color of the header row, simply select the desired cells. You can hover over different styles to see a preview before making your selection, enhancing your formatting experience.
Saving Your Workbook
When it comes time to save your workbook, you can either use the save command located in the toolbar or the familiar keyboard shortcut Ctrl + S. If you are saving a file created in Excel 2003, a compatibility checker may appear, indicating potential formatting issues.
Understanding Compatibility Mode
If you choose to save in the older xls format, you will enter compatibility mode, which may limit access to some new features. You can opt to clear the compatibility message, but be aware that you will miss out on certain functionalities.
Converting to xlsx Format
To take full advantage of the new features, it is recommended to convert your file to the xlsx format. To do this, click the File tab to access the backstage view, select Info, and then click Convert. Confirm the conversion and reopen the workbook to utilize the new features.
Exploring Chart Styles
After converting to the xlsx format, you can select a chart and explore a wide range of chart styles. As before, you can preview different styles before making a selection, allowing for a more customized presentation of your data.
Conclusion
In this video, we have covered the essential aspects of navigating the Excel interface, understanding compatibility mode, and converting files to the new format. Stay tuned for more detailed discussions on compatibility mode in the upcoming videos.

FAQ :

What is the difference between XLS and XLSX file formats?

XLS is the older file format used by Excel 2003 and earlier, while XLSX is the newer format introduced in Excel 2007 that supports more features and better data management.

How do I save my Excel workbook?

You can save your Excel workbook by clicking the save command in the toolbar or by using the keyboard shortcut Ctrl + S.

What is the purpose of the Compatibility Checker in Excel?

The Compatibility Checker alerts users about potential issues when saving files in older formats, ensuring that certain features and formatting may not be supported in those versions.

How can I convert my Excel file to the new XLSX format?

To convert your Excel file to the XLSX format, click the File tab, select Info, then click Convert, and follow the prompts to complete the conversion.

What are Chart Styles in Excel?

Chart Styles are predefined formats that allow users to quickly change the appearance of their charts, making it easier to visualize data.

Quelques cas d'usages :

Data Analysis in Business

Excel can be used by business analysts to organize and analyze large datasets, utilizing features like pivot tables and charts to derive insights and make data-driven decisions.

Financial Reporting

Accountants can use Excel to create financial reports, track expenses, and manage budgets, taking advantage of formulas and functions to automate calculations.

Project Management

Project managers can utilize Excel to create Gantt charts and track project timelines, ensuring that tasks are completed on schedule and resources are allocated efficiently.

Inventory Management

Retailers can manage inventory levels using Excel, tracking stock quantities and sales data to optimize supply chain operations and reduce costs.

Educational Purposes

Teachers can use Excel to track student grades and attendance, creating spreadsheets that help in analyzing student performance over time.

Glossaire :

Excel

A spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns.

Workbook

A file created by Excel that contains one or more worksheets, which can hold data, charts, and other information.

Ribbon

A user interface element in Excel that organizes commands and tools into tabs, making it easier to find and use features.

Home Tab

The default tab selected when opening Excel, containing the most commonly used commands for formatting and editing data.

Compatibility Checker

A tool in Excel that alerts users about potential issues when saving files in older formats, ensuring that features and formatting may not be supported.

XLS

The file format used by Excel 2003 and earlier versions, which may not support newer features available in later versions.

XLSX

The file format introduced in Excel 2007 that supports more features and is the default format for newer versions of Excel.

Chart Styles

Predefined formats for charts in Excel that allow users to quickly change the appearance of their data visualizations.

Backstage View

A feature in Excel that provides access to file management tasks, such as saving, opening, and converting files.

Mandarine AI: WHAT YOU SHOULD KNOW