This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

This is the most updated course on Excel with the Most recent formulas and Features that matter the most for work related tasks. This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, this course teaches through animated designs and videos for you to understand the concepts better. You would get to learn the basic concepts that run excel and become efficient at it. We'll deep dive into a broad range of Excel formulas & functions, including:

• Vlookup and 5 business situations where it can be used
• XLookup and 5 business situations where it can be used
• Basic Excel Formulas like Sum(), Average(), Count(), CountA(), Round() etc
• Must Know Excel Shortcuts and Hacks
• Pivot Tables and its Use cases
• Formula-based formatting
• Logical operators
• and more You can be the Excel guy at your workplace and master unknown shortcuts, yet very powerful in their own terms.

Are you interested in data analytics and business intelligence? Great! You have chosen not only a highly rewarding profession but also one of the most interesting ones of the future!

Data is the oil of our century, and getting the right insights at the right time will be the key competitive advantage for businesses. Companies need highly skilled people to help them analyze their data. Data aggregation and cleaning is the most challenging part of this process. 80% of data analysts and data scientists' time is spent on data preparation.

This can be a cumbersome process but is crucial to derive valuable insights - because: "Trash in: trash out!"

Hence we need to explore fast and efficient ways to prepare our data, which we want to visualize in powerful tools like Tableau or Power BI. And now for the most interesting question? How exactly can we achieve this? What are the best tools to help accomplish this AND do not require extreme programming skills? Meet Alteryx! One of the best ETL / data preparation tools on the market.

This incredible tool with an "Apple flair design" and drag and drop functionality will help us to prepare and combine even the worst kinds of data sources. In this course, we will start from scratch with a fully functional trial version of the software to follow along. The only thing you need to bring with you is your personal interest and willingness to learn in a data driven age. If that sounds like you then.. Let's dive into the course together! Are you ready? 

Who is this course for?

• You want to become a data analyst
• Students who have taken Alteryx Masterclass - a crashcourse for beginners
• You want to go into a data analyst or data scientist career
• You want to learn how to effectively clean your data
• You want to extend your knowlegde beyond Tableau and Power BI
• You encountered various data issues (e.g. format,...) in the past and are looking for a solid solution
• You want to take advantage of the data driven opportunity ahead

Requirements:

• Your interest in data preparation and data analytics, visual analytics is key!
• This MasterClass starts from scratch - we learn the basics and build a solid foundation during the case study
• Alteryx Designer must be downloaded (fully functional trial version available for free)
• The case study course Alteryx Masterclass - a crashcourse for beginners is optional but not required

Business Intelligence / Business Analytics is in high demand.

Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily on data, Data-driven decision making is the key to success for any business in the world of tomorrow. Because of that, companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable, highly profitable insights as this will be the key advantage to succeed in business.

MS Power BI is an advanced, yet easy to get started self-service business analytics / business intelligence solution provided by Microsoft, which is currently very high in demand. From my own personal experience, I can testify that companies will actively search for you if you master Power BI. Not only will diving into data & analytics immensely improve your career opportunities, but it will also help you with job satisfaction!

Power BI is also an excellent tool for data science. A lot of data scientists like to use it for visualizing and presenting their findings. Therefore learning to use this tool can also be a valuable skill for data science jobs. That is why I created this course to help you dive into one of the hottest and best business analytics / business intelligence software currently available.

Starting from scratch, step by step, we will learn all the relevant PBI basics and master more advanced concepts. Power BI has a robust & active community, and with Microsoft pushing this solution to its enterprise customers, Power BI has a bright future ahead. You can be part of this future! There is no coding required! Power BI allows for coding, but it's not necessary.

In this guided learning course, you go from zero to hero in just 6 hours in which you will learn:

• the ETL capabilities of Microsoft Power BI ("get messy data easily into the right format") 
  
  
• Master simple and very advanced DAX calculations (Power BI language, similar to that of excel formulas) 
  
  
• Create outstanding visualizations and reports 
  
  
• Derive valuable highly profitalbe insights

What we learn in this course may also help you later with your Power BI certification exam should you wish to take it. You can follow along with the provided learning material in Power BI on your own computer at your own pace. Much better than only reading a book right? Excited? You should be! Buckle up and meet me in the first lecture starting today!

Who is this course for?

• You want to become better at your job OR explore a new career opportunity
• You want to master self service bi
• You want to get valuable insights from you data
• You want to be in high demand (as employee or freelancer)
• You want to succeed in the working world of tomorrow
• You want to create stunning visualizations to impress management or your coworkers
• You want to stand out from the crowd
• You want to learn and to improve

Requirements:

• Working with Microsoft products e.g. excel is an advantage, but not required
• Your willingness to learn and grow
• This is a Microsoft Power BI Training for beginners to advanced
• Power BI can be downloaded for free from the Microsoft page