About This Course
The Data Analysis using Advanced Excel course is designed for professionals who want to move beyond basic spreadsheets and use Excel as a powerful data analysis and decision-making tool. Participants will learn advanced formulas, data transformation techniques, statistical analysis methods, dashboards, pivot tables, and data visualization tools that enable them to analyze large datasets efficiently and generate actionable business insights. Through practical exercises and real-world examples, learners will develop the skills needed to perform advanced analysis and reporting using Microsoft Excel.
Advanced Excel Skills
Master advanced Excel functions, formulas, and tools used for professional data analysis.
Data Analysis
Learn how to clean, transform, organize, and analyze data to uncover valuable insights.
Dashboards & Reporting
Create interactive dashboards, charts, and reports for effective decision-making.
Statistical Techniques
Apply statistical methods and forecasting tools to support business analysis.
Course Curriculum
• Excel Keyboard Shortcuts
• Range Naming and Management
• Data Validation Lists
• Text to Columns
• Data Reorganization
• Filtering Techniques
• Advanced Search Criteria
• Conditional Formatting
• Advanced Conditional Formatting
• Automatic Cell Filling
• Formula Display Options
• Data Formatting Techniques
• IF Statements
• Nested IF Functions
• IFS Function
• Chart Creation
• Chart Formatting
• Formula Combinations
• SUMIF Functions
• SUMIFS Functions
• COUNTIF Functions
• COUNTIFS Functions
• XLOOKUP
• XMATCH
• Advanced Calculations
• Standard Deviation
• Variance Analysis
• DATE Functions
• INDIRECT Function
• DATEVALUE Function
• IFNA Function
• TEXT Function
• LEFT, MID and RIGHT Functions
• Excel Add-Ins
• Solver Tool
• Moving Average Analysis
• Descriptive Statistics
• Histogram Creation
• Statistical Analysis Exercises
• Data Tables
• What-If Analysis
• Pivot Tables
• Dashboard Creation
• Data Visualization
• Reporting Techniques
Skills You'll Gain
Develop practical skills that can be applied immediately in real-world trading scenarios.
Registration & Pricing
Everything you need to know before enrolling.
Feedback
Marios Zindilis
SCP Academy was the key for me to open new doors in my career, leading me down paths I would never have thought of. Apart from Knowledge I have been taught to value persistence, to be curious and to focus on specific and timely goals, both in career as well as in life.
Marios Kairinos
I attended my first course in 2015 with the dream of becoming an IT professional. I have registered for the MCSA course and since then I have never stop learning. I have completed successfully the Azure and Office 365 courses which helped me find my dream job. Now I can ask for more and I know who can help me take them.
Evagoras Pourgourides
SCP Academy helped me learn more than I could ever imagine. The courses enriched me with knowledge and professional skills that i use in my job
Alexandros Louca
Following my passion for technology was one of the best decisions I ever made. In SCP Academy I have found and attended courses that advanced my career to the next level.
Giota Achilleos
SCP academy was the key for me to step to success. Regarding the knowledge that I gained from the university the academy offered to me more skills to succeed my goals and my dreams. SCP academy has offered to me professional courses that helped me to start my new career in Malta.
Panos Iacovides
It is never too late to make an advancement in your career and SCP Academy has helped me to achieve that. Started with the CCNA R&S Certificate and now moving on to the MCSA Certificate with more to follow. SCP Academy has also taught me that learning is a never ending process and I should make the most of it on a daily basis, making every second count. Did you know there are 86400 seconds in a day? Interesting huh?
Course Features
- Lectures 0
- Quizzes 0
- Duration 60 hours
- Skill level All levels
- Language English
- Students 10
- Assessments Yes
