Microsoft Excel - Level I

This course presents the basic concepts of Microsoft Excel software. Participants may request additional topics to cover during the class. Manuals are provided with exercises to facilitate learning. The following topics are included:
The Excel Application Window: from columns to rows we will cover the significant hotspots on the Excel window o The new ribbon and its various tabs o The Quick Access Toolbar and how to customize o Identifying cells and cell ranges o Status bar and sizing the screen Opening, closing, naming and saving Excel files Selecting cells and cell ranges Editing worksheets o Clearing contents versus deleting o Using the auto commands (autocomplete, autocorrect, etc.) Design formulas o Create simple formulas o Use common Excel functions o Use relative referencing and absolute referencing Moving and Copying data o Use several methods to move data within a worksheet and to other worksheets o Copy data to other worksheets by pasting or dragging data o Copy formulas by dragging Formatting techniques for making the report look professional o Changing the font, centering titles across columns o Using underlines, double-underlines, patterns, and shading o How to handle error messages Create conditional formatting Format columns and rows by sizing, hiding, and protecting Printing a report intactkeeping your columns together If time permits: o Freeze panes o Date functions o Date shortcuts o Sorting and filtering data o Linking to other worksheets