Microsoft Excel Online Training Course

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

BASICS

  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars Entering Values in a Worksheet and Selecting a Cell Range Previewing and Printing a Worksheet Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook

FORMATTING A WORKSHEET

  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page Formatting Fonts & Values
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit Using AutoFill

MANAGING YOUR WORKBOOKS

  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options

EDITING A WORKBOOK

  • Entering Date Values and using AutoComplete Editing, Clearing, and Replacing Cell Contents Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling
  • Finding and Replacing Information Inserting
  • Cell Comments

FORMULAS

  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges

WORKING WITH THE FORMS MENU

  • Sorting, Subtotaling & Filtering Data
  • Copy & Paste Filtered Records
  • Using Data Validation

CREATING & WORKING WITH CHARTS

  • Creating a Chart
  • Moving and Resizing a Chart
  • Formatting and Editing Objects in a Chart
  • Changing a Chart’s Source Data
  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects Mapping
    • Data
  • Modifying a Map

DATA ANALYSIS & PIVOT TABLES

  • Creating a PivotTable
  • Specifying the Data a PivotTable Analyzes
  • Changing a PivotTable’s Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable
  • Updating a PivotTable
  • Formatting and Charting a PivotTable

AUTOMATING TASKS WITH MACROS

  • Recording a Macro
  • Playing a Macro and Assigning a Macro a Shortcut Key Adding a Macro to a Toolbar

WORKING WITH OTHER PROGRAMS

  • Inserting an Excel Worksheet into a Word Document Modifying an Inserted Excel Worksheet
  • Inserting a Linked Excel Chart in a Word Document Inserting a Graphic into a Worksheet

CONTACT US

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.