Navigation

 

Home

About Me

New Horizons

Geek Fun

Recommended Reading

Geek Movies

IT Websites

What's New In IT?

Bizarre Geek

 

Blogs:

My In Transit Blog

My Writing Blog

My Computerease Blog

The Plot Thickens

 

 

Websites:

daverhoades.org

daverhoades.com

 

 

Microsoft Office Products 2003

Access

Excel

Outlook

PowerPoint

Publisher

Visio

Word

 

Microsoft Office Products 2007

Access

Excel

Outlook

PowerPoint

Publisher

Visio

Word

 

SharePoint

SharePoint

 

 

Microsoft Operating Systems

DOS

9x (95,98, ME)

NT 4.0

2000

XP

Vista

 

 

Technical and Networking

A Plus Certification

Network Plus Certification

Security Plus Certification

MCSA

MCSE

MCSD

 

Misc. Helps

For New Horizons Students

Tips and Tricks

 

Web Helps

Learn To Subnet

Web Development

 

Testing and Practice Exams

Pearson Vue

Thompson Prometric

Pass It Now

Pro Professors

Free Practice

Exam Cram

Transcenders

 

Websites and Links

 

 

 

 

 

 

 

 

 

 

 

 

excel

 

Excel 2003

Did you know? That there are 65,536 rows in an Excel spreadsheet by 255 columns? That's 16,711,680 cells in one spreadsheet! And you can access the last row by holding down your Ctrl key and pressing your "down arrow" key.

Wonder where those whiz kids at Microsoft came up with that number?

It's all binary code baby! 65,536 is 2 to the 16th power. Did you also know, that each cell in an Excel spreadsheet can hold, 65.536 characters? You would know if you came to my class.

I had a man in a Word class one day that said he typed all of letters in Excel! He simply clicked in a cell and typed them and then printed them out. He said he thought is was time he came and learned a word processing program. I told him, that was a good idea.

In the Excel Office 12 spreadsheet there are 1,048,576 rows by 16,384. That's 2 to the 20 power and 2 to the 14th power and gives us a whopping 17,179,869,184 cells!

That's a lot of little parking places for all of you CPA's out there!

 

 

Excel Shortcut Keystrokes:

Click here to download a PDF file of Excel Shortcuts

PDF Excel Formula Tips

PDF Excel Quick Reference

PDF Excel Keyboard Shortcuts

Practice Files for Excel 2003

These practice files are used with our curriculum from my classes. You must have the book in order for these to make sense.

Basic:

Basic Zipped Files

Intermediate:

Unit 1 Large Worksheet

Unit 1 Practice Sales Worksheet

Unit 2 Overall Sales

Unit 2 Navigate

Unit 2 Yearly Sales

Unit 2 Product

Unit 2 Practice Sales 2004-2005

Unit 3 Customize

Unit 3 Practice Customize

Unit 4 Advanced Formatting

Unit 4 Practice Adv. Formatting

Unit 5 Employee Information

Unit 5 Practice List

Unit 6 Charts

Unit 6 Practice Charts

Unit 6 Profit

Unit 7 Multi User

Unit 7 Practice Multi User

Unit 8 Alt Template

Unit 8 Sample Test

All Practice Files in Zipped Format

 

Advanced Excel 2003

Unit 1 Advanced Formulas

Unit 1 Names

Unit 1 Practice Formulas

Unit 2 Lookups

Unit 2 Lookup Practice

Unit 3 List Management

Unit 3 List Management Practice

Unit 4 Pivot Table

Unit 4 Pivot Table Practice

Unit 5 Accounts

Unit 5 Employee Access File

Unit 5 Employee Info

Unit 5 Employee Record

Unit 5 Employees

Unit 5 Export as XML

Unit 5 Exporting

Unit 5 Exporting Practice

Unit 5 Querying Database

Unit 5 Product

Unit 6 Analytical Options

Unit 6 Analytical Options Practice

Unit 7 Multi User

Unit 7 Macros

Unit 7 Macros Practice

Unit 7 Running Macros

Unit 8 Advanced Web

Unit 8 Advanced Web Practice

Unit 9 There are no practice files

All Practice Files in Zipped Format

 

Excel Links:

Undiscovered Tips About Excel

Excel Developer Tips

Martin Green on Excel VBA

Getting Started with Macros

Tons of Excel Stuff!

Custom Macros

Macros and VBA Functions

The Excel Addict

Macro Tips

Excel Macro Tutorials

More VBA and Macros

Add-ins and Macros

Macro Hacks

Macro Examples

Durham University on Macros

Simple Macro Examples