Sign up for Microsoft Office training, SharePoint training and more.
Excel 2007 Training
Personalized Online Training
Get answers to everyday questions and on-demand training with over 7,000 Interactive Tutorials.
Bite-sized software simulations.
Accurately test your staff’s skills.
Training manuals with unlimited printing rights.
FREE Cheat Sheets
Just sign up, download, and share.
- Tablet / mobile
- LMS / SCORM
Microsoft Excel is a product used by individuals and business professionals around the world, ranging from biologists to accounting professionals and students. Excel has something for everyone! In this course you will learn everything from using contextual menus and the mini toolbar to understanding the Ribbon.
Worksheets are the primary foundation to the Excel program and in this course we will cover topics such as creating new workbooks, entering formulas, using cell references, and why using Autofill is your new best friend!
Editing a Worksheet
Ready to roll your sleeves up and start building a spreadsheet? In this course you will learn how to enter and edit cell data, fix typos, remove data you no longer need, hide rows and columns, and tracking changes.
Formatting a Worksheet
I bet you’re wondering how to make this boring pile of data into a visually appealing pile of data that is easy to understand. Well, not to worry because in this course you will learn how to format values, alignment, create background colors and patterns, apply cell styles, format painter, and other document themes. Who said data had to be boring?
Creating and Working with Charts
Excel 2007 offers a variety of charts and options that will save you time while keeping your data organized and easier to understand. In this course you will learn how to create a chart, apply built-in chart layout styles, work with chart backgrounds, and how to work with chart labels and axes.
It is no surprise that most of your time will be spent managing your worksheets, which is why it is important that you understand how to navigate them properly. In this course you will learn how to view, move, rename worksheets, split and freeze workbooks, and how to create a template.
Working with Page Layout and Printing
To print and distribute your worksheets you will need to configure a few settings to make sure your worksheets don’t print out the wrong way. In this course you will learn about adjusting page size and scale, using page breaks, adding print titles and headlines, creating headers and footers, and adjusting page margins and orientation
More Functions and Formulas
To further enhance your worksheet, Excel 2007 offers functions and formulas that will give your technical side a challenge. In this course you will learn about topics such as AutoCalculate and Manual Calculation, defining names, displaying and tracing formulas, and much more!
Working with Data Ranges
Data, Data, Data. All data has to have some type of organization and Excel 2007 offers features that allow you to sort by multiple columns, colors, and even icons! You can also create custom lists and custom AutoFilters.
Working with Tables
Tables are a simple, fast way to create an organized view of your data and in this course you will learn all about tables such as creating tables, summarizing a table with a PivotTable, table styles, and working with table data.
Working with PivotTables
PivotTables are not just for geeks – they are for anyone who has a large amount of data that needs consolidation. It’s a useful and powerful data analysis tool that will summarize, analyze, and present you data. In this course you will learn how to create PivotTables and PivotCharts, specify data, change calculations, group data, and how to work with timelines.
Working with the Web and External Data
Do you have a lot of data that’s from an external source, such as the Internet? No problem – in this course we have developed lessons that show you how to import data from the web and other sources, create a web page from a workbook, and how to work with existing data connections.
Working with Macros
I bet you’re wondering what a Marco is and how you can use it in your worksheet? In this course you will learn about all things Marcro, such as recording a Macro, playing and deleting a Macro, declaring variable and adding remarks to the VBA Code, using the If-Then-Else Statement, and prompting for user input. Things are about to get a lot more interesting!
Working with Objects
You may be asking, what is an object and how does it relate to Excel? Good question! In this course you learn about Clip Art, WordArt, SmartArt, and applying special effects to Objects. You will also learn how to inset an embedded object and insert symbols.
You have the option to customize Excel to your likings, and in this course we have developed lessons that will teach you how to accomplish the more advanced topics. You will learn about customizing the Quick Access Toolbar, creating a custom AutoFill list, and changing Excel’s default options just to name a few.
Appendix of Common Functions
Now that you’re an expert on all things Excel, we thought we would give you a farewell goodbye by giving you an appendix of common functions. You will learn about Logical Functions (IF), Financial Functions (PMT), Database Functions (DSUM), and Lookup Functions (VLOOKUP).