Excel 2010 Essential Training

with Bob Flisser
please wait ...
Excel 2010 Essential Training
Video duration: 0s 6h 21m Beginner

Viewers:

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:
  • Copying and pasting techniques
  • Working with formulas and functions
  • Dealing with formula errors
  • Creating lookup tables
  • Naming cell ranges
  • Formatting data and worksheets
  • Finding and replacing data
  • Creating SmartArt diagrams
  • Creating charts and PivotTables
  • Recording macros
  • Sharing workbooks
Subjects:
Business Education + Elearning
Software:
Excel
Author:

Welcome

Welcome to Excel 2010 Essential Training. I'm Bob Flisser, and I'm excited to bring this course to you. I'll show you everything you need to get up to speed in Excel quickly. So you can be productive in the shortest possible time. We'll start by making sense of the interface, and by using the ribbon toolbar. I'll even show you how to customize it. Of course, the most important part of Excel, is knowing how to write formulas. I'll make it understandable, so you'll be writing formulas with the best of 'em, in no time. Once your worksheet has the information you need, you'll want to make it look good.

We'll build a worksheet from start to finish, that not only looks good, but also conveys the information clearly. Do you want to know how to create great looking 3D charts? Or maybe you want a powerful way of summarizing, or analyzing data. We'll do all that and more. So, let's get started learning how to use Microsoft Excel 2010.

please wait ...