Discover the course Excel: Intermediate – Advanced Level and take your skills to the next level! These days, mastering Excel is essential in the world of work. With this course, you’ll be able to perfect your use of advanced features and analysis tools, creating striking charts and automating tasks with macros and VBA. Did you know that companies are looking for professionals with these skills? Yes! The sector is booming and the demand for Excel specialists is growing every day. Become an expert in technical data management by improving your efficiency and accuracy. Through practical exercises, you will put your knowledge into practice and enhance your professional profile. This remote, online course gives you the chance to excel in your career – don’t miss out on this opportunity for growth! Sign up now and set yourself up for success!
Excel: Intermediate to Advanced Level
Digital Skills
8 pm
Introduction
Objectives
The course Excel: Intermediate to Advanced Level aims to improve users’ proficiency in Excel advanced features and analysis tools, develop skills to create effective charts, and learn how to automate repetitive tasks using macros and VBA. In addition, students will apply what they have learnt through exercises and case studies, thereby improving its efficiency and accuracy in handling technical specifications.
Table of Contents
TEACHING UNIT 1. FUNCTIONS IN EXCEL
Syntax and usage
Mathematical and trigonometric functions
Statistical functions
Logical functions
Text functions
Date functions
Financial functions
Search and reference functions
Engineering roles
SOLVER
Form controls
Conditional formatting
TEACHING UNIT 2. CHECKING FOR ERRORS AND TROUBLESHOOTING
Types of errors and where they occur
Avoiding errors when entering data
Lists
Messages
TEACHING UNIT 3. OCCUPATIONAL SAFETY
Blade protection
Cell protection
Range protection
Structural protection
File-opening protection
Open as read-only
TEACHING UNIT 4. TABLE FORMAT
Benefits of working with tables
SUBTOTAL and SUM functions
Data segmentation
Advanced filters
TEACHING UNIT 5. GRAPHS
Types of charts
Elements of a graph
Creating a chart
Editing graphics
Calculating regressions and trend lines
TEACHING UNIT 6. PIVOT TABLES
What are pivot tables and how are they created?
Standard calculations
Formatting options
Update
Filtered
Data segmentation, time scale and dynamic charts
Calculated fields
Advanced topics
TEACHING UNIT 7. IMPORTING DATA FROM EXTERNAL SOURCES
Import data from other files
TEACHING UNIT 8. POWER QUERY
Import data
Convert table
Create conditional columns
Attach tables
Cross-referencing tables
TEACHING UNIT 9. MACROS AND AN INTRODUCTION TO VBA
Record macros
Creating macros with VBA
More related courses
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.