Microsoft Advanced Excel

Teacher

admin

Course Overview:

The Microsoft Advanced Excel Mastery course is designed to take your Excel skills to the next level and empower you to become an expert user of this powerful spreadsheet application. This comprehensive course will delve into the advanced features and functionalities of Microsoft Excel, enabling you to handle complex data analysis, automate repetitive tasks, and create sophisticated reports with ease. Whether you are a business professional, data analyst, finance expert, or simply an Excel enthusiast, this course will equip you with the tools and techniques to make the most of Excel’s advanced capabilities. Enroll to Excel Training Cyprus.

Prerequisites: To enroll in this course, participants should have a solid understanding of the fundamental concepts and basic functionalities of Microsoft Excel. Familiarity with formulas, functions, formatting, and basic data manipulation is essential.

Course Objectives:

By the end of this course, participants will:

Master Advanced Formulas and Functions: Learn to use a wide range of advanced Excel functions, including logical, lookup, text, date, and statistical functions. Understand complex formula structures and leverage nested functions for dynamic data analysis.
Data Analysis Techniques: Explore powerful data analysis tools, such as PivotTables, PivotCharts, and Data Tables, to gain insights from vast datasets quickly. Understand how to use filters, slicers, and timelines to manipulate data interactively.
Data Validation and Cleaning: Implement data validation rules to maintain data integrity. Learn how to clean and transform raw data into usable formats using various techniques like text-to-columns, Flash Fill, and Power Query.
Advanced Charting and Visualization: Create visually stunning charts, graphs, and interactive dashboards to present data effectively. Learn to customize chart elements, use sparklines, and create dynamic visualizations.
What-If Analysis and Scenario Manager: Understand the concept of What-If analysis and explore Scenario Manager to evaluate different scenarios by changing multiple input values.
Solver Tool: Learn how to use Excel’s Solver add-in to find optimal solutions for problems with multiple constraints and variables.
Collaborative Features: Explore collaboration features like Track Changes, Comments, and Shared Workbooks to facilitate teamwork and version control.
Importing and Exporting Data: Discover various methods to import data into Excel from external sources and export Excel data to other formats like CSV, PDF, and text files.
Excel Data Model and Power Pivot: Introduction to the Excel Data Model and Power Pivot for enhanced data analysis and creating relationships between multiple datasets.

Course Format: The Microsoft Advanced Excel Mastery course will be delivered through a combination of instructor-led lectures, hands-on exercises, real-world projects, and interactive discussions. Participants will have access to practice datasets, templates, and sample files to reinforce their learning.

Course Curiculum

Course Curriculum: Microsoft Advanced Excel Mastery

Mastering Advanced Formulas and Functions
- Advanced mathematical and statistical functions
- Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
- Text manipulation functions: CONCATENATE, TEXTJOIN, SUBSTITUTE
- Logical functions: IF, AND, OR, NOT
- Date and time functions: DATE, EOMONTH, NETWORKDAYS
Data Analysis Techniques
- PivotTables and PivotCharts: Creating, customizing, and analyzing data
- Using Slicers, Timelines, and Filters for interactive data manipulation
- Working with external data sources: Importing data from databases and other formats
Advanced Charting and Visualization
- Creating advanced charts: Combo charts, waterfall charts, and histograms
- Using sparklines to display trends and variations
- Customizing chart elements and formatting options
What-If Analysis and Scenario Manager
- Using Goal Seek to find the input needed to achieve a desired result
- Data tables for exploring multiple input values
- Scenario Manager for managing different scenarios
Data Validation and Cleaning
- Setting data validation rules to ensure data integrity
- Cleaning and transforming data using Text-to-Columns and Flash Fill
Excel Data Model and Power Pivot
- Understanding the Excel Data Model and relationships
- Working with Power Pivot: creating calculated columns and measures
Collaborative Features and Data Sharing
- Track Changes and Comments for collaboration
- Sharing workbooks and controlling access

Advanced Excel

Location: Live Online Training

Initial Price: ~~€550~~

Funding Information: HRDA funds up to 80% of the course fees. Therefore, your company will only pay the amount: €130 *No VAT is charged as SCP’s Funded courses are excluded from it.

Individual (Non-funded)

For a person not eligible for the subsidy, we offer a discounted price of €340 inc VAT (installments accepted x2 or x 3).

Questions? Contact us 70008828 or 96828323

Duration: 21 hours (21 CPDs)

+ Online participation in all modules of first-class training
+ Personal Certificate by SCP and Approved by Cyprus HRDA at the end of the course
+ Connection to workplace
+ Possibility for Internship in well know companies

Enroll Now

Feedback

Rafael Pourgourides

Support Engineer - XM

“In every course I attended, they all helped and made sure that I was going to get where I needed to go,”. “From the director all the way to the teachers, they all want you to succeed.”

Andreas Petrou

Andreas Petrou IT Administrator EKA Group

I couldn’t imagine how much attending the Ethical Hacking course at SCP Academy would help me in my career. After that I asked for more and I knew who could help me. Having also completed the Java and WordPress courses I want to say that learning never stops and this is what SCP Academy has taught me.

Marios Zindilis

System Administrator at Amazon

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

System Engineer at Tototheo Group

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

IT Officer at Bernhard Schulte Shipmanagement

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

Systems/Network Engineer at Zambartas Law Office

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

Digital web designer/Marketing iGaming company- Malta

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.