This course was designed to make people better in Excel by talking about things that confuse people every day (VLOOKUPs, PivotTables, printing things on one page). Not only do we teach you how to do all of theses wonderful features in Excel, we'll teach you why. With exercise workbooks that let you work EVERY single example we demonstrate so that you can actually learn how features work, we guarantee that you will feel more at ease with Excel when you're done with this course..
Navigating through the Ribbon and finding everything you need in no time!
Keyboard shortcuts and some of Excel Rain Man’s go-to moves for PC 2010 spreadsheeters
Use this Workbook with every lesson in this chapter except Ribbon lecture
Download this file to follow along with the Ribbon lecture
Guide to creating your own tab with the Excel Rain Man go-to fields
Using Freeze Panes to efficiently view spreadsheets, Unfreeze Panes
Setting up Filters, Using Custom Filters, AutoFilters (Advanced Filtering Techniques)
Copy/Paste Refresher, Paste Special (Formulas, Values, Transpose)
Use this workbook with all the lectures in chapter 2. it will contain the same workbook we use in the lectures so that you can follow along and practice to learn the concepts
Use this workbook to work along with the all of the lectures in the Introduction to Formulas Chapter.
Utilizing absolute and relative references and partial absolute references
Understanding named ranges and creating them to make spreadsheets more efficient
Exploring more advanced functions and having criteria applied to sum, count and average functions
Use this exercise workbook to follow along with the lessons in chapter 4, Intermediate functions
Using the IF function to add logic to formulas and to nest functions
Using many of Excel's text based functions
Creating a unique list of items from a column or table with many duplicates
Exercise file for Validation, Find and Replace, Working with Tables, and Goal Seek.
Have you ever wanted to make a drop down list with pre defined choices? Data validation is the tool in Excel that will let you do that. This lesson will teach you all about data validation.
Review the Find and Replace functionality of Excel. Also see how you can use find to search for colors and formats.
Learn all about Excel's table features. See how they can add great formatting and efficiency to your data.
This incredible tool is one of the hidden gems of Excel. It allows you work formulas and functions backwards to solve for component values.
This workbook is used with all of the lectures in the Pivot Table Introduction Chapter
Useful ways for sorting and filtering in PivotTables
Use this workbook for the lectures in the Intermediate Pivot Tables Chapter
Creating new metrics in your pivot table based on a calculation
Keeping PivotTables up to date with new data, or data from a different source
One of Excel’s coolest new features! Check it out…
Use this workbook with every lecture in the Viewing and Printing Chapter.
Utilizing Excels different viewing elements including turning on and off gridlines and column headings
Preparing a document to print by setting print area, adjusting page layouts, inserting page breaks and print titles, addressing scaling and sizing issues
Adding headers and footers to print important information on each printed page of your workbook
Download this file to follow along and practice the charting videos.
This lesson introduces you to Excel charting. Showing you some of the options to enhance your data with graphics that deliver a strong message.
This lesson will teach you the basics of how to build a simple chart.
In this lesson, we'll see how to configure the Y axis. We'll see how to orient the values, scale the units (hundreds, thousands, etc), and even set a logrithmic scale.
Professionally, Tom has been in the IT/Computer field for over 20 years. Much of that time has been spend on 'end user tools' such as Microsoft Visual Basic, Excel and Access. Tom has spent over 10 years in financial services companies building and maintaing complex spreadsheet models and utilizing a classical programming background to develop accurate and robust reporting solutions.
From a personal standpoint, Tom LOVES spending time with his wonderfamily, skiing (snow or water), fitness, and sharing his extensive knowledge of microsoft products whenever he gets the chance.
ExcelRainMan.com is designed to help users of every level with problems concerning Excel spreadsheets. Regardless of what industry you are in, most individuals at some point find themselves dealing with the utter aggravation of Microsoft Excel. As the Excel Rain Man Team, people can send us their spreadsheet related questions/problems and in turn, we bring our mad skills to solve whatever the issue may be. We also offer customized classes as well as video tutorials. Check us out at www.excelrainman.com.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /></font>