Virtual program of:edX |
The fundamentals and applications of Microsoft Excel To handle Excel functions, charts, data tables, and formulas To use scenario evaluation techniques and tools Advanced tools and strategies for importing and preparing data with Excel The new Excel tools for analysis of Massive data (Big Data) from various sources The use of Excel tools in business intelligence
6 months. 3 - 5 hours per week suggested.
3 virtual courses in soft skills
The ability to analyze complex data and draw conclusions from it is something that companies, increasingly oriented towards business improvement through the analysis of the vast amount of data they collect, increasingly demand of their executives.
This is known as business intelligence.
With this Professional Certification program focused on business intelligence you will learn to use Microsoft Excel from scratch, becoming an expert in its use for data analysis and visualization, which will help you advance in any job that requires making informed decisions. .
You will start with the basic operations of Microsoft Excel, the different functions and formulas that you can use and the use of graphs and formats to present results.
You will then learn what data tables are, how to import and link data from different sources, and how to use pivot tables and charts to extract information in this Microsoft software.
You will also learn about scenario analysis tools for data-driven decision making.
In the third Excel course we will introduce you to advanced data import techniques and various strategies to consolidate and prepare the data so that you can draw the conclusions you need (based on our experience using Excel and demonstrated with real cases).
We will also introduce you to the new data model and advanced import tools incorporated from Excel 2010 that allow you to work much more comfortably with large volumes of data (Big Data) spread over several tables and automate the import so that you do not have to repeat the steps each time. time you update the data.
This program covers all the parts you need to become a business-focused Excel mastery.
Whether you're looking to accelerate your career, earn a degree, or learn something for personal reasons, edX has the right courses for you.
Boost your career with college-backed credit programs and verified certificates.
Study and demonstrate knowledge at your preferred study time.
Try the courses before paying.
Learn alongside university partners and colleagues from around the world.
Expert teachers and instructors from UPValenciaX committed to high-quality virtual education.
Hello how can I help you? Are you interested in a course? About what subject?
Add a review