Contact
Request a demo

Advanced Excel

Cross-cutting
Digital Skills

Digital Skills

Duration

8:00 p.m.

PRESENTATION

Microsoft Excel It is a spreadsheet application and is the tool for management and analysis the most widely used data management software by companies to organize and present their data and financial statements. This program is a tool very powerful which allows us to perform calculations, analyze data, and create charts and tables very easily. Excel is a widely used tool in companies and businesses of all kinds, since you can work with any type of data, from the simplest to the most complex. With training in Advanced Excel You will acquire the skills necessary to master the tools and features advanced Excel features, in order to automate and streamline the data management and processing tasks required in any type of company.

Objectives

  • Acquire the knowledge needed to use the Excel functions advanced.

  • Perform lists and charts dynamic.

  • Learn how to make macros to automate tasks.

Syllabus

TEACHING UNIT 1. INTERMEDIATE-LEVEL TOOLS AND FUNCTIONS 1. Conditional Formatting 2. Charts 3. Data Lookup 4. Conditional Formulas 5. Managing Table Data 6. Pivot Tables 7. Audits 8. Mini-Charts and Flowcharts 9. Sorting and Filtering Data 10. Automating Processes and Data 11. Financial and Accounting Functions 12. Goal Seek and Solver TEACHING UNIT 2. ADVANCED TOOLS AND FUNCTIONS 1. Creating and Modifying Pivot Tables 2. Configuring Value Fields 3. Managing Data in Pivot Tables 4. Pivot Lists 5. Pivot Charts 6. Printing and Viewing Dynamic Content 7. Macros in Microsoft Excel 8. Advanced Macro Tools 9. Financial Functions 10. Mathematical and Text Functions 11. Databases and Forms 12. Using and Creating Menus 13. Using and Creating Templates 14. Database Management 15. Sensitivity Analysis and Scenario Planning 16. Basic Programming Concepts 17. Visual Basic for Applications (VBA)
Request for Information

Related MOOCs

Course

Workplace Risk Prevention, Ergonomics, and Mental Health

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

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....
Read more
Course

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...
Read more

Are the Educa PHAROS courses eligible for credit?

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

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

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.
Scroll to Top