Advanced Excel & MIS

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

L&D Edutech Logo

img Duration

Please Enquire

Course Details

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. The course curriculum is one of the most comprehensive and most advanced.

 

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
  • Thane Branch

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

Check out more MS Excel courses in India

Shree Academy Logo

Excel Training (Advance)

To begin with, Shree Academy is the advanced excel training institute in Rajkot. Therefore, it offers real-time and placement focused Microsoft Excel training in Rajkot. Our Advanced Excel training in Rajkot is designed to help you get placements in the best companies across the country.

by Shree Academy [Claim Listing ]
Kusuma EduTech Logo

MS Excel

MS Excel course is offered by Kusuma EduTech. At Kusumaedutech, we believe that education is the key to unlocking human potential. We strive to create a learning environment that is inclusive, collaborative, and supportive.

by Kusuma EduTech [Claim Listing ]
RTS Computer Education Logo

Advance Excel

Advance Excel course is offered by RTS Computer Education. RTS Computer Education is the ISO 9001:2015 certified and approved center for Computer Training Courses in Guwahati with two centers at Chandmari and Adabari.

by RTS Computer Education [Claim Listing ]
Infratech Academy Logo

Diploma In Office Automation

Diploma in Office Automation is offered by Infratech Academy. Infratech is an authorized training center of Kerala State Rutronix from 2006 onwards. We conduct different govt.approved job oriented courses that are eligible for PSC exams also.

by Infratech Academy [Claim Listing ]
Vision Academy Logo

Advance Excel

The real power of Microsoft Excel lies in the advanced functionality it offers. Having been designated as one of the prerequisites expected from the aspiring candidates aiming to join the industry.

by Vision Academy [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy