Advanced Excel & MIS

Name: Advanced Excel & MIS
Availability: InStock

by L&D Edutech Claim Listing

Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications.

Contact the Institutes

Fill this form

Duration

Please Enquire

Course Details

What You'll Learn:

? Good understanding of Excel at MIS level
? Expertise in Text Function
? Expertise in Logical Function
? Expertise in Math Function
? Expertise in Lookup and Reference Function
? Expertise in Date and Time Function
? Mastery in Pivot Table and Chart Preparation
? Mastery in ‘What if Analysis’ tools
? Print Option in Excel
? Data Validation, Filter and Conditional Formatting
? Mastery in Data organising Tools in Excel
? Mastery in Data creation and Data Manipulation in Excel
? Managing data protection and data sharing in Excel
? Work with Macro Recording

Content:

Introduction
? An overview of the screen, navigation and basic spreadsheet concepts
? Various selection techniques
? Shortcut Keys
Customizing Excel
? Customizing the Ribbon
? Using and Customizing AutoCorrect
? Changing Excel’s Default Options
Using Basic Functions
? Using Functions – Sum, Average, Max,Min, Count, Counta
? Absolute, Mixed and Relative Referencing
Formatting And Proofing
? Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
? Basic conditional formatting
MATHEMATICAL FUNCTIONS
? SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs
PROTECTING EXCEL
? File Level Protection
? Workbook, Worksheet Protection
TEXT FUNCTIONS
? Upper, Lower, Proper
? Left, Mid, Right
? Trim, Len, Exact
? Concatenate
? Find, Substitute
DATE AND TIME FUNCTIONS
? Today, Now
? Day, Month, Year
? Date, Date if, DateAdd
? EOMonth, Weekday
ADVANCED PASTE SPECIAL TECHNIQUES
? Paste Formulas, Paste Formats
? Paste Validations
? Transpose Tables
New in Excel 2013 / 2016 & 365
? New Charts – Tree map & Waterfall
? Sunburst, Box and whisker Charts
? Combo Charts – Secondary Axis
? Adding Slicers Tool in Pivot & Tables
? Using Power Map and Power View
? Forecast Sheet
? Sparklines -Line, Column & Win/ Loss
? Using 3-D Map
? New Controls in Pivot Table – Field, Items and Sets
? Various Time Lines in Pivot Table
? Auto complete a data range and list
? Quick Analysis Tool
? Smart Lookup and manage Store
Sorting and FILTERING
? Paste Formulas, Paste Formats
? Paste Validations
? Transpose Tables
PRINTING WORKBOOKS
? Setting Up Print Area
? Customizing Headers & Footers
? Designing the structure of a template
? Print Titles –Repeat Rows / Columns
WHAT IF ANALYSIS
? Goal Seek
? Scenario Analysis
? Data Tables (PMT Function)
? Solver Tool
LOGICAL FUNCTIONS
? Goal Seek
? Scenario Analysis
? Data Tables (PMT Function)
? Solver Tool
DATA VALIDATION
? Number, Date & Time Validation
? Text and List Validation
? Custom validations based on formula for a cell
? Dynamic Dropdown List Creation using Data Validation – Dependency List
LOOKUP FUNCTIONS
? Vlookup / HLookup
? Index and Match
? Creating Smooth User Interface Using Lookup
? Nested VLookup
? Reverse Lookup using Choose Function
? Worksheet linking using Indirect
? Vlookup with Helper Column
PIVOT TABLES
? Creating Simple Pivot Tables
? Basic and Advanced Value Field Setting
? Classic Pivot table
? Grouping based on numbers and Dates
? Calculated Field & Calculated Items
Arrays Functions
? What are the Array Formulas, Use of the Array Formulas?
? Basic Examples of Arrays (Using ctrl+shift+enter).
? Array with if, len and mid functions formulas.
? Array with Lookup functions.
? Advanced Use of formulas with Array.
CHARTS and slicers
? Various Charts i.e. Bar Charts / Pie Charts / Line Charts
? Using SLICERS, Filter data with Slicers
? Manage Primary and Secondary Axis
EXCEL DASHBOARD
? Planning a Dashboard
? Adding Tables and Charts to Dashboard
? Adding Dynamic Contents to Dashboard
Introduction to VBA
? What Is VBA?
? What Can You Do with VBA?
? Recording a Macro
? Procedure and functions in VBA
Variables in VBA
? What is Variables?
? Using Non-Declared Variables
? Variable Data Types
? Using Const variables
MessageBox and INPUTBOX FUNCTIONS
? Customizing Msgboxes and Inputbox
? Reading Cell Values into Messages
? Various Button Groups in VBA
If and select statements
? Simple If Statements
? The Elseif Statements
? Defining select case statements
Looping in VBA
? Introduction to Loops and its Types
? The Basic Do and For Loop
? Exiting from a Loop
? Advanced Loop Examples
Mail Functions – VBA
? Using Outlook Namespace
? Send automated mail
? Outlook Configurations, MAPI
Worksheet / Workbook Operations
? Merge Worksheets using Macro
? Merge multiple excel files into one sheet
? Split worksheets using VBA filters
? Worksheet copiers

We at L&D Edutech are driven by Passion, passion for excellence in education, passion for excellence in customer service, passion for excellence in whatever we do.

We are a team of individual having more than 2 decade of combined experience in the field of vocational training. We have built our career ground up and understand the aspiration value of students who come to us for career building and / or career enhancement.

Our courses are refined with years of experience that we have gained over the years and tailored them keeping the current job market trends.

We understand that for learning, a conducive environment is required and hence our centre is designed keeping in mind the latest infrastructure and aesthetic ambiance.

View Detailed Profile

Thane Branch

Office No.201 & 207, 2nd Floor, Krishna Plaza, Thane

Check out more MS Excel courses in India

MS Access Course

MS Access course is offered by IRS Computers. IRS good will is reinforced and spread by thousands of its students who have come here as novices and passed out as competent IT Professionals.

by IRS Computers [Claim Listing ]

Price Inquire Now
Start Date Inquire Now
Duration 1 Month

read more course details

MIS & Advanced Excel Course

Unlock the potential of data mastery with our Best MIS & Advanced Excel Course in Bareilly, available both online and offline. Dive into a transformative learning experience where theoretical knowledge seamlessly blends with hands-on application.

by Dizital Mantras [Claim Listing ]

Price Inquire Now
Start Date Inquire Now
Duration 2 Months

read more course details

Advance Excel Training Course

The Advanced Excel Training Program Course covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel.

by Career Planet Computer Education [Claim Listing ]

Price ₹5500
Start Date Inquire Now
Duration 120 Hours

read more course details

Microsoft Office

Microsoft Office course is offered by GK Computers.Microsoft Office suite is application software's packaged with one bundle. Word, Excel, PowerPoint, Access, etc.

by GK Computers [Claim Listing ]

Price Inquire Now
Start Date Inquire Now
Duration Please Enquire

read more course details

Microsoft Power Point

PowerPoint (PPT) is a powerful, easy to use presentation graphics software tool that allows you to create professional looking slide shows. It gives you everything you need to produce a professional looking presentation.

by MARS Training & Solutions [Claim Listing ]

Price Inquire Now
Start Date Inquire Now
Duration 1 Day

read more course details

Show Me All Similar Courses

Advanced Excel & MIS

Contact the Institutes

Advertisement

Duration

Course Details

Thane Branch

Check out more MS Excel courses in India

MS Access Course

MIS & Advanced Excel Course

Advance Excel Training Course

Microsoft Office

Microsoft Power Point

Courses

Quick Links