MIS Executive / Reporting + VBA

A management information system (MIS) provides information that organizations require to manage themselves efficiently and effectively.

Management information systems are typically computer systems used for managing.

Topics Covered

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

Advanced Contents
? NAME MANAGER
? VLOOKUP
? MATCH VLOOKUP
? MATCH INDEX
? =SUMIFS()
? DATA TABLES
? DATA – WHAT IF ANALYSIS
? SPLITTING TEXT STRINGS
? FIND AND REMOVE DUPLICATES ( =COUNTIF()
? DATA CONSOLIDATION
Archon Tech Solutions
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)

Who should attend

Any Graduate / Working Professional

Pre-requisites

Should have basic knowledge of computers

What you need to bring

Book and a Pen

Key Takeaways

Expert in Excel and VBA Macros