Courses
Courses Designed For Beginners, Seasoned IT Pros & Everyone In Between
Excel 2007
View All CoursesIn this Excel 2007 training course, you’ll learn everything from using the basic tools to the most advanced techniques, like tracking expenses, budgeting goals, and creating keyword lists. This in-depth course is recommended for both beginners and experienced users.
Lessons
-
Lesson Clips
- Introduction
- Instructor Introduction
- Who Should Take This Course
- What's Covered
- Our Scenario
- Keyboard Shortcuts
- What We Covered
-
Lesson Clips
- Introduction
- The Ribbon
- Navigation
- What We Covered
-
Lesson Clips
- Introduction
- Entering Data
- Cut, Copy Paste
- Undo, Redo
- Insert Rows and Columns
- Width and Height
- Find and Replace
- Working with Ranges
- Auto Fill
- What We Covered
-
Lesson Clips
- Introduction
- Order of Operations
- Basic Formulas
- Functions
- Absolute Reference
- Difference Between Save and Save As
- What We Covered
-
Lesson Clips
- Introduction
- Worskheet and Workbook
- 3D Reference
- Managing Worksheets
- Workspaces
- What We Covered
-
Lesson Clips
- Introduction
- Numbers
- Text Formatting
- Cells
- What We Covered
-
Lesson Clips
- Introduction
- Freeze Panes
- Sorting
- Filtering
- Data as Tables
- What We Covered
-
Lesson Clips
- Introduction
- Styles
- Themes
- Shapes
- Addint Text to Our Shapes
- Word Art
- Graphics
- Clip Art
- Arranging Order
- Backgrounds
- Smart Art
- What We Covered
-
Lesson Clips
- Introduction
- Naming Ranges
- Lookup and Reference - Vlookup
- Lookup and Reference - Range Lookup
- Lookup and Reference - Hlookup
- Logical Test
- Nested IF
- IF with AND
- Financial Tasks
- Using Database Functions
- Text
- What We Covered
-
Lesson Clips
- Introduction
- Errors
- Data Validation
- Invalid Data
- Watch Your Data
- Watch Window
- Conditional Formatting
- What We Covered
-
Lesson Clips
- Introduction
- What Is a Chart?
- Create a Chart - Column
- Pie Chart
- Combination Chart
- Bar Chart
- Format Your Chart
- What We Covered
-
Lesson Clips
- Introduction
- Linking Workbooks
- Fixing Broken Links
- Consolidating
- What We Covered
-
Lesson Clips
- Introduction
- What is a template?
- Creating Our Own
- Save as Template
- What We Covered
-
Lesson Clips
- Introduction
- What are They?
- Creating a Pivot Table
- More Fun with Pivot Tables
- Formatting
- Pivot Charts
- What We Covered
-
Lesson Clips
- Introduction
- Protect a Workbook
- Tracking Changes
- Merging Documents
- Comments and Hyperlinks
- What We Covered
-
Lesson Clips
- Introduction
- Using Macros
- Building Macros
- Personal Macro Workbook
- Buttons
- Macro Editor
- Saving Macros
- What We Covered
-
Lesson Clips
- Introduction
- Viewing Your Documents
- Page Layout
- Headers and Footers
- Get Ready to Print
- What We Covered
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.
