[go: up one dir, main page]
Scribd
Upload
90 views7 pages

Excel Basics for Beginners Guide

The document outlines an Excel basics module containing 5 lessons that teach beginners about the Excel interface, entering and formatting data, working with cells and ranges, managing worksheets, and more with links to video lessons for each topic.

Uploaded by

PRIYA AGARWAL
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
90 views7 pages

Excel Basics for Beginners Guide

The document outlines an Excel basics module containing 5 lessons that teach beginners about the Excel interface, entering and formatting data, working with cells and ranges, managing worksheets, and more with links to video lessons for each topic.

Uploaded by

PRIYA AGARWAL
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

EXCEL MODULE 1

EXCEL BASICS (for Beginners)


Lesson 1 – Getting Started with Excel

https://youtu.be/UPABcYhugZk

(Click on the above video link to watch the video)

In this video, you’ll learn about the following topics:

• Structure of the Excel working area,


• How to navigate in Excel,
• Ribbons and tabs,
• Quick Access Toolbar (QAT)
• Dialog Box & Task Panes,
• Customizing ribbons and QAT,
• What is an active cell
• How to use ALT shortcuts.
Lesson 2 – Data Entry, Data Editing and Number Formatting

• https://youtu.be/4AXAXUYZnkc

• (Click on the above video link to watch the video)

• This video will show you how to enter data in Excel


and edit already added data (such as deleting data,
modifying existing data and replacing data).

• Apart from this, it also covers the auto-fill in Excel


as well as number formatting.
Lesson 3 – Data Formatting

• https://youtu.be/1LgkR1R1ACU

• (Click on the above video link to watch the video)

Here are some of the common formatting used to make


data look better and more readable

• Applying borders to all cells


• Making headers bold
• Giving a background cell color to headers.
• Center align the headers
Lesson 4 – Working with cells and ranges in Excel

• https://youtu.be/B16UleW3uUM

• (Click on the above video link to watch the video)

• It covers the following topics:

• Cell address nomenclature


• Selecting cell/ranges in Excel
• Copying and moving cells/ranges in Excel
• Using paste special
• Selecting special cells
• Using find and replace to select cells
• Adding comments and
• Using quick analysis
Lesson 5 – Managing Worksheets
• https://youtu.be/u1GZVWU7g6Q

(Click on the above video link to watch the video)

It covers the following topics:

• Navigating through worksheets in Excel


• Changing worksheet name and color
• Adding/deleting worksheets
• Hiding/Un-hiding worksheets
• Moving/copying worksheets
• Comparing worksheets side by side
• Splitting worksheet into panes
• Freeze panes
• Saving and opening workbooks

You might also like