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
Cross-cutting
40 hours