Microsoft Excel It is a spreadsheet application and is the tool for management and analysis the most widely used data management software by businesses for organising and presenting their data and accounts. This programme is a tool very powerful which allows us to carry out calculations, analyse data, and create charts and tables very easily. Excel is a widely used tool in companies and businesses of all kinds, as you can work with data of any type, from the simplest to the most complex. With training in Advanced Excel you will acquire the skills needed to master the tools and features advanced Excel skills, with a view to automating and streamlining the data management and processing tasks required in any type of business.
Cross-cutting
Digital Skills
8 pm
Advanced Excel
Digital Skills
8 pm
Introduction
Objectives
-
To acquire the knowledge needed to be able to use the Excel functions advanced.
-
Perform lists and charts dynamic.
-
Learn how to make macros to automate tasks.
Table of Contents
TEACHING UNIT 1. INTERMEDIATE-LEVEL TOOLS AND FUNCTIONS
1. Conditional Formatting
2. Charts and graphs
3. Data Search
4. Conditionals
5. Managing Data in Tables
6. Pivot Tables
7. Audits
8. Mini-charts and Organisation Charts
9. Sorting and Filtering Data
10. Automating Processes and Data
11. Financial and Accounting Functions
12. Goal Seeking and Solver
TEACHING UNIT 2. ADVANCED TOOLS AND FUNCTIONS
1. Creating and editing pivot tables
2. Configuring the value fields
3. Data management in pivot tables
4. Dynamic Listings
5. Dynamic Charts
6. Printing and displaying dynamic content
7. Macros in Microsoft Excel
8. Advanced Macro Tools
9. Financial Functions
10. Mathematical and string functions
11. Databases and forms
12. Using and creating menus
13. Using and creating templates
14. Database management
15. Sensitivity analysis and scenario building
16. Basic programming concepts
17. Visual Basic for Applications (VBA)
More related courses
Cross-cutting
Cross-cutting
Cross-cutting
Cross-cutting
40 hours
Basic Digital Competence in Communication and Collaboration using Digital Tools
View course →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.