Most office positions require that you have a solid working knowledge of Microsoft Excel and it is such a valuable tool for home use as well.
If you are not skilled in the current release of Microsoft Excel, you may be missing out on some great opportunities. By taking this course, you will become proficient in Excel. This course is great for any level of user who wishes to get the most out of Excel.
Enroll Now
The Microsoft Excel course is an extensive, 14 chapter course, available in 2 versions (2007, 2010):
- Chapter One: Program Fundamentals
- Starting Excel
- What’s New in Excel
- Understanding the Excel Program Screen
- Giving Commands
- Using Command Shortcuts
- Creating a New Workbook
- Opening a Workbook
- Previewing and Printing a Worksheet
- Saving a Workbook
- Closing a Workbook
- Using Help
- Exiting Excel
- Program Fundamentals Review
- Chapter Two: Getting Started with Worksheets
- Navigating a Worksheet
- Entering Labels and Values
- Selecting a Cell Range and Entering Data in a Cell Range
- Overview of Formulas and Cell References
- Entering Formulas
- Entering Content Automatically
- Getting Started with Worksheets Review
- Chapter Three: Editing a Worksheet
- Editing Cell Contents
- Copying and Moving Cells
- Controlling How Cells Are Moved or Copied
- Collecting Items to Move or Copy
- Checking Your Spelling
- Inserting Cells, Rows, and Columns
- Deleting Cells, Rows, and Columns
- Using Undo and Redo
- Finding and Replacing Content
- Adding Comments to Cells
- Editing a Worksheet Review
- Chapter Four: Formatting a Worksheet
- Formatting Text
- Formatting Values
- Adjusting Row Height and Column Width
- Working with Cell Alignment
- Adding Cell Borders and Background Colors
- Copying Formatting
- Applying and Removing Cell Styles
- Creating and Modifying Cell Styles
- Using Document Themes
- Applying Conditional Formatting
- Creating and Managing Conditional Formatting Rules
- Finding and Replacing Formatting
- Formatting a Worksheet Review
- Chapter Five: Creating and Working with Charts
- Choosing and Selecting the Source Data
- Choosing the Right Chart
- Inserting a Chart
- Editing, Adding, and Removing Chart Data
- Changing Chart Data
- Changing Chart Layout and Style
- Working with Chart Labels
- Changing the Chart Gridlines
- Changing the Scale
- Emphasizing Data
- Using Chart Templates
- Changing Chart Type
- Using Sparklines
- Creating and Working with Charts Review
- Chapter Six: Managing Workbooks
- Using Workbook Views
- Selecting and Switching Between Worksheets
- Inserting and Deleting Worksheets
- Renaming, Moving, and Copying Worksheets
- Splitting and Freezing a Window
- Creating Headers and Footers
- Hiding Rows, Columns, Worksheets, and Windows
- Setting the Print Area
- Adjusting Page Margins and Orientation
- Adding Print Titles, Gridlines, and Row and Column Headings
- Adjusting Paper Size and Print Scale
- Printing Multiple Worksheets and Workbooks
- Working with Multiple Workbook Windows
- Creating a Template
- Managing Workbooks Review
- Chapter Seven: More Functions and Formulas
- Formulas with Multiple Operators
- Inserting and Editing a Function
- AutoCalculate and Manual Calculation
- Defining Names
- Using and Managing Defined Names
- Displaying and Tracing Formulas
- Understanding Formula Errors
- Using Logical Functions (IF)
- Using Financial Functions (PMT)
- Using Database Functions (DSUM)
- Using Lookup Functions (VLOOKUP)
- User Defined and Compatibility Functions
- Financial Functions
- Date & Time Functions
- Math & Trig Functions
- Statistical Functions
- Lookup & Reference Functions
- Database Functions
- Text Functions
- Logical Functions
- Information Functions
- Engineering and Cube Functions
- More Functions and Formulas Review
- Chapter Eight: Working with Data Ranges
- Sorting by One Column
- Sorting by Colors or Icons
- Sorting by Multiple Columns
- Sorting by a Custom List
- Filtering Data
- Creating a Custom AutoFilter
- Using an Advanced Filter
- Working with Data Ranges Review
- Chapter Nine: Working with Tables
- Creating a Table
- Adding and Removing Data
- Working with the Total Row
- Sorting a Table
- Filtering a Table
- Removing Duplicate Rows of Data
- Formatting the Table
- Using Data Validation
- Summarizing a Table with a PivotTable
- Converting to a Range
- Working with Tables Review
- Chapter Ten: Working with PivotTables
- Creating a PivotTable
- Specifying PivotTable Data
- Changing a PivotTable’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Using Slicers
- Sharing Slicers Between PivotTables
- Working with PivotTables Review
- Chapter Eleven: Analyzing Data
- Creating Scenarios
- Creating a Scenario Report
- Working with Data Tables
- Using Goal Seek
- Using Solver
- Using Text to Columns
- Grouping and Outlining Data
- Using Subtotals
- Consolidating Data by Position or Category
- Consolidating Data Using Formulas
- Analyzing Data Review
- Chapter Twelve: Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
- Working with the Web and External Data Review
- Chapter Thirteen: Working with Macros
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
- Editing a Macro’s Visual Basic Code
- Inserting Copied Code in a Macro
- Declaring Variables and Adding Remarks to VBA Code
- Prompting for User Input
- Using the If…Then…Else Statement
- Working with Macros Review
- Chapter Fourteen: Customizing Excel
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
- Creating a Custom AutoFill List
- Creating a Custom Number Format
- Customizing Excel Review
|
