+ View more
Course overview
The "Special MS. Excel Training" is an
intermediate-level Excel course designed for in-service employees from various
organizations who already have fair knowledge of Microsoft Excel. The course
aims to enhance participants' skills and proficiency in using Excel for data
analysis, advanced calculations, and data visualization. The training duration
is 2 weeks, with classes held every day, five days a week.
Learning Objectives and Expected Outcomes:
By the end of the course, participants are expected to:
- Expand their knowledge and understanding of Microsoft Excel.
- Develop advanced skills in data analysis, manipulation, and
reporting.
- Gain proficiency in using advanced Excel functions and formulas.
- Explore techniques for data visualization and creating impactful
charts and graphs.
- Learn time-saving tips and shortcuts to improve efficiency in Excel.
- Understand best practices for data organization, cleaning, and
management in Excel.
What will i learn?
- Data Analysis Techniques
- • Introduction to advanced data analysis tools in Excel
- • PivotTables and PivotCharts for data summarization and analysis
- • Filtering and sorting data, using advanced filtering options
- Advanced Formulas and Functions
- • Exploring advanced formulas and functions in Excel
- • Array formulas and their applications
- • Lookup and reference functions for data retrieval
- Data Validation and Protection
- • Implementing data validation rules to maintain data integrity
- • Protecting worksheets and workbooks with passwords and permissions
- • Conditional formatting for highlighting data based on specific criteria
- Advanced Data Visualization
- • Creating impactful charts and graphs in Excel
- • Customizing chart elements and formatting options
- • Sparklines and conditional formatting for visualizing trends
- Efficiency Tips and Shortcuts
- • Time-saving techniques and shortcuts for efficient Excel usage
- • Keyboard shortcuts and productivity features
- • Customizing the Excel interface for personalized workflows
- Advanced Data Analysis Functions
- • Advanced statistical functions for data analysis
- • Scenario Manager and Goal Seek for what-if analysis
- • Solver add-in for optimization problems
- Power Query and Data Cleansing
- • Introduction to Power Query for data transformation and cleansing
- • Importing and transforming external data sources
- • Data cleaning techniques and removing duplicates
- Collaboration and Sharing
- • Collaborating on workbooks with multiple users
- • Tracking changes and comments
- • Sharing workbooks via email or cloud platforms
- Advanced Functions and Formulas
- • Advanced lookup functions (INDEX-MATCH, VLOOKUP)
- • Text functions and string manipulation
- • Financial and mathematical functions
- Final Projects and Recap
- • Undertaking a practical project to apply learned skills
- • Recap of key topics and Q&A session
- • Course evaluation and certificates of completion
Curriculum for this course
0 Lessons
00:00:00 Hours
+ View more
Other related courses
00:00:00 Hours
Updated Wed, 12-Jul-2023
0
TSh400000
TSh160000
00:00:00 Hours
Updated Mon, 07-Aug-2023
0
TSh400000
TSh150000
About instructor
Revocatus Balthazar
SENIOR CONSULTANT
Big Data Analytics Software Development Accounting Advanced Excel Advanced Word Advanced PowerPoint Power Query Power Pivot Power BI Visual Basics For Applications Financial Modeling and Financial Analyst Economics...
Student feedback
Write a public review