• MS-Excel (Advanced)

Advanced MS - Excel With MIS Reporting

MIS Reporting and Analysis Training - Complete Basic to Expert level Excel and Reporting 

  • 10 - 20 weeks
  • 102 Lectures
  • 2365 Student Enrolled
4.7
  • Offer by ATTITUDE ACADEMY
  • Last updated:- Feb 20, 2024
7.jpg
Actual Price

₹999.00 92% Off

Course Features
  • Online Interactive Learning Sessions
  • Practical Videos For Covering Course
  • Complete eBook with Assignments
  • Online Offline Assessments
  • Course Related Blogs & Articles
  • 100% Job Assistance
  • Access on All Device
  • 24*7 Lifetime Access
  • ISO 9001 : 2008 Company
  • Internship Programme for Learners
  • Govt. Recognized Certificate
  • One of the Finest Education Brand in India

What you'll learn

  • Fundamentals of MS Excel
  • Excel shortcuts
  • Conditional formatting
  • Data validation
  • In-depth understanding of various functions of MS Excel 
  • Maintain large sets of Excel data in a list or table
  • Formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables

 

Requirements

Computer/Laptops. That all.

What placement assistance will you receive?

Free Placement Preparation Training

Access to curated Internships & Current Job Openings.

Top performers will be highlighted on Attitude Job portal

Requirements

MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros This application performs very effectively on arithmetic solution

Course Circullum

  • Complex mathematical and statistical functions
  • Logical functions for data validation and analysis
  • Text and date functions for data manipulation
  • Nested and array functions for advanced calculations
  • Data validation rules and criteria
  • Creating custom data validation rules
  • Protecting worksheets and workbooks
  • Workbook-level protection and governance best practices
  • Advanced PivotTable techniques for data analysis
  • Creating calculated fields and calculated items
  • Slicers, timelines, and filters for interactive analysis
  • Using Power Query for data transformation and integration
  • Creating advanced charts (e.g., waterfall, Pareto, radar)
  • Using Sparklines for data trends and mini-charts
  • Dynamic charts and data visualization techniques
  • Dashboard design and layout best practices
  • Consolidating data from multiple worksheets or workbooks
  • Performing What-If analysis with Data Tables
  • Scenario Manager for decision-making scenarios
  • Goal Seek and Solver for advanced analysis
  • LOOKUP and reference functions (e.g., VLOOKUP, HLOOKUP)
  • Financial functions for analysis
  • Engineering functions for specialized calculations
  • Advanced text and information functions
  • Introduction to Excel macros and VBA
  • Recording, editing, and running macros
  • Automating tasks with VBA (Visual Basic for Applications)
  • Macro security and best practices
  • Creating drop-down lists and combo boxes
  • Form controls and ActiveX controls for interactive dashboards
  • Building user-friendly interfaces with buttons
  • Incorporating user interactivity into MIS reports
  • Importing data from external sources (e.g., databases, web)
  • Using Power Query for data transformation and integration
  • Connecting to databases and APIs for real-time data retrieval
  • Refreshing external data connections for up-to-date reports
  • Page setup, printing options, and custom headers/footers
  • Creating advanced reports with custom headers and footers
  • Exporting reports to other formats (e.g., PDF, CSV)
  • Preparing MIS reports for professional presentation
  • Advanced data analysis techniques using Excel
  • Interactive data visualization with PivotCharts and slicers
  • Incorporating advanced data analysis tools (e.g., regression analysis)
  • Best practices for data analytics in Excel
  • Real-world MIS reporting and data analytics case studies
  • Building complex MIS reports and analytical models from scratch
  • Presenting and sharing MIS reports and data analytics findings
  • Project-based learning and real-world applications
  • Review of key takeaways and skills acquired
  • Opportunities for further learning and career prospects in MIS reporting and data analytics
  • Preparing for advanced Excel and data analytics certifications
  •  Understanding the role of Excel in MIS reporting and data analytics
  • Key concepts and terminologies in reporting and analytics
  • Setting up an Excel environment for advanced tasks  

Take the final exam online to complete the Advanced MS - Excel With MIS Reporting after which you will be able to download your certificate from Attitude Trainings.

attitude-certificate

How will your training work?

Thought

Classes

Watch recorded & live videos to learn various concepts & get Live Sessions with Trainer for Doubts Clearing.

Planning

Exams

Test your knowledge through quizzes & module tests. Take online exam & get instant result.

Implement

Projects

Get hands on practice by doing assignments and live project

Result

Certificate

Take the final exam to get certified in Advanced MS - Excel With MIS Reporting