The first Excel Tutorial provides techniques on Controlling the Worksheet View, Working with Ranges, Changing Text Alignment & Angle in a Cell, Converting Text to Columns, and Text Functions.
The second tutorial covers how to work with multiple worksheets and workbooks, including Inserting Additional Worksheets, Renaming Sheets, Deleting a Worksheet, Hiding Worksheets, Moving & Coping Worksheets, Creating & Working with Graphic Objects, Linking across Worksheets & Workbooks, and Protecting Your Data.
The third Excel tutorial teaches you how to do perform Data Query and Management, specifically, Freezing the View Pane, Sorting Data, Filtering & Querying Data, Creating & Removing Subtotals, Data Validation, and Auditing Worksheets.
The last tutorial offers instructions on how to create and manage Macros in Excel, including how to record, run, assign, and delete macros.
Useful Tips & Techniques for Excel 2003
(917kb, 20 pages, pdf format)
Table of Contents:
- Getting Started Right
- Controlling the Worksheet View
- Shortcut to see a list of worksheets in a workbook
- Viewing worksheets in multiple windows
- Splitting the worksheet window into panes
- Keeping titles in view by freezing panes
- Using outlines effectively
- Hiding and un-hiding a worksheet
- Hiding & un-hiding columns and rows
- Working with Ranges
- Shortcut to entering data in multiple cells
- Shortcuts to selecting ranges
- Selecting nonadjacent ranges
- Repeating row and column labels
- Using page break preview
- Changing Text Alignment & Angle in a Cell
- Horizontal & vertical alignment option
- Displaying text at an angle
- Wrapping or shrinking text to fit the cell
- Merging cells into one cell
- Converting Text to Columns
- Text Functions
Working with Multiple Worksheets and Workbooks in Excel 2003
(579kb, 21 pages, pdf format)
This Excel training guide gives you additional techniques to efficiently use more than one workbook and worksheet at the same time. By learning and using these workbook and worksheet features you will save time and keystrokes.
Table of Contents:
- Introduction
- Inserting Additional Worksheets
- Renaming Sheets
- Colorizing the Sheet Tabs
- Deleting a Worksheet
- Hiding Worksheets
- Moving & Coping Worksheets
- Creating & Working with Graphic Objects
- Inserting Additional Worksheets
- Linking across worksheets & workbooks
- Protecting Your Data
- Assigning a password to a workbook
- Protecting workbook structure & window
- Unlocking Individual Cells in a Worksheet
- Removing a Password
Data Query & Management in Excel 2003
(705kb, 23 pages, pdf format)
Become more efficient with using Excel by learning some of Excel’s more advanced features that will assist you in working with and easily accessing large worksheets, and also many worksheets in a workbook.
Table of Contents:
- Freezing the View Pane
- Sorting Data
- Filtering & Querying Data
- Creating & Removing Subtotals
- Data Validation
- Auditing Worksheets
Using Macros in Excel 2003
(402kb, 17 pages, pdf format)
This Excel Macro Tutorial will teach you how to easily do repetitve tasks much quicker than normal. A macro is a set of recorded instructions that perform ordered tasks to carry out one or more activities or features in Excel. If you find yourself doing the same tasks over and over again, then you should learn how to create a macro to do it for you. Then all you need to do is to run the macro by pressing a few keys.
Table of Contents:
- Introduction
- Understanding what Macros are and what they can do
- Recording Macros
- Absolute Vs. Relative
- Creating an Absolute Macro
- Creating a Relative Reference
- Running Macros
- Assigning Macros
- to your Toolbar
- to an Icon Button
- to the Menu Bar
- To an Object
- Deleting Macros
- Viewing your Macro Option
- Class Exercise
Popularity: 21% [?]
Related Posts:
Tags for this post>> Excel