Solid data analysis skills are absolutely essential in today's corporate world. Whether you are a beginner, intermediate or advanced Excel user, this course will take you to the next level. In addition to best-practices, you will learn from hands-on examples and real-life cases. Some of the techniques covered here are true gems and are not available anywhere else! Lots of additional resources and guides are included with each lecture for your convenience!
This course does not aim to be a comprehensive Excel introduction. Rather, it focuses on how to polish your data analysis skills and become much more efficient in the use of Excel. That's why Excel users at any level of proficiency can take advantage of this course!
Our unique example-driven method for this course includes these elements:
This ensures that you will learn quickly, apply your skills immediately, solidify your knowledge and expand it as much as you want!
This short video will help you set up your Visual Basic environment properly before we start to code.
This lecture will introduce you to the structured analysis process, starting with univariate analysis.
This lecture is an introduction to multivariate analysis.
This lecture covers how to accelerate multivariate analysis with macros on pivot tables.
This lecture covers an advanced real-life case of multivariate analysis.
This short video describes the optimum report structure for data analysis.
This lecture shows how easy it is to create a PowerPoint presentation from Excel.
This video shows some of the most useful timesaving techniques known in Excel.
This lecture shows how to recognize users with environment variables.
This lecture describes how to use a documenter for Access databases, with the purpose of obtaining a summary of all forms, queries and tables contained in a database.
This lecture shows three examples of a basic Monte Carlo simulator.
Infoartist is a group of data analytics professionals with more than 12 years of experience developing global analysis tools for multinational companies across America and Europe, in the fields of telecommunications, consumer packaged goods, e-commerce, energy and food industry. We have also covered and refined this material at two universities. We have condensed the most valuable knowledge that we have acquired over the years and are ready to share it with you!