Viewers: in countries Watching now:
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.
(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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.