Excel formulas and data operations

The most important elements of Excel

Hi, I’m Bartosz from Excel BI Academy. I have been working in Excel for years and every day I meet many people who need to repeat the most important elements of Excel. Because although they often use a spreadsheet and have often attended some training, they feel that they have partial knowledge. Hence the idea to prepare a solid refreshment of formulas and data operations.

What you’ll learn

  • I recorded the course in such a way that each user could face all the tasks on their own, even without watching the video, and then check the results..
  • But if you’re new to Excel, there are full-length videos of how formulas work and tasks step by step..
  • The course is also a great preparation for further deepening the knowledge of creating reports in Excel – with the use of Power Query, Power Pivot, dashboards a.
  • I recorded the course in the form of challenges. Thanks to it, everyone will find something for themselves..

Course Content

  • How to learn Excel? –> 1 lecture • 3min.
  • Lesson 1. Introduction to Excel formulas –> 8 lectures • 1hr 1min.
  • Lesson 2. Excel functions overview –> 5 lectures • 57min.
  • Lesson 3. VLOOKUP –> 10 lectures • 38min.
  • Lesson 4. Key reporting formulas –> 8 lectures • 29min.
  • Lesson 5. Data operations –> 9 lectures • 1hr 20min.

Excel formulas and data operations

Requirements

  • I recorded the course in 2020 in Office 365, but the formulas have been working the same for years. You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365..
  • In older versions, you may not come across a few of the formulas discussed..

Hi, I’m Bartosz from Excel BI Academy. I have been working in Excel for years and every day I meet many people who need to repeat the most important elements of Excel. Because although they often use a spreadsheet and have often attended some training, they feel that they have partial knowledge. Hence the idea to prepare a solid refreshment of formulas and data operations.

I recorded the course in such a way that each user could face all the tasks on their own, even without watching the video, and then check the results. But if you’re new to Excel, there are full-length videos that take you step-by-step through formulas and tasks.

5 reasons why you should take the course:

  • Repetition – I recorded the course in the form of challenges. Thanks to it, everyone will find something for themselves, and the prepared tasks will allow you to consolidate the material and increase the chances of finding the right functions and operations for your real problems.
  • Diversified level of tasks – If you are an expert, check if you can do all the exercises on your own.
  • Keyboard shortcuts and tricks – Each shortcut is emphasized in the videos to make it easy to remember and start using every day.
  • New Excel 365 formulas – I recorded the course in 2020 and used many new formulas that allow me to work even faster. Moreover, the course will be constantly updated with what’s new in Excel.
  • Preparation for further training and courses – If you plan to explore new parts of Excel, it makes sense to revise the old ones first. Especially before entering the world of Power Query, where many transformations mimic Excel formulas.
Get Tutorial