Client Login

MICROSOFT EXCEL

    WHAT IS EXCEL?
  • Using Excel as a Spreadsheet
  • Using Excel as a Database
  • Analyzing Data
    EXCEL ENVIRONMENT
  • Working with the Excel window
  • Using the Formula Bar
  • Using the Task Pane
  • Using the New Workbook Pane
  • Using the Clipboard Pane
  • Using the Basic Search Pane
  • Using the Insert Clip Art Pane
  • Using the Status Bar
  • Exiting Excel
    TOOLBARS
  • Using Toolbars
  • Showing a Toolbar
  • Hiding a Toolbar
  • Moving a Toolbar
  • Using the Standard Toolbar
  • Using the Formatting Toolbar
    WORKBOOKS AND WORKSHEETS
  • CREATING AND OPENING WORKBOOKS
  • Creating a new Workbook
  • Creating a new Workbook using a template
  • Opening an existing Workbook
    WORKING WITH WORKBOOKS
  • Understanding Workbooks and Worksheets
  • Minimizing a Workbook
  • Saving Workbooks
  • Saving a backup copy
  • Saving Summary Information
  • Closing Workbooks
    WORKING WITH WORKSHEETS
  • Zooming the Worksheet View
  • Renaming Worksheets
  • Changing the Sheet Tab color
  • Inserting Worksheets
  • Reordering Worksheets
  • Deleting Worksheets
  • Customizing Worksheet Views
    WORKING WITH CELLS
  • Understanding Cells and Ranges
  • Understanding the Active Cell
    ENTERING DATA
  • Entering text
  • Entering numbers as numeric values
  • Entering numbers as text
  • Entering dates
  • Entering current date
  • Entering current time
  • Customizing the movement of the Active Cell
  • Entering data into a range of cells
  • Filling a range of cells with the same data
    CHECKING THE SPELLING
  • Checking spelling in a Worksheet
  • Correcting spelling errors
    SELECTING ITEMS IN EXCEL
  • Selecting a Cell
  • Selecting a Row
  • Selecting a Column
  • Selecting a Range
  • Selecting a non-contiguous Range
  • Selecting an entire Worksheet
  • Selecting several Worksheets
  • Selecting all Worksheets
    FORMATTING TEXT
  • Changing the Font
  • Changing the Font size
  • Changing the Font style
  • Changing the Underline
  • Changing the Font effects
  • Resetting Font formatting
  • Changing the default Font characteristics of the current Workbook
  • Changing the default Font in new Workbooks
    FORMATTING NUMBERS
  • Formatting numbers using the Formatting Toolbar
  • Applying the Currency Format
  • Applying the Percent Format
  • Applying the Number Format
  • Applying custom formatting
  • Setting a fixed decimal places for numeric values
    MANIPULATING DATA
  • Aligning data horizontally within a cell
  • Aligning data vertically within a cell
  • Centering headings over multiple columns
  • Wrap multiple lines of data in a cell
  • Indenting data within a cell
  • Changing the text orientation
    USING AUTOFORMAT
  • Using AutoFormat
    CUTTING, COPYING, AND PASTING
  • Cutting data
  • Copying data
  • Pasting data
  • Inserting copied Cells
  • Copying multiple items to the Office Clipboard
  • Pasting items from the Office Clipboard
  • Deleting items from the Office Clipboard
  • Copying data by dragging and dropping
  • Copying data over several cells
  • Copying an object to another Worksheet location
    INSERTING AND DELETING
  • Inserting Rows
  • Inserting Columns
  • Inserting Cells
  • Deleting Rows or Columns
  • Deleting the contents of a Cell or Range
  • Deleting data without deleting the cell formatting
  • Removing cell formatting without deleting the data
  • Deleting Cells
  • Deleting Objects
    USING FIND AND REPLACE
  • Searching for text or numbers
  • Replacing text or numbers
    USING UNDO AND REDO
  • Undoing the last action
  • Undoing multiple actions
  • Redoing the last Undo
  • Redoing multiple Undos
    ENTERING FORMULAS
  • Understanding a Formula
  • Using the Formula toolbar
  • Entering a Formula
  • Entering a Cell or Range reference
  • Using relative and absolute Cell references
  • Editing Formulas
    USING PAGE SETUP
  • Changing page orientation
  • Setting the scale of the page
  • Setting paper size
  • Setting print quality
  • Beginning page numbering with a different number
    MARGINS
  • Changing the Margins
  • Changing the Header and Footer Margins
  • Changing the Margins in Print Preview
  • Centering the data on a page
    PRINTING A SPREADSHEET
  • Setting the print area using Print Area
  • Setting the print area using Page Setup
  • Printing Row or Column titles on every page
  • Selecting elements to print
  • Previewing a Worksheet
  • Setting the order pages are printed
  • Printing a Workbook