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
- 4148 views
-
Excel - Do things quickly with Tell Me
- 1:07
- Viewed 4024 times
-
Excel - New Chart types
- 1:52
- Viewed 5656 times
-
Excel - One click Forecasting
- 1:01
- Viewed 5228 times
-
Excel - 3D Maps
- 1:41
- Viewed 9729 times
-
Excel - Ink Equation
- 0:41
- Viewed 8377 times
-
Excel - Share documents
- 1:13
- Viewed 4400 times
-
Excel - Improved version history
- 0:51
- Viewed 5032 times
-
Excel - The SUMIF function
- 5:27
- Viewed 5071 times
-
Remove a watermark
- 2:20
- Viewed 67826 times
-
Change the default font for your emails
- 1:09
- Viewed 62875 times
-
Collapsible headings
- 3:03
- Viewed 36732 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30675 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29817 times
-
Add headers and footers to slides
- 3:52
- Viewed 24931 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24710 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 21033 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20374 times
-
Add sound effects to an animation
- 4:29
- Viewed 19260 times
-
Remove a watermark
- 2:20
- Viewed 67826 times
-
Change the default font for your emails
- 1:09
- Viewed 62875 times
-
Collapsible headings
- 3:03
- Viewed 36732 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30675 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29817 times
-
Add headers and footers to slides
- 3:52
- Viewed 24931 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24710 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 21033 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20374 times
-
Add sound effects to an animation
- 4:29
- Viewed 19260 times
-
Preparing for the EU AI Act: Timeline and Obligations
- 01:54
- Viewed 126 times
-
Using AI in the Workplace: 3 Tips to Minimize Risks
- 03:10
- Viewed 126 times
-
Shadow AI: Identifying Uncontrolled AI Use
- 02:21
- Viewed 122 times
-
EU AI Act Risk Levels: From Minimal to Unacceptable
- 02:37
- Viewed 165 times
-
Understanding the EU AI Act: A Regulation Governing the Use of AI
- 02:24
- Viewed 133 times
-
Analyze the performance of a newsletter or an edition in Outlook
- 01:30
- Viewed 171 times
-
Collaborate on writing an edition in Outlook
- 01:35
- Viewed 148 times
-
Enhance an edition and create a template in a newsletter
- 06:14
- Viewed 143 times
-
Collaborate on a Clipchamp Project
- 01:21
- Viewed 456 times
-
Create a Video with AI in Clipchamp
- 03:26
- Viewed 401 times
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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise