Excel 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.
- 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.
My name is Bartosz Czapiewski.
I come from Poland and live in Warsaw.
I run two most popular blogs in Poland dedicated to:
- Data visualization & dashboard design – SkuteczneRaporty_pl
- Power Query, Power Pivot, Power BI – ExcelBI_pl
Since 2010 I run trainings in Polish and English, many of which are Fortune 500 companies, like Coca-Cola, 3M, BMW, Danone. At Excel BI Academy I gathered all my knowledge and expierence from +100 live trainings on:
- Power Query for Excel & Power BI
- Power Pivot aka Data model & DAX language
- Power BI
- Data Visualization & Dashboard design
Since 2020 my courses are available online at Excel BI Academy_com.
What's my motto?
Effective Reports = Automation + Visualization and Analysis + Good Decision
English term Effective Reports (SkuteczneRaporty in Polish) has become my company name.
Where did my interest in dashboards come from?
It was 2009 when, while working as an analyst in an international company from the financial industry, I was asked by my supervisor to prepare a “dashboard”. The word sounded strange to me, so I checked it thoroughly in a search engine, where I found car dashboards and analogous dashboards showing business results. Both forms had two important features – they fit on one screen within the sight of the recipient and present numbers in a graphic and visual form. It was a completely different approach than the one I had known before. Traditional reports, most common in companies and organizations, contain thousands of columns of numbers spread over multiple sheets. While looking for the best dashboard building practices, I came across the principles of data visualization, i.e. an approach that starts with how the human brain works in the context of data analysis. Only by combining these two elements – correct data visualization and dashboards, we make working with reports much easier.
Why do I think this is important?
Every day, millions of people around the world create reports in the form of text, tables, charts and graphics, the purpose of which is to convey information and share knowledge to the recipient. Reports are both a compilation of business data, a financial report or a press article. We are an information society where the ability to collect, process, analyze and present information is extremely valuable. Especially in business, reports are worth their weight in gold as they are the basis for making everyday decisions. Their accuracy largely depends on the effectiveness of the report. Here are my insights on data visualization:
Most of the people who create charts cannot handle them properly.
The most popular charts (e.g. pie charts) are among the least effective.
It is fashionable to “colorize” reports that is contrary to the work of the brain.
The most popular computer programs that are used to visualize data, including Microsoft Excel, mislead the user and violate the basic principles of data visualization.
The charts that appear in the press and reports also mislead the public.
The concept of dashboards was reflected only in Excel 2013, in a way so camouflaged that few users will discover it.
Data visualization is not a subject that is taught at any economic university in Poland, nor is it included in MBA programs.