Microsoft Excel Online for beginners by Archon Tech Solutions

Advanced Excel MIS + Advanced Macros (VBA)
The 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
Numeric / Mathematical Formulas
Statistical Formulas
Date / Time Formulas
Lookup / Reference Formulas
Work with the Forms Menu
Sorting, Subtotalling & Filtering Data
Copy & Paste Filtered Records
Using Data Validation
Creating and 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 and 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

Excel VBA
Getting Started in the VB Editor
Writing Your First VBA Macro
What to do When Things Go Wrong (Errors and Debugging)
Buttons, Toolbars and Keyboard Shortcuts
Selecting Cells (Range, Cells, Activecell, End, Offset)
Worksheets, Charts and Sheets
Workbooks
Variables
Object Variables
Message Boxes
Input Boxes
Application.InputBox
With Statements
If Statements
Select Case Statements
Do Until and Do While Loops
For Next Loops
For Each Loops
Creating Functions
Error Handling (On Error, Resume, GoTo)
Event Procedures
User Forms
Files and Folders (FileSystemObjects)
Text Files (FileSystemObjects)
File Dialogs
Arrays
Constants and Enumerations (Const, Enum)