- MS-Excel (Advanced)
4.7
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
How will your training work?
Classes
Watch recorded & live videos to learn various concepts & get Live Sessions with Trainer for Doubts Clearing.
Exams
Test your knowledge through quizzes & module tests. Take online exam & get instant result.
Projects
Get hands on practice by doing assignments and live project
Certificate
Take the final exam to get certified in Advanced MS - Excel With MIS Reporting