Excel 2007 Training
Start learning now.Sign up for Microsoft Office training, SharePoint training and more.
Bite-sized software simulations.
Accurately test your staff's skills.
Training manuals with unlimited printing rights.
Just sign up, download, and share.
- Tablet / mobile
- LMS / SCORM
Excel 2007 Courses
The FundamentalsLength: 32 minutes
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 Excel 2007 Training course you will learn everything from using contextual menus and the mini toolbar to understanding the Ribbon.
Worksheet BasicsLength: 45 minutes
Worksheets are the primary foundation to the Excel program and in this Excel 2007 Training 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 WorksheetLength: 31 minutes
Ready to roll your sleeves up and start building a spreadsheet? In this Excel 2007 Training 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 WorksheetLength: 25 minutes
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 Excel 2007 Training 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 ChartsLength: 23 minutes
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 Excel 2007 Training 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.
Managing WorkbooksLength: 28 minutes
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 Excel 2007 Training 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 PrintingLength: 14 minutes
To print and distribute your worksheets you will need to configure a few settings to make sure your worksheets dont print out the wrong way. In this Excel 2007 Training 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 FormulasLength: 22 minutes
To further enhance your worksheet, Excel 2007 offers functions and formulas that will give your technical side a challenge. In this Excel 2007 Training course you will learn about topics such as AutoCalculate and Manual Calculation, defining names, displaying and tracing formulas, and much more!
Working with Data RangesLength: 17 minutes
Data, Data, Data. All data has to have some type of organization and Excel 2007 Training 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 TablesLength: 23 minutes
Tables are a simple, fast way to create an organized view of your data and in this Excel 2007 Training 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 PivotTablesLength: 17 minutes
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 Excel 2007 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 DataLength: 15 mintues
Do you have a lot of data that's from an external source, such as the Internet? No problem, in this Excel 2007 Training 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 MacrosLength: 22 minutes
I bet you're wondering what a Marco is and how you can use it in your worksheet? In this Excel 2007 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 ObjectsLength: 36 minutes
You may be asking, what is an object and how does it relate to Excel? Good question! In this Excel 2007 Training 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.
Advanced TopicsLength: 21 minutes
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 Excels default options just to name a few.
Appendix of Common FunctionsLength: 10 minutes
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).
Copyright © 2014 CustomGuide, Inc. All rights reserved.