Here we will learn about some basics of Excel.
1.
Ribbon: When we open
a new file in Excel the selected tab at ribbon will be Home tab. Here we will
learn how to use the ribbon.
2.
Workbook: Microsoft
Excel’s files are called Workbook that will be saved with your own required
file name.
3.
Worksheets: A worksheet
is a collection of cells where we can keep and manipulate our data. Initially each
Excel workbook contains four (04) worksheets. The worksheets can be added or
deleted.
4.
Format Cells: When we
format cells in Excel, we change the appearance of a number without changing
the number itself.
5.
Find & Select: Through Find
& Select feature we can easily Find, Replace and Go To any required Number
and data.
6.
Templates: we can
create a workbook with the help of templates instead of creating a new Excel
workbook from scratch; many free templates are available for use.
7.
Data Validation: Data
validation is used to enter a specific value or data type into a cell.
8.
Keyboard Shortcuts: Keyboard
shortcuts are used to increase our speed.
9.
Print: Here we will
learn how to take a print of a worksheet and how to change print settings.
10.
Share: In this
chapter we will learn how to share and export Excel data with Word documents.
11.
Protect: In this
chapter we will learn how to protect or encrypt an Excel file with a password.
Basics
To become an expert in Microsoft
Excel you can find related examples and features on the right side of each chapter.
For an overview you can read the following.
1.
Ribbon: Quick Access Toolbar | Customize the Ribbon | Developer Tab | Status Bar | Checkbox
2.
Workbook: Themes | View Multiple Workbooks | AutoRecover | Save in 97-2003 Format
3.
Worksheets: Zoom | Split | Freeze Panes | Group Worksheets | Consolidate | View Multiple Worksheets | Get Sheet Name | Spell Check
4.
Format Cells: Decimal Places | Fractions | Currency vs Accounting | Text to Numbers | Numbers to Text | Custom Number Format | Format Painter | Cell Styles | Wrap Text | Merge Cells | Strikethrough | Superscript and Subscript | Check Mark
5.
Find & Select: Find Features | Delete Blank Rows | Row Differences | Copy Visible Cells Only | Search Box
6.
Templates: Budget | Calendar | Holidays | Meal Planner | Invoice | Automated Invoice | Default Templates | Time Sheet | BMI calculator
7.
Data Validation: Reject Invalid Dates | Budget Limit | Prevent Duplicate Entries | Product Codes | Drop-down List | Dependent Drop-down Lists | Cm to inches | Kg to lbs
8.
Keyboard Shortcuts: Function Keys | Insert Row | Save As | Delete Row | Formula to Value | Scroll Lock | Bullet Points | Line Break | Show Formulas
9.
Print: Workbook Views | Page Breaks | Headers and Footers | Page Numbers | Print Titles | Center on Page | Print Gridlines & Headings | Print Area
10.
Share: Embed | PDF | Share Workbooks | OneDrive | Online | Import Access Data | Microsoft Query | Import/Export Text Files | XML
11.
Protect: Protect Workbook | Protect Sheet | Lock Cells | Read-only Workbook | Mark as Final
Check out all 300 examples.
No comments:
Post a Comment