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