Up and Running with Excel 2010

with Chris Grover
please wait ...
Up and Running with Excel 2010
Video duration: 0s 3h 52m Appropriate for all

Viewers:

Excel is the industry-standard spreadsheet program, and almost all of us find ourselves using it at one point or another. In this workshop veteran author Chris Grover teaches you the fundamental skills you need to work with Excel, starting with basics like entering and formatting numbers and text, then moving on to writing formulas and using Excel's built-in functions. Learn about sorting, filtering, and lookup, as well as charts, graphs and sparklines, and even advanced tools like pivot tables. Along the way, Chris covers the new features in Excel 2010 and techniques for troubleshooting your spreadsheet when something goes wrong.

Topics include:
  • Understanding Excel and its user interface
  • Getting started with basic tasks
  • Developing your spreadsheet
  • Creating more complex formulas
  • Making changes to your workbook
  • Visualizing your data with color, charts, and graphics
  • Analyzing data
  • Printing and sharing your worksheet
Subjects:
Business video2brain
Software:
Excel Office
Author:

Welcome

(music playing) Hi, I'm Chris Grover, author of several books on Microsoft Office and a long time spreadsheet developer. Over the years I've used Excel to create budgets, sales plans, statistical reports, and many other business systems. Today I work with a number of clients, helping them to develop and use spreadsheets that are customized for their needs. The purpose of this course is to get you up to speed, not only using Excel, but making the most of it. In addition to teaching you the basics, I'll also share some helpful tips and tricks that I've learned throughout the years, and show you how to avoid of the some common pitfalls people encounter when using this powerful program. This course starts with basic spreadsheet skills like entering and formatting numbers and text, and then it moves on to writing formulas and using Excel's built in functions.

Data techniques like sorting, filtering, and look up are covered thoroughly. Excel provides a number of ways to analyze data through charts, graphs and sprite mines, so several lessons explore those topics. Along the way, you'll become familiar with the new features in Excel, like the ribbon, a recently introduced tool for choosing and using commands. Each lesson builds on techniques already covered. By the time you get to the end, you'll know how to use advanced tools, such as data tables and pivot tables, and you'll have the knowledge to troubleshoot your spreadsheet when something goes wrong. After watching this course, you'll be prepared to create spreadsheets for all sorts of business applications.

You'll become familiar with the most frequently used and popular features that Excel has to offer. So whether you're a first time user or you just want to expand your skills, this course should give you the information you need to use Excel capably and confidently. So let's get started.

There are currently no FAQs about Up and Running with Excel 2010.

please wait ...