Up and Running with Excel 2010
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.
- 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
(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.
Excel 2010 Essential Training5,756,965 Views
Excel 2013 Essential Training5,659,883 Views
Access 2010 Essential Training3,079,123 Views
Excel 2010: Pivot Tables in Depth1,309,159 Views
Foundations of Programming: Fundamentals6,728,971 Views
Excel 2010: Advanced Formulas and Functions968,662 Views
Access 2013 Essential Training2,494,302 Views
Word 2010 Essential Training2,015,804 Views
HTML Essential Training3,250,120 Views