Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Introduction
Chapter 1: History of Excel
Chapter 2: Getting Started with Excel
What is Еxcеl?
What is Еxcеl used For?
Excel File Types
What is a Workbook?
What is a Worksheet?
How to Open an Existing Workbook
The Excel User Interface
How to Save a Workbook
Chapter 3: The Excel Ribbon
Ribbon Tabs Explained
Minimising the Ribbon
Maximising the Ribbon
Dynamic Ribbon Size
Quick Access Toolbar
Chapter 4: Formatting your Worksheet
Changing Font Styles
Changing Alignment
Changing Orientation
Wrap and Merge Text
Formatting Numbers
Cell Styles
How to Apply Borders to a Worksheet
Using the Format Painter
Chapter 5: Managing your Worksheets
How to Name a Worksheet
How to Insert a Worksheet
How to Delete a Worksheet
How to Move Tabs
How to Format Tabs
How to Insert Columns and Rows
How to Delete Columns and Rows
How to Hide/Unhide Columns and Rows
How to Freeze Columns and Rows
How to Adjust Columns and Rows
Chapter 6: Editing Worksheets
Copy, Paste and Cut
Editing Cell Contents
Find and Replace
Excel Spell checker
Text to Speech
Undo and Redo
Chapter 7: Creating Charts
Types of Charts
How to Create a Chart
Formatting Charts
How to Switch Rows and Columns in Charts
How to Change Chart Type
Chapter 8: Sorting and Filtering
How to Sort
Basic Filtering
Advanced Filtering
Clearing Filters
Chapter 9: Creating Excel Formulas
Mathematical Operators
Creating a Simple Formula
Copying a Formula Down
Editing a Formula
Insert Function Dialog Box
Excel Formulas and Functions
Chapter 10: Printing in Excel
How to Print
Print Settings
Page Views
Additional Resources
More Books by Excel Master Consultant
← Prev
Back
Next →
← Prev
Back
Next →