This product is no longer in stock
Excel allows you to automate procedures to collect, transform and analyze information. With this course you will be able to know different tools, that by means of the organization and classification of data, will allow you to generate and cross information, improving accounting and financial management processes.
WITH THIS COURSE YOU WILL BE ABLE TO:
Analyze dynamic tables
Create dynamic graphs
1. Introduction to the course
Welcome to the course
2. How does Microsoft Excel think?
Feel comfortable with the menu bar
Know the structure of an Excel workbook
Protecting information in Excel
Simple drop-down lists
Dependable drop-down lists
Print in Excel? It will not be a problem anymore
Reinforce together several concepts
Challenge: Table and formats
3. Preparing the information
Separate text and then join it
Basic formulas (numerical and text)
Sumar.si and Average.if
Name ranges and make operations
Weighted average and data fixation
Practice the weighted average
What is SearchV?
Formulate your own SearchV
Now, what is SearchH?
Practice the Search
Conditional formulas. What are they?
Essential conditional formulas
4. Analyzing the information
Traffic lights, color cells and formulation
Types of graphics and their different uses
Formulation with dynamic tables
Management model gathering knowledge
Macros - writing and understanding code
Macros - recording macros
Closure of the course
Size: 2.99 GB
Formators: Felipe Guzmán
Content: 04 Modules
Duration: 3h 45m
Fitness level: Beginner - Intermediate
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the course, to improve the content.
To see our course gallery click here
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.