Courses
Courses Designed For Beginners, Seasoned IT Pros & Everyone In Between
Excel 2010
View All CoursesThis course will help you learn all the features in Excel 2010. You’ll learn how to take advantage of the ribbon interface, utilize formulas, make references and functions, and create charts and PivotTables. This course is recommended for anyone wanting an in-depth look at Excel 2010.
Lessons
-
Lesson Clips
- Introduction
-
Lesson Clips
- Introduction
- Entering and Selecting Data
- What We Covered
-
Lesson Clips
- Introduction
- Cut, Copy, Paste
- What We Covered
-
Lesson Clips
- Introduction
- Rows and Columns
- What We Covered
-
Lesson Clips
- Introduction
- Using the Fill Handle
- Fill Options
- What We Covered
-
Lesson Clips
- Introduction
- Worksheets
- Rename Sheets
- Freeze Panes
- Moving and Copying Sheets
- What We Covered
-
Lesson Clips
- Introduction
- Save/Save-As
- File Formats
- What We Covered
-
Lesson Clips
- Introduction
- The Ribbon
- Dialogue Box
- Mini Toolbar
- Backstage View
- The Quick Access Toolbar
- What We Covered
-
Lesson Clips
- Introduction
- Currency/Accounting Styles
- Percentage Format
- Date Formats
- Special Formats
- Custom Formats
- What We Covered
-
Lesson Clips
- Introduction
- Fonts
- Fills
- Borders
- What We Covered
-
Lesson Clips
- Introduction
- Merge and Center
- Orientation
- Alignment
- Wrap Text
- Line Break
- What We Covered
-
Lesson Clips
- Introduction
- Conditional Formatting Menu
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- What We Covered
-
Lesson Clips
- Introduction
- Zoom
- Margins
- Orientation
- Print Area
- Print Titles
- What We Covered
-
Lesson Clips
- Introduction
- Print Preview
- Scale to Fit
- Page Breaks
- Printing Options
- What We Covered
-
Lesson Clips
- Introduction
- Formula Rules
- Order of Operations
- Examples
- Building a Formula in Excel
- Value vs. Reference
- What We Covered
-
Lesson Clips
- Introduction
- Using AutoSum
- AutoSum Selection
- Average
- Max/Min
- Count Numbers
- The Auto Calculator
- What We Covered
-
Lesson Clips
- Introduction
- Relative Reference
- Absolute Reference
- 3d Reference
- Naming Ranges
- Grouping Worksheets
- What We Covered
-
Lesson Clips
- Introduction
- The IF Function
- The Nested IF Function
- Using the IF and AND Functions
- What We Covered
-
Lesson Clips
- Introduction
- VLOOKUP Function
- HLOOKUP Function
- What We Covered
-
Lesson Clips
- Introduction
- Concatenate Text
- Convert Text to Columns
- What We Covered
-
Lesson Clips
- Introduction
- Split Screen
- Workspaces with Multiple Workbooks
- Workspaces with Multiple Worksheets
- What We Covered
-
Lesson Clips
- Introduction
- Quick Sort
- Custom Sort
- Subtotals
- What We Covered
-
Lesson Clips
- Introduction
- Auto Filter
- Number Custom Filter
- Date/Time Custom Filter
- Text Custom Filter
- Advanced Filter
- What We Covered
-
Lesson Clips
- Introduction
- Defining Data as a Table
- Adding a Total Row
- Expanding a Table
- Formatting a Table
- Convert a Table to a Range
- What We Covered
-
Lesson Clips
- Introduction
- What is a Chart?
- Chart Components
- Chart Types
- What We Covered
-
Lesson Clips
- Introduction
- Insert a Chart
- Chart Types
- Change Range of Data
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- What We Covered
-
Lesson Clips
- Introduction
- Insert a Line Chart
- Choose the Chart Type
- Change the Data Range
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- What We Covered
-
Lesson Clips
- Introduction
- Insert a Pie Chart
- Choose the Chart Type
- Chart Design Options
- Chart Layout Options
- Chart Formatting Options
- What We Covered
-
Lesson Clips
- Introduction
- Line Chart
- Sparkline Options
- Column Chart
- Win/Loss Chart
- Formatting
- What We Covered
-
Lesson Clips
- Introduction
- PivotTable Example
- What We Covered
-
Lesson Clips
- Introduction
- Report Filter
- Values
- Row and Column Labels
- Styles
- Style Options
- What We Covered
-
Lesson Clips
- Introduction
- PivotTable Options
- Sorting a PivotTable
- Calculated Fields
- Show Values As
- Slicer
- Show Report Pages
- What We Covered
-
Lesson Clips
- Introduction
- Insert a PivotChart
- Manipulate the Fields
- Field Buttons
- PivotChart Tools
- Slicer
- Create a PivotChart from a PivotTable
- What We Covered
-
Lesson Clips
- Introduction
- Excel 2010 Training
Instructor
Bill Kulterman
Bill has worked as a web and graphic designer for over 6 years and has enjoyed teaching the Adobe/Macromedia Creative Suite since 2004. Although graphics classes are his favorite, he is also an award-winning Microsoft Office Instructor in Chicago.
His fun and easy going teaching style is engaging and allows for easy assimilation of new skills. When not recording the Best Computer Training on the Planet, Bill can be found at the opera or tending to his backyard pond.
