Excel - Start using Excel Video
In this video, you will learn how to start using Excel.
The video covers the basics of opening Excel, creating a blank workbook, navigating the worksheet, entering data, formatting cells, adding a header row, converting data to a table, and exploring the ribbon and contextual tabs.
This tutorial will help you get started with Excel and create a simple worksheet to track expenses or other data.
- 4:22
- 4227 views
-
Excel - Insert columns and rows
- 4:16
- Viewed 4041 times
-
Excel - Print worksheets and workbooks
- 1:07
- Viewed 3807 times
-
Excel - Print a worksheet on a specific number of pages
- 4:34
- Viewed 3993 times
-
Excel - More print options
- 5:59
- Viewed 3912 times
-
Excel - Save and print an Excel workbook
- 1:53
- Viewed 3732 times
-
Excel - Advanced formulas and references
- 4:06
- Viewed 4044 times
-
Excel - Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3946 times
-
Excel - Add formulas and references
- 2:52
- Viewed 3639 times
-
Ink Equation
- 0:41
- Viewed 5239 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5104 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5003 times
-
3D Maps
- 1:41
- Viewed 4785 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4660 times
-
Create a combo chart
- 1:47
- Viewed 4473 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4463 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4461 times
-
More complex formulas
- 4:17
- Viewed 4416 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4357 times
-
Manage conditional formatting
- 4:30
- Viewed 4333 times
-
Functions and formulas
- 3:24
- Viewed 4292 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4290 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4242 times
-
Manage drop-down lists
- 6:12
- Viewed 4228 times
-
New Chart types
- 1:52
- Viewed 4204 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4192 times
-
The SUMIF function
- 5:27
- Viewed 4184 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4162 times
-
A closer look at the ribbon
- 3:55
- Viewed 4146 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4128 times
-
AVERAGEIF function
- 3:04
- Viewed 4112 times
-
The SUM function
- 4:37
- Viewed 4111 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4089 times
-
Using functions
- 5:12
- Viewed 4082 times
-
Advanced formulas and references
- 4:06
- Viewed 4044 times
-
Insert columns and rows
- 4:16
- Viewed 4041 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4033 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4030 times
-
A first look at Excel 2016
- 3:22
- Viewed 4019 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4010 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4003 times
-
Add numbers
- 2:54
- Viewed 4000 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3998 times
-
Customize charts
- 4:28
- Viewed 3995 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3993 times
-
Work with macros
- 4:40
- Viewed 3992 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3989 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3970 times
-
Subtract time
- 3:58
- Viewed 3954 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3952 times
-
Advanced filter details
- 4:13
- Viewed 3951 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3946 times
-
Freeze panes in detail
- 3:30
- Viewed 3944 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3944 times
-
AutoFill
- 2:55
- Viewed 3929 times
-
How things are organized
- 1:58
- Viewed 3917 times
-
AutoFilter details
- 3:27
- Viewed 3912 times
-
More print options
- 5:59
- Viewed 3912 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3907 times
-
Input and error messages
- 2:52
- Viewed 3879 times
-
Introduction to Excel
- 0:59
- Viewed 3879 times
-
IF with AND and OR
- 3:35
- Viewed 3874 times
-
Conditionally format dates
- 2:38
- Viewed 3868 times
-
Copying formulas
- 3:00
- Viewed 3858 times
-
Assign a button to a macro
- 2:49
- Viewed 3853 times
-
Sort details
- 4:46
- Viewed 3844 times
-
Insert headers and footers
- 2:02
- Viewed 3843 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3842 times
-
Drop-down list settings
- 4:14
- Viewed 3841 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3839 times
-
Header and footer details
- 3:41
- Viewed 3832 times
-
How to create a table
- 2:11
- Viewed 3831 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3807 times
-
Basic math
- 2:28
- Viewed 3761 times
-
Operator order
- 2:04
- Viewed 3751 times
-
Save your macro
- 2:59
- Viewed 3750 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3732 times
-
Advanced IF functions
- 3:22
- Viewed 3730 times
-
Cell references
- 1:34
- Viewed 3711 times
-
Weighted average
- 2:06
- Viewed 3691 times
-
Use conditional formatting
- 2:02
- Viewed 3691 times
-
Copy a chart
- 2:59
- Viewed 3689 times
-
TEXTJOIN
- 0:47
- Viewed 3682 times
-
Improved version history
- 0:51
- Viewed 3675 times
-
Add formulas and references
- 2:52
- Viewed 3639 times
-
Use slicers to filter data
- 1:25
- Viewed 3604 times
-
IFS
- 1:05
- Viewed 3604 times
-
Save, publish, and share
- 2:22
- Viewed 3598 times
-
Conditionally format text
- 2:12
- Viewed 3596 times
-
Map Chart in Excel
- 0:31
- Viewed 3588 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3580 times
-
One click Forecasting
- 1:01
- Viewed 3565 times
-
Nested IF functions
- 3:30
- Viewed 3559 times
-
Get going fast
- 1:38
- Viewed 3557 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3515 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3487 times
-
CONCAT
- 0:51
- Viewed 3470 times
-
Flash Fill
- 2:59
- Viewed 3464 times
-
Freeze or lock panes
- 1:06
- Viewed 3453 times
-
Average a group of numbers
- 2:01
- Viewed 3430 times
-
Edit a macro
- 3:29
- Viewed 3420 times
-
Drop-down lists
- 0:55
- Viewed 3406 times
-
Create a chart
- 0:52
- Viewed 3392 times
-
Sort and filter data
- 1:38
- Viewed 3386 times
-
SWITCH
- 1:03
- Viewed 3370 times
-
Share documents
- 1:13
- Viewed 3276 times
-
Microsoft Search
- 0:34
- Viewed 3239 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3212 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3173 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3085 times
-
Page numbers in depth
- 3:06
- Viewed 3080 times
-
Funnel Chart
- 0:33
- Viewed 3025 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3008 times
-
Accessibility in Excel
- 1:12
- Viewed 2905 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2715 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2695 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2559 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2549 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2491 times
-
Text before & after Function
- 4:57
- Viewed 2379 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2374 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2257 times
-
Change chart type
- 1:29
- Viewed 2002 times
-
Starting with planner
- 4:28
- Viewed 8722 times
-
Introduction to Power Bi
- 1:29
- Viewed 6991 times
-
The role of an administrator
- 2:22
- Viewed 5328 times
-
General Introduction
- 2:54
- Viewed 4991 times
-
Introduction to PowerApps
- 1:12
- Viewed 4278 times
-
Introduction to Bookings
- 1:19
- Viewed 4222 times
-
Introduction to Power BI Building Blocks
- 3:07
- Viewed 4174 times
-
Introduction to Power BI Desktop
- 2:52
- Viewed 4157 times
-
A closer look at the ribbon
- 3:55
- Viewed 4146 times
-
Tell me what you want to do
- 0:57
- Viewed 4126 times
-
New Interface
- 3:02
- Viewed 4066 times
-
A first look at Excel 2016
- 3:22
- Viewed 4019 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3998 times
-
Introducing PowerAutomate
- 1:53
- Viewed 3966 times
-
How things are organized
- 1:58
- Viewed 3917 times
-
Introduction to Excel
- 0:59
- Viewed 3879 times
-
Introduction to Planner
- 3:00
- Viewed 3835 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3732 times
-
Introduction to PowerPoint
- 0:58
- Viewed 3727 times
-
Introducing Whiteboard
- 1:01
- Viewed 3725 times
-
A first look at PowerPoint 2016
- 4:18
- Viewed 3712 times
-
Introduction to Word
- 0:59
- Viewed 3674 times
-
Introducing Outlook
- 0:50
- Viewed 3669 times
-
Introducing Project
- 1:02
- Viewed 3610 times
-
Introduction to Stream
- 1:17
- Viewed 3598 times
-
Introduction to OneNote
- 1:16
- Viewed 3586 times
-
Get going fast
- 1:38
- Viewed 3557 times
-
Viva Connections in Microsoft Teams
- 0:58
- Viewed 3525 times
-
Save time while searching for documents or informations
- 3:57
- Viewed 3501 times
-
Intro to Microsoft To Do Interface
- 2:41
- Viewed 3496 times
-
An Overview of SHIFTS
- 1:21
- Viewed 3445 times
-
What is Microsoft To Do?
- 0:45
- Viewed 3409 times
-
Introducing Lists
- 0:41
- Viewed 3395 times
-
Introducing Microsoft365
- 0:56
- Viewed 3375 times
-
Getting Started with Outlook Mobile App
- 1:53
- Viewed 3356 times
-
Introducing MyAnalytics
- 1:37
- Viewed 3311 times
-
Access your Office Online App
- 0:43
- Viewed 3244 times
-
Clutter
- 1:31
- Viewed 3214 times
-
Save a PowerPoint presentation
- 1:55
- Viewed 3213 times
-
Start using PowerPoint
- 2:06
- Viewed 3202 times
-
Office Online Apps
- 1:27
- Viewed 3173 times
-
Office 365 overview
- 2:27
- Viewed 3165 times
-
Do things quickly with Tell Me
- 0:49
- Viewed 3164 times
-
Understand the difference between surveys and quizzes in Microsoft Forms
- 1:34
- Viewed 3100 times
-
Intro to Microsoft To Do on Mobile
- 2:06
- Viewed 3016 times
-
Introducing Microsoft Viva Engage
- 1:20
- Viewed 3005 times
-
Interface Introduction of SHIFTS
- 1:48
- Viewed 2992 times
-
A closer look at the ribbon
- 4:20
- Viewed 2972 times
-
How things are organized
- 2:04
- Viewed 2964 times
-
Discovery of the interface
- 2:46
- Viewed 2935 times
-
Discover Excel Online
- 2:34
- Viewed 2922 times
-
What is Microsoft Forms?
- 1:23
- Viewed 2890 times
-
Presentation of the interface of your profile
- 1:41
- Viewed 2880 times
-
Get going fast
- 1:54
- Viewed 2821 times
-
Quick assist
- 1:29
- Viewed 2814 times
-
What is Viva Connections?
- 0:50
- Viewed 2800 times
-
Discover PowerPoint Online
- 2:35
- Viewed 2774 times
-
What is an Open Shift?
- 0:45
- Viewed 2729 times
-
Discover Word Online
- 2:34
- Viewed 2711 times
-
Introduce OneNote
- 2:08
- Viewed 2633 times
-
Tracking Prevention
- 0:59
- Viewed 2595 times
-
Organize your items with tags
- 2:52
- Viewed 2575 times
-
Introduction to the course on Forms
- 1:23
- Viewed 2547 times
-
Interface Discovery
- 2:20
- Viewed 2540 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2491 times
-
What is OneDrive ?
- 01:14
- Viewed 2454 times
-
Introduction to Microsoft Stream (on SharePoint)
- 1:04
- Viewed 2443 times
-
Homepage Navigation
- 0:48
- Viewed 2407 times
-
Functioning of the inbox
- 1:19
- Viewed 2393 times
-
Interface overview
- 1:08
- Viewed 2346 times
-
Navigating within a group
- 1:13
- Viewed 2335 times
-
Using Microsoft Viva Insights In Teams
- 0:59
- Viewed 2332 times
-
Introduction to the Microsoft Forms home page
- 3:14
- Viewed 2261 times
-
Exploring the viva insights interface
- 1:56
- Viewed 2146 times
-
Introducing Sharepoint
- 01:13
- Viewed 2100 times
-
Using relaxation modules
- 1:32
- Viewed 2082 times
-
Find content and people
- 0:59
- Viewed 1669 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 1348 times
-
Introduction to Teams
- 1:25
- Viewed 1305 times
-
Presentation of the desktop application
- 2:16
- Viewed 1241 times
-
Interface Overview
- 1:10
- Viewed 1225 times
-
Task Module Overview
- 01:56
- Viewed 622 times
-
The Bcc Field in Detail
- 01:53
- Viewed 528 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 389 times
-
Explore the Interface
- 03:22
- Viewed 353 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 344 times
-
Manage Views
- 02:36
- Viewed 322 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 312 times
-
Introduction to PowerBI
- 00:60
- Viewed 267 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 253 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 247 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 281 times
-
Introduction to Planner
- 00:56
- Viewed 259 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 325 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 264 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 387 times
-
Introduction to Sway
- 01:53
- Viewed 342 times
-
Introducing to Word
- 01:00
- Viewed 246 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 234 times
-
Create a call group
- 01:15
- Viewed 413 times
-
Use call delegation
- 01:07
- Viewed 200 times
-
Assign a delegate for your calls
- 01:08
- Viewed 380 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 204 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 206 times
-
Manage advanced call notifications
- 01:29
- Viewed 212 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 340 times
-
Block unwanted calls
- 01:24
- Viewed 248 times
-
Disable all call forwarding
- 01:09
- Viewed 230 times
-
Manage a call group in Teams
- 02:01
- Viewed 251 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 202 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 206 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 225 times
-
Manage voicemail messages
- 01:55
- Viewed 342 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 377 times
-
Customize your voicemail greeting
- 02:17
- Viewed 202 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 263 times
-
Manage simultaneous calls
- 01:52
- Viewed 228 times
-
Support third-party apps during calls
- 01:53
- Viewed 282 times
-
Add participants quickly and securely
- 01:37
- Viewed 213 times
-
Configure call privacy and security settings
- 02:51
- Viewed 211 times
-
Manage calls on hold
- 01:20
- Viewed 216 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 220 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 208 times
-
Action Function
- 04:18
- Viewed 209 times
-
Search Function
- 03:42
- Viewed 257 times
-
Date and Time Function
- 02:53
- Viewed 270 times
-
Logical Function
- 03:14
- Viewed 416 times
-
Text Function
- 03:25
- Viewed 268 times
-
Basic Function
- 02:35
- Viewed 226 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 270 times
-
Introduction to Power Fx
- 01:09
- Viewed 267 times
-
The New Calendar
- 03:14
- Viewed 456 times
-
Sections
- 02:34
- Viewed 238 times
-
Customizing Views
- 03:25
- Viewed 232 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 523 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 287 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 201 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 271 times
Objectifs :
This document aims to provide a comprehensive overview of the fundamental features and functionalities of Microsoft Excel, guiding beginners through the initial steps of creating and formatting a worksheet for tracking expenses.
Chapitres :
-
Introduction to Excel
The best way to learn about Excel is to start using it. When you open Excel for the first time, you are presented with options to open an existing workbook or start with a template. For beginners, it is advisable to select 'Blank Workbook' to keep things simple. -
Understanding the Excel Interface
Upon opening a blank workbook, you will see the worksheet area where you can create your content. The tools you need are located in the 'Ribbon' at the top of the screen. Key components include the Name Box and the Formula Bar, which will be explained further as you progress. -
Working with Cells
In Excel, the individual rectangles are called 'cells,' and each cell can hold a piece of information such as text, numbers, or formulas. For example, to create a worksheet for tracking expenses, you can type the first budget item into a cell and press 'Enter.' Each cell is identified by a grid system of rows and columns, such as C6, which refers to column C and row 6. -
Entering and Formatting Data
To continue building your worksheet, type in additional budget items. If the text does not fit within the cell, you can adjust the column width by hovering over the column border and dragging it to widen. Next, you can add rough estimates for each work item in the adjacent column. To format these numbers as dollar amounts, select the numbers, right-click to open the mini toolbar, and click the dollar sign. -
Adding a Header Row
To enhance the clarity of your worksheet, add a header row at the top. This will help anyone reviewing the worksheet understand the data presented. -
Using Quick Analysis Tools
To make data management easier, select the header and data, then use the quick analysis lens that appears when you hover over the selection. Click on 'Tables' and then 'Table' to convert your data into a table format. This allows for easier sorting and filtering of data, as well as additional commands for managing your table. -
Exploring the Ribbon and Contextual Tabs
The Ribbon organizes commands and options into tabs. Most commonly used commands are found on the 'Home' tab, while the 'Insert' tab contains options for adding elements like pictures and charts. Contextual tabs, such as the 'Table Tools Design' tab, appear only when you are working with specific elements like tables. -
Saving Your Workbook
As you work on your worksheet, it is important to save your workbook regularly. This ensures that your progress is not lost and allows you to continue building your project in Excel.
FAQ :
What is the best way to learn Excel?
The best way to learn Excel is to start using it actively. Experimenting with its features and functions will help you understand how to utilize the program effectively.
What is a workbook in Excel?
A workbook in Excel is a file that can contain multiple worksheets. Each worksheet can hold different sets of data and calculations.
How do I format numbers as currency in Excel?
To format numbers as currency in Excel, select the cells containing the numbers, right-click to open the context menu, and choose the dollar sign icon from the mini toolbar.
What are the advantages of using tables in Excel?
Using tables in Excel allows for easier data management, including sorting and filtering options. Tables also provide structured formatting and can automatically expand as new data is added.
What is the purpose of the Ribbon in Excel?
The Ribbon in Excel organizes commands and tools into tabs, making it easier for users to find and use the features they need for their tasks.
How can I save my workbook in Excel?
To save your workbook in Excel, click on the 'File' tab in the Ribbon, then select 'Save' or 'Save As' to choose a location and file name.
Quelques cas d'usages :
Budget Tracking for Projects
Using Excel to create a budget tracking worksheet for an expansion project allows project managers to input expenses, categorize them, and analyze spending patterns. By formatting the data as a table, they can easily sort and filter expenses to make informed financial decisions.
Data Analysis for Sales Reports
Sales teams can utilize Excel to compile sales data into a worksheet, applying formatting and creating tables to analyze performance metrics. This helps in identifying trends and making strategic decisions based on the data.
Inventory Management
Businesses can use Excel to manage inventory by creating a worksheet that tracks stock levels, prices, and suppliers. By using tables, they can quickly filter items that need reordering and analyze inventory turnover rates.
Event Planning
Event planners can create a detailed worksheet in Excel to track tasks, budgets, and timelines for events. By utilizing the Ribbon's formatting tools, they can present the information clearly and share it with team members.
Personal Finance Management
Individuals can use Excel to manage personal finances by creating a budget worksheet that tracks income and expenses. By formatting the data and using tables, they can visualize their financial health and make adjustments as needed.
Glossaire :
Excel
A spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas using a spreadsheet system.
Workbook
A file in Excel that contains one or more worksheets. Each workbook can hold various data and calculations.
Worksheet
A single spreadsheet within a workbook where data is entered and manipulated. It consists of cells organized in rows and columns.
Ribbon
The area at the top of the Excel window that contains tabs and commands for various functions and tools.
Cells
The individual boxes in a worksheet where data is entered. Each cell can contain text, numbers, or formulas.
Name Box
A field in Excel that displays the name of the currently selected cell or range of cells.
Formula Bar
An area in Excel where users can enter or edit data or formulas in the selected cell.
Grid System
The organizational structure of rows and columns in a worksheet that helps identify the location of each cell.
Formatting
The process of changing the appearance of data in cells, such as changing font size, color, or number format.
Table
A structured range of data in Excel that allows for easier data management, including sorting and filtering.
Contextual Tab
A tab in the Ribbon that appears only when a specific object, like a table or chart, is selected, providing relevant commands.