Author
Released
1/31/2013- 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
Skill Level Intermediate
Duration
Views
- 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.
Related Courses
-
Excel 2010 Essential Training
with Bob Flisser6h 21m Beginner -
Excel 2010: Tips, Tricks, and Shortcuts
with Dennis Taylor3h 43m Intermediate -
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate
-
Introduction
-
Welcome1m 47s
-
-
1. Understanding Excel and Its User Interface
-
Why use Excel?3m 21s
-
Examining your file's info2m 54s
-
Exploring the Ribbon6m 38s
-
-
2. Getting Started with Basic Tasks in Excel
-
Switching between views3m 28s
-
3. Developing Your Spreadsheet
-
Aligning text and numbers3m 49s
-
Choosing number formats4m 40s
-
4. Creating More Complex Formulas
-
Writing your own formulas6m 11s
-
Formatting dates and times5m 46s
-
Naming cells and ranges5m 18s
-
Fixing common errors6m 20s
-
Tracing Errors5m 21s
-
-
5. Making Changes to Your Workbook
-
Transposing rows and columns2m 28s
-
Merging and unmerging cells4m 19s
-
6. Visualizing Your Data with Color, Charts, and Graphics
-
Creating charts5m 33s
-
7. Analyzing Data
-
Creating a data table3m 57s
-
Grouping data in outlines3m 12s
-
Building a pivot table5m 4s
-
-
8. Printing and Sharing Your Worksheet
-
Setting up page breaks4m 13s
-
Emailing a workbook3m 22s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome