Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Excel 2010 Essential Training

via LinkedIn Learning

Overview

Excel tutorials that use real-world examples to teach the core features and tools in Excel 2010.

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Getting Started
  • Exploring three common uses for Excel
  • Touring the interface
  • Finding the commands you need
  • Using Backstage view or the File tab
  • Maintaining file compatibility
2. Worksheet Basics
  • Creating a worksheet
  • Techniques for copying and pasting
  • Entering data automatically with Auto Fill
  • Targeting large data groups
  • Changing a worksheet's structure
3. Excel Formula Basics
  • Understanding formulas and functions
  • Entering data in a worksheet
  • Adding numbers manually
  • Adding numbers using Sum and AutoSum
  • Adding a whole worksheet
  • Working with numbers in columns
  • Preventing errors using absolute references
  • Working with times and dates
  • Using IF
  • Using SUMIF and AVERAGEIF
  • Naming and using cell ranges
4. Essential Formatting
  • Formatting numbers and dates
  • Applying fonts, background colors, and borders
  • Adjusting columns, rows, and text
  • Using conditional formatting
  • Using custom conditional formatting
  • Adding pictures and shapes
5. Advanced Formatting
  • Inserting SmartArt
  • Coordinating a look using themes
  • Applying built-in styles
  • Creating and sharing styles
  • Using templates
  • Creating and using original templates
6. Printing Preparation
  • Making the pieces fit
  • Inserting headers and footers
  • Printing and PDFs
7. Large Excel Projects
  • Finding and replacing data
  • Freezing panes
  • Repeating row and column titles
  • Creating multiple custom worksheet views
  • Hiding or grouping rows and columns
  • Managing worksheets
  • Calculating formulas across worksheets
8. Collaborating with Others
  • Importing and exporting data in Excel
  • Setting workbook permissions
  • Inserting and editing comments
  • Sharing a workbook
  • Tracking changes
  • Saving files in shared locations
9. Exploring Excel's Database Features
  • Splitting cell data into multiple cells
  • Joining data from multiple cells
  • Basic and multi-field sorting
  • Using tables to sort and filter data
  • Inserting automatic subtotals
  • Creating lookup tables
10. Analyzing Data
  • Using auditing to diagram
  • Using evaluation in Excel
  • Working with Goal Seek
  • Using data tables in formulas
  • Using scenarios in formulas
  • Exploring the Analysis ToolPak
11. Advanced Analysis with PivotTables
  • Discovering PivotTables
  • Creating a basic PivotTable
  • Modifying a PivotTable
  • Creating and modifying a PivotChart
12. Creating and Using Charts
  • Choosing chart types
  • Inserting Sparklines
  • Creating a column chart
  • Modifying a column chart
  • Creating and modifying a pie chart
  • Placing Excel charts into other Office applications
13. Creating and Using Macros
  • Understanding macros
  • Recording and using a simple macro
  • Editing a macro
14. Customizing Excel
  • Customizing the Quick Access toolbar
  • Customizing the Ribbon bar
  • Setting Excel options
Conclusion
  • Goodbye

Taught by

Bob Flisser

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Excel 2010 Essential Training

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free