
Understanding Excel Structure, its header section and few important technical jargon. Also in the resource there is zip file. Download that file and you will find all the practice file, which will be required during this training.
Cell properties describes that what all the things are possible in MS Excel cell /Range.
Autofill advanced tools show how to use fill series, set step values, and apply justify to format text and split data into separate cells.
Explore Flash Fill in Excel and learn how to automatically extract names, phone numbers, and concatenate data using suggestions and keyboard shortcuts to speed up data cleaning.
Master Excel operators and build equation-based calculations, including addition, subtraction, multiplication, division, power, percentage, and concatenation, with focus on order of operations and logical tests.
Apply text functions such as upper, lower, proper, and trim to format cell text. Learn how these functions remove extra spaces, correct capitalization, and convert text cases using examples.
Learn how to use the concatenate and text functions to join text, extract elements, and prepend initials to a phone number.
Master the text and concatenate functions in Excel by combining left and right text manipulations to format phone numbers and assemble task solutions.
Explore the concat and textjoin functions as improved alternatives to concatenate for combining ranges with delimiters. Learn how textjoin handles spaces, commas, and ignoring empty cells to produce clean results.
Learn to use the text function in Excel to perform replace and find operations, including nested functions, to extract and replace starting numbers such as bingo numbers.
Explore essential text functions in Excel, including Len, Rep, Exact, and Search, to measure text length, repeat text, compare for exact matches, and locate patterns.
Protect the workbook to lock its structure and sheet changes with a password, preventing adding, deleting, renaming, or hiding sheets; unprotect with the password to make edits.
Protect a worksheet by setting a password, choose allowed actions, and use review > protect sheet to enforce restrictions and manage editable ranges.
Learn how the if function performs a logical test using operators (>, <, =, ≠) to return values like pass or fail, and calculate scholarships for scores above 70.
Use the Excel if function to determine scholarship eligibility and compute the amount: if score is below 70, no scholarship; otherwise (score minus 70) times 1000.
Learn how to build nested if statements in Excel to classify scores using conditions like less than 40 or 60, and return the top score while keeping others blank.
The updated IFS function in Excel replaces nested ifs with multiple logical tests for scores below 40, between 40 and 60, and above 60, evaluated by the first true test.
Learn to apply the max function in Excel with absolute references to prevent range shifts when dragging, and compare it with the min function to identify the lowest value.
Explore how to use and and or with the Excel IF function to evaluate two logical conditions and determine pass or fail based on score thresholds.
Explore how to create defined names for ranges, set scope to sheet or workbook, manage names via the name manager, and use them in formulas and navigation.
Explore how to create and use hyperlinks in Excel to navigate between sheets, link to named ranges, websites, other files, emails, and even create new documents within the workbook.
Learn to group and ungroup data in Excel, create subtotals for a chosen field such as city or region, and use collapse and expand to manage three levels of grouping.
Learn to set date and time in Excel by matching your system's format (US or Indian) and typing dates correctly. Adjust regional settings in control panel to prevent misinterpretation.
Learn to extract day, month, and year, convert serial numbers to dates and times, and use today and now for date and time calculations.
Explore how to use the networkdays function to count work days between dates, with optional holidays and customizable weekends via networkdays.intl.
Master the datedif function to compute age from birth date to today, returning years, months, and days with start date, end date, and y, m, d parameters.
Explore pivot table techniques in Excel, focusing on value fields, region-based totals, and transaction analysis, with how to refresh data and adjust settings to build reports.
Explore pivot tables with slicers to filter data, apply ascending or descending sorting, and arrange fields to build focused dashboards.
Practice file is available in Resources
Master goal seek in Excel to hit a target profit by adjusting sales or costs, selecting the changing cell and goal value, and exploring simple to complex scenarios.
Learn to use Excel's scenario manager to create and compare high cost, low cost, and average cost what-if scenarios, save them, and view a summary of results across sheets.
Create a loan table in Excel using data table and what-if analysis to calculate emi and total interest, adjust loan terms, and customize headings and formats.
Learn to create and customize charts in Excel, from selecting data and choosing a column chart to configuring horizontal and vertical axis titles, the legend, data labels, and formatting options.
Learn how to customize chart options by selecting data sources, editing titles, and adjusting fields, including applying joins and filtering to tailor sales reports.
Explore how to create 2D and 3D maps in Excel Power Map, visualize sales data with field maps, customize styles, and export animated maps as videos with specified resolutions.
Discover how to apply filters in Excel to extract candidates by qualification and location, or by text patterns, including advanced filters, top or bottom percent, and above or below average.
Sort data efficiently by name alphabetically with A to Z, then apply ascending or descending order, and use custom sort with a custom list to prioritize values.
Master the indirect function in Excel, exploring dynamic value retrieval from references and named ranges. See how Ctrl+Shift+Enter returns an array of values from a named five cell range.
Create dynamic dependent drop-down lists in Excel using data validation, named ranges, and the indirect function to populate department and corresponding employee names.
Explore how to use wildcards in Excel formulas to filter data, focusing on names starting with a letter and matching specific character lengths using * and ? in criteria.
Demonstrate how to nest if with vlookup to handle no matches and zeros, display blanks, and reuse an existing formula by copying and applying conditional outputs.
Master the offset function in Excel to build dynamic reports. Learn to set a reference cell, adjust rows and columns, and use height and width with sum, count, and average.
Demonstrate how to record a macro in Excel, assign shortcuts, and save the macro in a workbook, then review the VBA code to automate formatting tasks.
Record a macro to automate opening the expense report template, assign a shortcut, and learn several ways to run macros to simplify end-user tasks.
Explore different ways to run macros in Excel by assigning them to shapes and adding macro options to the ribbon, enabling quick access across sheets and workbooks.
Learn the basics of Microsoft Access as a database application, creating tables, forms, queries, and reports, and handling data export and import, table relationships, and SQL basics.
Create a report in Access by selecting the table, choosing the fields (films) to present, setting the layout to landscape or portrait, then review and print.
Explore how to fetch information from a database using basic SQL queries, including selecting columns, viewing tables, and applying DISTINCT, WHERE, and ORDER BY clauses.
Distinguish between selection and the active cell, and learn to select multiple cell ranges in Excel using ranges and tools like range master, with examples from 8 to 174.
Learn to format Excel selections with VBA by applying colors via RGB and alignment (left, right, center) using active cell techniques and macros.
Discover how to use the end command in VBA to reach the end of data, navigate with control down, and manipulate ranges with offset and select in Excel.
Learn to automate data entry in Excel by creating a macro that prompts for age and salary, fills the corresponding cells, and auto-increments serial numbers.
Explore how to build a VBA-driven Excel workflow that prompts for name and age, stores inputs in variables, auto-increments a serial number, and uses offset to populate cells.
Learn how to refer to sheets in a workbook by name or index number for use in formulas. Explore the differences between sheet name references and index-based references across sheets.
Demonstrates a macro that prompts for a new sheet name, creates the sheet as the last in the workbook, and clears the last sheet.
The lecture demonstrates methods to refer to workbooks in Excel, including using workbook references and activating specific workbooks during code execution.
Explore methods related to workbook management, including creating new workbooks, naming them, saving changes, working with sheet properties, and closing files in Excel.
Learn how to declare variables in programming with option explicit, define name and age inputs, prevent undefined variables, and debug type mismatches to ensure reliable code.
Use a macro linked to a button to create new sheets in the workbook, demonstrating how to manage multiple sheets beyond the initial set.
Learn how to replace complex if statements with a select case in programming, using a scores variable and simple functions to handle conditional logic.
Understand how loops drive macros by repeating actions until a stopping condition is met. Learn to prevent infinite loops and control execution line by line during macro tasks.
Learn loop related task solutions in Excel, reading a sheet, selecting and sorting data, applying conditional checks (value under 40) with offset indexing, and iterating downward to control activation.
Discover the do while loop, its execution based on a condition, and how operators like not equal are used to control iterations, with pros and cons.
Explore a loop related task of applying color based on value thresholds across the entire dataset, with rules for less than 20, 30–60, and greater than 65.
Develop a loop related project in Excel using macros to select ranges, apply offsets, copy data between sheets, activate targets, and update results with dynamic messages.
Learn how to work with events in Excel using macros and VBA, including workbook opening and before-close events, creating event handlers, prompts via message boxes, and conditional sheet actions.
Explore how to implement a right-click event that prompts for a password, validate input against a stored value, and display a wrong password message for incorrect attempts.
Create your own VBA functions in Excel to extend capabilities, name them, and accept parameters to format dates, convert strings to dates, and calculate age.
Create a user form by inserting the form, configuring labels, text boxes, combo boxes, frames, and buttons, then wire controls with VBA code to populate and manage data.
Learn to create a pivot table with VBA in Excel by building a macro that defines the data source and cache, creates a sheet, and runs to generate the pivot.
Use the file system object in VBA to create folders, copy files, and manage overwrites with the Microsoft scripting runtime, while handling paths and extensions.
A Management Information System (MIS) provides organizations with the information they require in an organized manner to support management and crucial business decisions. MIS tools and knowledge are very important in today's workplace. There is a high demand for skilled MIS Professionals in the market because the skill sets required to work effectively in MIS are often not covered as part of any academic curriculum. Professional training in MIS therefore becomes highly valuable.
This training will equip you with the skill sets required to become a successful MIS professional. Our course curriculum covers the important aspects required in the real world to get the job done in MIS. You will develop practical knowledge in Data Management, Reporting and Analysis using MS Excel, MS Access and RDBMS/SQL, along with Excel VBA/Macro Automation, Office Scripts and AI-assisted Excel automation.
The course also introduces you to modern Excel automation techniques, including the use of Office Scripts and AI tools such as ChatGPT and Copilot to create, understand and improve automation solutions. These skills will help you automate repetitive Excel tasks, simplify reporting processes and work more efficiently with real-world data.
MIS Training involves "Learning by Doing" through practical projects, hands-on exercises and real-world simulations. This extensive hands-on experience ensures that you absorb the knowledge and develop the practical skills required to apply what you learn directly at work.
From Excel and advanced reporting to VBA, Office Scripts, AI-assisted automation, Access and SQL, this course is designed to give you a complete practical foundation for working as an MIS professional.
So, what are you waiting for? Enroll now and take the next step towards mastering MIS and modern Excel automation.