MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (4h 27m) | Size: 1.97 GB
The most important elements of Excel
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.
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.
Who this course is for
The course is aimed at both beginners and advanced users of Excel.
The course starts with the basics, and then I discuss all the formulas in detail.
If you’re interested in what’s new in Excel 365, you can only find the lessons that are relevant to it.