Excel: Intermediate–Advanced Level

Name: Excel: Intermediate to Advanced Level
Brand: Educa PHAROS
SKU: AFO028TXM
Availability: InStock

Cross-cutting

Digital Skills

Duration

8:00 p.m.

PRESENTATION

Check out the course Excel: Intermediate–Advanced Level and take your skills to the next level! These days, mastering Excel is essential in the workplace. With this course, you'll be able to perfect your use of advanced features and analytics tools, creating eye-catching charts and automating tasks with Macros and VBA. Did you know that companies are looking for professionals with these skills? Yes! The industry 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 hands-on exercises, you'll apply your knowledge 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!

Objectives

The Course Excel: Intermediate–Advanced Level aims to improve proficiency in Excel advanced features and analysis tools, develop skills for creating effective charts, and learn how to automate repetitive tasks using macros and VBA. In addition, students will apply what they have learned through exercises and case studies, thereby improving its efficiency and accuracy in handling Technical specifications.

Syllabus

TEACHING UNIT 1. FUNCTIONS IN EXCEL Syntax and usage Mathematical and trigonometric functions Statistical functions Logical functions Text functions Date functions Financial functions Lookup and reference functions Engineering functions SOLVER Form Controls Conditional Formatting TEACHING UNIT 2. ERROR CHECKING AND TROUBLESHOOTING Types of Errors and How to Locate Them Avoiding Errors When Entering Data Lists Messages LEARNING UNIT 3. PROTECTING YOUR WORK Worksheet protection Cell protection Range protection Structure protection File open protection Open as Read-Only LEARNING UNIT 4. TABLE FORMAT Benefits of Working with Tables SUBTOTAL and SUM functions Data Segmentation Advanced Filters TEACHING UNIT 5. CHARTS Types of Charts Chart Elements Creating a Chart Modifying Charts Calculating Regressions and Trend Lines LEARNING UNIT 6. PIVOT TABLES What Pivot Tables Are and How to Create Them Standard Calculations Formatting Options Refreshing Filtering Data Slicing, Time Scale, and Dynamic Charts Calculated fields Advanced features LEARNING UNIT 7. IMPORTING DATA FROM EXTERNAL SOURCES Importing data from other files LEARNING UNIT 8. POWER QUERY Importing data Transforming a table Creating conditional columns Appending tables Cross-referencing tables LEARNING UNIT 9. MACROS AND INTRODUCTION TO VBA Recording macros Creating macros with VBA

Request for Information

Name *

Last Name *

Country

Phone

Email *

Company

Job Position

Sector

Message

I have read and agree to the Privacy Policy

Related MOOCs

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Are the masterclasses live?

Who is it intended for?

What features does Educa PHAROS have?

What guarantees does Educa PHAROS offer?

Why is Educa PHAROS the best solution?

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.