Check nearby libraries
Buy this book
This book is very useful for managing soft paper work, especially calculations.
You can download the book for free via the link below.
Publish Date
2013
Publisher
Bookboon.com
Check nearby libraries
Buy this book
Showing 1 featured edition. View all 1 editions?
Edition | Availability |
---|---|
1 |
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Sisältö
First things first
Starting Excel
The Excel Window
The Ribbon
Customizing the Quick Access toolbar
Customizing the Ribbon
Assigning shortcut keys using The Alt Key
Adding values to workbook properties
Saving
Saving a Workbook for the First Time
Saving your Workbook Once it has a Name
Save as different file formats
Saving Files to remote locations
Maintaining backward compatibility
Backstage View
The Backstage View
Excel Options
Share via Backstage View
Share Via Email
Invite People to Share
Open a Shared Workbook
Create Worksheets and Workbooks
Creating new blank workbooks
Creating New Workbooks Using Templates
Changing worksheet order
Move or copy to a different workbook
Set how many worksheets you start with
Importing a .CSV file
Adding data
Adding Text
Adding Numbers
Moving around a Spreadsheet
Cursor Shapes (Mouse Shapes)
Selecting Data in a Worksheet
Navigating your Workbook
Searching for data within a workbook
Inserting hyperlinks
Using Go To
Using the Name Box to Navigate
Workbook Views
Introduction to Views
Normal View
Page Layout View
Page Break Preview
Page Breaks
Creating Custom Views
Working with Data
Cut, Copy and Paste
Copying by Dragging
Moving by Dragging
Using Paste Special
Formatting Cells and Worksheets
The Font Group
The Alignment Group
The Number Group
Wrapping Text in a Cell
Format Painter
Merge or Split Cells
Merging Cells
Merge Across
Center across selection
Merge Cells
Un merge Cells
Headers and Footers
Headers and Footers
Inserting headers and footers
Printing Headings
Print Titles
Print Columns to Repeat with Titles
Hide and Unhide Rows and Columns
Hiding Columns
Un hide Columns
Hiding Rows
Unhide Rows
Page Setup Options for Worksheets
Page Orientation
Modifying page setup
Change the Margins
Changing the Header and Footer Size
Setting Print Scaling
Print a Worksheet or a Workbook
Printing
Printing individual worksheets
Cell Styles
Apply Cell Styles
Create Cell Styles
Autofill
Copy Data using Autofill
Copy Formatting using Autofill
Flash Fill
Flash Fill
Formulas
Formulas Introduction
Create Formulas
Add, Subtract, Multiply, Divide
Make Changes to Formulas in the Formula Bar
Using Autofill to Copy Formulas
Enforce Precedence
Order of Evaluation (Order of Precedence) (BODMAS)
Absolute Cell References
Absolute Cell References
How to Create an Absolute Cell Reference
Relative Cell References
Basic Functions
Basic Functions
Using Basic functions via the Auto sum Button
Managing Worksheets and Workbooks
Introduction Worksheets
Create and format worksheets
Adding worksheets to existing workbooks
Delete Worksheets
Copying and moving worksheets
Rename a Worksheet
Grouping Worksheets
Changing worksheet tab colour
Hiding worksheets
Sum across Worksheets
Manipulate window views
Splitting the window
Open Two Copies of the Same Workbook
Index
ID Numbers
Links outside Open Library
Community Reviews (0)
Feedback?History
- Created August 10, 2015
- 4 revisions
Wikipedia citation
×CloseCopy and paste this code into your Wikipedia page. Need help?
August 22, 2020 | Edited by ISBNbot2 | normalize ISBN |
August 10, 2015 | Edited by Alice Kirk | Edited without comment. |
August 10, 2015 | Edited by Alice Kirk | Added new cover |
August 10, 2015 | Created by Alice Kirk | Added new book. |