Learn Excel 2010: The Basics

with Chris Grover
please wait ...
Learn Excel 2010: The Basics
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
Author:

Welcome

- 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 some of the common pitfalls people encounter when using this powerful program.

This course starts with basic spreadsheet skills, like entering and formatting numbers and text. 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 lines. 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 lessons builds on techniques already covered. By the time you get to the end, you'll know how to use advance 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. Whether you're a first time user or you just wanna expand your skills, this course should give you the information you need to use Excel capably and confidently.

Let's get started.

please wait ...