Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

MIS Executive / Reporting + VBA

No Reviews Yet

Indiranagar, Bangalore

Course ID: 24229

Indiranagar, Bangalore

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

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

? 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
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


Should have basic knowledge of computers

What you need to bring

Book and a Pen

Key Takeaways

Expert in Excel and VBA Macros

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

8 Reviews

9 Students

6 Courses


Expert in MIS

Having 5+ years of experience in Training MIS.


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Post your requirement now


Submit your enquiry for MIS Executive / Reporting + VBA

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Archon Tech Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more