Lesson 5. Data operations
- 5.6. Find and Replace
- 5.7. Pasting
- 5.8. The FILTER, SORT, SORT BY, and UNIQUE functions (Excel 365)
- 5.9. Data operations - DIY exercise
- The New Excel Learning Curve - Summary
What you'll learn
- Finding and replacing data
- Paste data
- The FILTER, SORT, SORT BY, and UNIQUE functions (Excel 365)
- Data operations
Description
Hi, my name is Bartosz and I'm the author of this course that can be found on udemy and on the Excel BI Academy .com platform.
You are invited to the Excel refreshing course on formulas & data operations. As the founder of Excel BI Academy .com I have spent many years in the traditional Excel reporting, using formulas and pivot tables (that I describe in the separate course). I want my Excel BI Academy students to be well prepared to discover Power Query, Power Pivot, Power BI and Excel dashboards. That is why I have collected my Excel knowledge into the courses.
In the 3rd part of the Formulas and data operations course you will discover the data operations, such as:
· Find & Replace,
· Pasting,
· FILTER, SORT, SORT BY, and UNIQUE functions (Excel 365).
This is the last part of the course after which you should be able to create your own formulas without any troubles. The next step in this journey is pivot tables to which I dedicated another online course. Combining formulas and pivot tables is a great starting point for getting and transforming the data in an automated way (Power Query), creating pivot tables with your own KPIs (Power Pivot) and building world-class dashboards either in Excel or in Power BI Desktop app. The next steps wait for you at my Excel BI Academy .com.
Your next steps can be taken at udemy with my course: Power Query, Power Pivot, Data Viz & Power BI - 4in1 POWER or at my platform Excel BI Academy.
Best regards
Bartosz Czapiewski
Excel BI Academy
The University of Sheffield
Other Courses
Creative Writing Sample Lesson
Video lectures and plenty of activities about setting, character and plot with best-selling novelist K.C. Finn.
How to Animate Logos for Companies & Brands
Practical Animation that Brings Logos to Life In 1 Hour or Less
User Experience (UX) Strategy Fundamentals
A short course that introduces you to the principles and processes of UX Strategy work in an organization
New Blazor Features in .NET 8: A Mini Course
Learn and understand the new features of Blazor in .NET 8
Cucumber with Selenium Java (Basic)
Learn the ABC of cucumber and integrating it with Selenium
About the instructors
- 4.62 Calificación
- 24620 Estudiantes
- 11 Cursos
Bartosz Czapiewski
Excel BI Academy / SkuteczneRaporty
My name is Bartosz Czapiewski.
I come from Poland and live in Warsaw. I teach Excel every day, namely:
- Data visualization and dashboard design
- Power Query, Power Pivot, Power BI
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
From 2020, my courses are available online.
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.
Student feedback
4.83
Course Rating
Reviews
Dominique Dominguuez
28-11-2023
great