Step-by-step Training
- Lesson 1 – Creating lists and alphabetizing.
- Lesson 2 – Compute number totals, averages, maximums (highest), and minimums and sort totals.
- Lesson 3 – Compute payrolls (aka Payroll Register).
- Lesson 4 – Computing sales.
- Lesson 5 – Calculate purchase discounts and sales tax.
- Lesson 6 – Tracking employee time sheets.
- Lesson 7 – Tracking and sorting data.
- Lesson 8 – Analyze data using charts.
- Lesson 9 – Using bar graphs to track data.
- Lesson 10 – Using Pivot Tables to drill into data to summarize, analyze, explore, and present your data.
Common Tasks
Video Training
Beginner: Beginner’s Guide to Excel – Excel Basics
Beginner: Useful Excel Keyboard Shortcuts
Beginner: Using Freeze Panes
Beginner: Quick and Simple Charts
Beginner: Using Find and Replace Commands
Beginner: Sorting
Intermediate: Excel Skills, Tips, and Tricks
Intermediate: Removing Duplicates
Intermediate: Hiding Data
Intermediate: Creating Excel Templates
Intermediate: Creating Pivot Tables
Intermediate: Splitting Names from One Cell
Intermediate: Using Split Option to View Data
Intermediate: Cell Alignment Options
Intermediate: Excel Printing Options
Advanced: Protecting Excel Spreadsheets
Advanced: Using Pivot Tables
Advanced: VLOOKUP Basics
Advanced: Using the IF Function
Advanced: Using Flash Fill
Advanced: Data Validation and Drop-down Lists
Advanced: 3D Formulas
Extra: Using the Screenshot Tool in Excel
Additional Online Resources
Microsoft Excel can be very complex with hundreds of different applications – most of which you will never use. However, you may encounter a challenge not covered in this course and I want to point you in the right direction for help. There is a wealth of information available on the internet to assist you with Excel, below are 10 places to find help and get trained for free.
1. Mr. Excel Message Boards – The mother of all Excel Help Forums, Mr. Excel has gathered quite a following over the years. With most of the top Excel “power users” from around the world hanging out in these forums, you’re bound to get your questions answered directly, or find that they have already been answered in their vast archives of previous threads. Just be mindful of posting your questions in the proper format (read the posting rules); Message Board types don’t take too kindly to newbies not following the rules. Also, check out their fantastic archive of Excel Video Tutorials
2. Ozgrid.com Forums – Ozgrid.com’s Forums have a lively community of Excel Experts ready to answer your questions. If you see an ozgrid.com post while searching Google for Excel information, you can usually be assured that it is a quality thread. Ozgrid is exceptionally good at VBA programming-related questions.
3. Experts-Exchange – Experts-Exchange is the cream of the crop. The site is set up in a question/answer format. Users can post questions, and Experts can post answers. The user then selects the best answer (much like Yahoo! Answers, but Tech-focused). All previously answered questions are searchable. Experts Exchange is unmatched in its quality of content and is the go-to place for obscure questions that can’t normally be answered anywhere else. We would have ranked Experts-Exchange #1 if it wasn’t for one thing, you have to register for the site and either pay a monthly fee or contribute “answers” regularly to keep your account active. Many a frustrated Excel novice will tell you that Experts-Exchange is no good, but that is because only the questions are viewable to the public, not the answers. Suck it up and register for the site, answer a few questions for people that are more of a novice than you, and save yourself the monthly fee.
4. Microsoft’s Official Excel Training – Yes, that’s right…Microsoft provides some things for free. The online training modules offered on Microsoft’s websites are top-notch. With hundreds of videos, podcasts, and tutorials, there’s bound to be something for everyone. Many of the tutorials are a little on the easy side, but the quality is fantastic.
5. Jon Peltier’s Site – Jon Peltier is a Certified Microsoft MVP for Excel. He probably knows more than anyone on the planet about Excel, and fortunately, he’s willing to share his knowledge with us. Check out the chart tutorials; they’re a little more advanced, but some pretty amazing stuff, especially if you design corporate dashboards.
6. AllExperts.com Forums – AllExperts is a simple, mostly text-based site that follows the question & answer format. They have hundreds of users waiting to answer your questions.
7. Microsoft Developers Network (MSDN) Excel Blog – Keep up-to-date with the latest MS Excel news straight from the horse’s mouth. Another valuable, free service offered by Microsoft.
8. YouTube – Believe it or not, YouTube has many high-quality tutorials. If you’re a visual learner, this is an indispensable tool.
9. Google – When in doubt, google it! Learn how to do advanced Google queries to help you find what you need faster.