Description
Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. These can range from simple formulas through to complex functions and mathematical models.
After reading this eBook you will be able to understand the differences between Excel 2010 formulas and functions. Further you will learn how to use simple functions and formulas, like addition, subtraction and multiplications.
Contents
Content
1.
INTRODUCTION
1.
How To Use This Guide
2.
Objectives
3.
Instructions
4.
Appendices
2.
SECTION 1 THE BASICS
1.
WINDOWS CONCEPTS
2.
Menus
3.
Ribbons
4.
Dialog Box
5.
File Ribbon
6.
Toolbars
7.
Mini Toolbar
8.
Name Box
9.
Formula Bar
10.
Worksheets
11.
Status Bar
12.
Task Pane
13.
Smart Tags
14.
GETTING HELP
15.
MICROSOFT EXCEL HELP
3.
SECTION 2 MOVE AROUND AND ENTER DATA
1.
MOVING
2.
Moving Around Workbook
3.
Scrolling
4.
USEFUL KEYS FOR MOVING
5.
WORKBOOK SHEETS
6.
Moving Around Sheet
7.
DATA ENTRY
8.
Enter Text And Numbers
9.
Cancelling And Editing Data Entries
10.
Enter Dates
11.
Autocomplete
12.
Pick From List
13.
EDITING
14.
Typing Replaces Selection
15.
Use The Mouse To Edit
16.
Using The Keyboard
17.
Select Information
18.
Select Multiple Sheets
19.
Select Non-Adjacent Sheets
20.
Clear Contents, Formats And Comments
21.
The Fill Handle
22.
USEFUL INFORMATION
23.
Scrolling
24.
Data Entry
25.
Select Cells To Limit Data Entry
26.
Select Cells For Multiple Entry
4.
SECTION 3 EXCEL 2010 FORMULAS AND FUNCTIONS
1.
FORMULAE
2.
Typing Formulae
3.
Entering Formulae By Pointing
4.
Errors In Formulae
5.
Filling Formulae
6.
The Fill Handle And Formulae
7.
Fill Formulae Using Keystrokes
8.
BoDMAS With Formulae
9.
EXCEL 2010 FUNCTIONS
10.
Basic Sum Function
11.
Autosum
12.
Other Common Functions
13.
Function Library
14.
Insert Function
15.
Function Box
16.
Type Functions
17.
Function Argument Tool Tips
18.
Cell References
19.
ABSOLUTE AND RELATIVE REFERENCES
20.
Relative References
21.
Absolute References
22.
Fill Handle
23.
Absolute References
5.
SECTION 4 FILE OPERATIONS
1.
Save Files
2.
File Types And File Names
3.
Saving Changes To Files
4.
Saving As A Different Type Or Different Name
5.
Close Files
6.
Open Files
7.
New Files
6.
SECTION 5 MOVING AND COPYING DATA
1.
Moving Items
2.
Copying Items
3.
Clipboard
4.
Drag And Drop
5.
Shortcut Menus
6.
Moving And Copying Between Files
7.
Insert Paste
8.
Moving And Copying Between Worksheets
9.
Paste Special
7.
SECTION 6 EXCEL 2010 FORMATTING
1.
QUICK FORMATS
2.
Formatting Groups On Home Ribbon
3.
Font
4.
Point Size
5.
Bold, Italic And Underline
6.
Font Colour
7.
Background Fill Colour
8.
Borders
9.
Alignment
10.
Merge Cells
11.
Indents
12.
Number Formats
13.
ADVANCED FORMATS
14.
Format Cells Dialog
15.
Custom Number Formats
16.
FORMATTING COLUMNS AND ROWS
17.
Column Width
18.
Row Height
19.
Hide Columns, Rows And Sheets
20.
INSERT AND DELETE CELLS, ROWS, COLUMNS OR SHEETS
21.
Add Cells
22.
Delete Cells
23.
Format Painter
24.
Shortcut Keys For Formatting
8.
SECTION 7 NAMES
1.
NAMING CELLS AND RANGES
2.
Rules When Naming Cells
3.
Selecting Names (Navigation)
4.
Manage Names By Using The Name Manager.
5.
Names In Functions
6.
Paste List Of Names
7.
Intersecting Names
8.
Applying Names
9.
Filtering out needed named ranges
9.
SECTION 8 WORKING WITH SHEETS
1.
MULTIPLE WORKSHEETS
2.
Moving Between The Workbook Sheets
3.
Worksheet Names
4.
Move And Copy Worksheets
5.
Insert And Delete Worksheets
6.
ACTIVATE GROUP MODE
7.
Group Adjacent Sheets
8.
Group Non-Adjacent Sheets
9.
Deactivate Group Mode
10.
FILL DATA ACROSS WORKSHEETS
11.
3-D Formulae
12.
References to other sheets
13.
PROTECT WORKSHEET DATA
14.
Unlock Cells
15.
Worksheet Protection
16.
Unprotect Sheets
17.
View Worksheets Side By Side
18.
Hide Windows
19.
Watch Window
20.
Change Colour Of Worksheet Tab
10.
SECTION 9 PRINTING
1.
PRINT PREVIEW
2.
PAGE SETUP
3.
page setup group on the page layout ribbon
4.
PAGE TAB
5.
Print preview options
6.
MARGINS TAB
7.
To change header and footer position
8.
HEADER/FOOTER TAB
9.
Header
10.
Footer
11.
New Methods For Headers And Footers In 2010
12.
Insert Specific Elements In A Header Or Footer
13.
Add A Predefined Header Or Footer
14.
Choose The Header And Footer Options
15.
Custom Header Or Footer For A Chart
16.
SHEET TAB
17.
Print Area
18.
Print Titles
19.
Print
20.
To change Sheet tab Print settings:
21.
Page Breaks
22.
PRINT DATA
23.
Copies
11.
SECTION 10 MANIPULATING LARGE WORKSHEETS
1.
USEFUL TOOLS FOR LARGE SHEETS
2.
Split Screen
3.
Freeze Panes
4.
Zoom
5.
NAVIGATION
6.
Go To
7.
Navigating with name box
12.
SECTION 11 SORTING & SUBTOTALLING DATA
1.
LISTS
2.
Do
3.
Do Not
4.
SORTING LIST DATA
5.
Quick Sort
6.
Multi Level Sort
7.
SUBTOTALS
8.
Organising The List For Subtotals
9.
Example
10.
Summarising A Subtotalled List
11.
Show And Hide By Level
12.
Remove Subtotals
13.
SECTION 12 CUSTOMISING EXCEL
1.
SET EXCEL OPTIONS
2.
General
3.
Formulas Sheet
4.
Proofing
5.
Save
6.
Language
7.
Advanced Options
8.
Customise Excel Ribbons
9.
Customise Quick Access Toolbar
