Here are 11
Excel Tutorials at nicetutz.blogspot.com that cover
several Excel features, including Excel 2007 and Excel XP
templates, working with spreasheet files, protecting data, and
creating charts. These Excel tutorials also show how to print and
manage workbooks in Excel 2007; navigating, searching, and formatting
spreadsheets; the top new features in Excel 2007; shortcut keys for
Excel; and tips for using Excel 2007. Most of these tutorials
are for Excel 2007.
What
are
Templates in Excel 2007
These Excel tutorials teach you templates in Excel 2007. Some of
the topics covered here are workbook tem;plates, custom Excel
templates, working with default templates, print setting using
template, creating custom templates, creating and using a chart
template.
- What
are
Templates
- Exploring
Excel Files
- Working
with Workbook Templates
- Understanding
Custom Excel Templates
- Working
with Default Templates
- Print
Setting Using Template
- Creating
Custom Templates
- Ideas
for Creating Templates
- Sharing
Templates with Others
- Controlling
Styles with Templates
- Locking
Formula Cells in Template File
- Creating
and Using a Chart Template
What
are Templates in Excel XP
These tutorials cover topics such as creating templates,
workbook templates, creating default
workbook template, creating custom templates, locking formula cells etc.
- What
are
Templates
- How
to Create Templates
- Working
with Workbook Templates
- Understanding
Custom Excel Templates
- Creating
a Default Workbook Template
- Changing
Default Print Setting Using a Template
- Creating
Custom Templates
- Learn
About Style
- Locking
Formula Cells in Template File
Working
with Excel 2007 Files
These tutorials on Excel explain working with Excel 2007
files. The
various topics covered here are select commands with keyboard, quick
access toolbar button, saving a workbook, using auto recover,
specifying workbook properties and password, renaming a file etc.
- Working
with Excel Files
- Open
and Explore Excel
- Select
Commands with Keyboard
- Quick
Access Toolbar Button
- Change
Status Bar Indicators
- Create
New Excel File
- Save
a
Workbook
- Using
AutoRecover
- Open
an Existing Excel File
- Opening
Workbooks Automatically
- Rename
a File
- Specify
Workbook Properties
- Specify
a Password
- Safeguarding
your Work
Protecting
Excel 2007 Data
The below Excel tutorials discuss protecting Excel 2007 data. The
topics covered here are quickly hiding an opened workbook, making a
file read-only, hide and unhide columns and rows, unlocking cells,
using digital signatures etc.
- Protecting
Excel Data
- Quickly
Hide an Open Workbook
- Make
a
File Read-Only
- Mark
a Workbook as Final
- Inspecting
a Workbooks
- Hide
and Unhide Columns and Rows
- Unlock
Cells
- Protect
Worksheets
- Restrict
User Data Entry
- Assign
a File Password
- Hide
Cell Formulus
- Protecting
a Workbook’s Structure
- Using
a Digital Signature
- Signing
a
Workbook
Creating
Charts in Excel 2007
These tutorials deal with creating charts in Excel 2007.
The various topics which are covered here are creating basic charts,
formatting chart elements, inserting charts, chart styles, adjusting
chart locations, adding text links, enhancing a 3-D chart, creating and
using chart template etc.
- Creating
Charts in Excel 2007
- What
is
Chart?
- Creating
Basic Charts
- Formatting
a Chart Elements
- Insert
Chart
- Chart
Styles
- Change
the Chart Type
- Adjust
Chart Location
- Display
Chart Title
- Customize
Chart Legend
- Displaying
Data Table in Chart
- Select
Chart Color Style
- Change
Axis Options
- Adding
Text Links
- Enhance
a 3-D Chart
- Place
a Picture in Data Series
- Adjust
Chart Data
- Handling
Missing Data or Charting Hidden Data
- Selecting
a Chart Elements
- Creating
and Using Chart Template
- Working
with Charts
- Tips
Printing
Workbooks in Excel 2007
These tutorials show how to manage printing workbooks in Excel
2007. The topics covered here are spell checking, preview before
printing, adding a manual page break, setting a specific area to print,
setting page margins, adding a standard header or footer, printing
worksheets and charts, inserting watermarks, emailing a workbook etc.
- Printing
Workbooks
- Spell
Check
- Preview
Before Printing
- Add
a Manual Page Break
- Changing
your Page View
- Set
a Specific Area to Print
- Adjust
the Paper Orientation and Size
- Make
Worksheet Fit Better on a Page
- Set
Page
Margin
- Specify
Repeating Rows and Columns
- Printing
Gridlines and Rows and Columns Headings
- Add
a Standard Header or Footer
- Creating
Custom Header or Footer
- View
Other Header and Footer Options
- Print
Worksheets and Charts
- Inserting
Watermark
- Changing
Default Print Setting Using a Template
- Email
a
Workbook
- Letting
Your Formulus All Hang Out
Managing
Workbooks in Excel 2007
These tutorials cover managing workbooks in Excel
2007. The topics covered here are creating an empty workbook, inserting
additional worksheets, saving files, using workspace files, inserting
hyperlinks, arranging windows automatically, opening nonstandard files,
working with workbook templates etc.
- Managing
Workbooks
- Creating
an Empty Workbook
- Insert
Additional Worksheets
- Protecting
and Unprotecting a Workbook
- Saving
Files
- Switching
Among Open Workbooks
- Using
a Workspace File
- Work
with Worksheets
- Insert
a
Hyperlink
- Arranging
Windows Automatically
- Changing
the Default File Location
- Closing
a
Workbook
- Comparing
Two Workbooks Side by Side
- Creating
Multiple Windows Views for a Workbook
- Opening
Nonstandard Files
- Opening
a
Workbook
- Working
with Workbook Templates
The
Basics of Spreadsheets: Numbers, Labels, and Formulas
These tutorials teach the basics of Excel spreadsheets. The
topics covered here are storing data in spreadsheet, formatting numbers
and labels, navigating a spreadsheet, editing a spreadsheet etc.
- Understanding
Spreadsheets
- Storing
Stuff in Spreadsheet
- Formatting
Numbers and Labels
- Navigating
a Spreadsheet
- Searching
a Spreadsheet
- Editing
a Spreadsheet
- Clearing
Data
Top
New Features in Excel 2007
This tutorial shows the new features in Excel 2007.
This tutorial teaches you style galleries, ribbon, page layout, zoom
slider and other new features.
Some
Basics in Excel 2007
This tutorial deals with some of the basic features in
Excel 2007 which teach you all the fundamental skills required to use
Excel 2007.
Excel
Shortcut Keys
This document lists Excel’s shortcut keys
which will come handy for the frequent users.
- Moving
Through a Worksheet (Shortcut Keys)
- Moving
within a Range Selection (Shortcut
Keys)
- Other
Shortcut Keys
Tips
for Using Excel 2007
These tutorials provide various tips with using
Excel 2007. The tips covered here are: organizing
spreadsheet data in different worksheet, generating new workbooks from
templates, using range names, preventing data entry errors with data
validation, controlling display of data in tables through outlines etc.
- Organizing
Spreadsheet Data on Different Worksheet
- Generating
New Workbooks from Templates
- Freezing
Column and Row Headings
- Creating
Data Series with Autofil
- Using
Range Names
- Preventing
Data Entry Errors with Data Validation
- Saving
Memory by Using Array Formulas
- Trapping
Error Values in their Original Formulas
- Controlling
Display of Data in Tables Through Outlines
- Using
View Side by Side to Work with Two Workbooks
Popularity: 17% [?]
Related Posts:15 Microsoft Excel Lessons with Exercises16 Excel Video TutorialsFree Microsoft Excel Video TrainingExcel 2003 Tutorial from the University of Texas4 Excel eBooks, 6 Access eBooks, and 1 Visio eBook
Tags for this post>>
Excel |
Excel 2007