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