Signup as a Tutor

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

Enquire

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.

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 support@urbanpro.com 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 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

Share

course photo

MIS Executive / Reporting + VBA

Indiranagar, Bangalore

7,500

No Reviews Yet
0 Interested

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

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
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Sampat

Expert in MIS


Having 5+ years of experience in Training MIS.
Seats Left-

Students Interested 0

Course Id: 24229