- The point of this course
- Introduction
- Linking sheets
- Keyboard shortcuts
- Appearance
- Basic references 1
- Basic references 2
- Relative and absolute references
- Conditional formatting
- Adding and removing content
- Exercise
- Solution
- Validate data
- Find and replace
- Freeze planes
- Recognizing patterns
- Patterns
- Security
- Sort and filter
- Exercise 2
- Solution
- The trip continues
- Arrival
- Basic functions
- SUMIF
- COUNT
- Love
- Exercise
- Solution
- Bonus Lecture
What you'll learn
- Structure data
- Format data
- Use basic and advanced functions
- Secure data
Description
MICROSOFT EXCEL
Microsoft Excel is widely used around the world to structure data, to analyze it and to visualize it. This course gives you a brief introduction in Microsoft Excel. The goal is to quickly familiarize you with how Microsoft Excel works and how our teaching style is. Based on that you may decide to continue your education with us or not. So in many ways, this is a free preview course intended to introduce us to you.
In this introductory course, we will teach you:
Linking sheets in Microsoft Excel
Keyboard shortcuts in Microsoft Excel
Change the appearance of data in Microsoft Excel
Make basic references in Microsoft Excel
Filter data in Microsoft Excel
Sort data in Microsoft Excel
Secure data in Microsoft Excel
Conditionally format data in Microsoft Excel
Format data in Microsoft Excel
Add, remove and hide cells in Microsoft Excel
Recognize patterns in Microsoft Excel
Validate data in Microsoft Excel
Freeze panes in Microsoft Excel
There are multiple versions of Microsoft Excel out there. For example, we have the Microsoft Excel 2016 version, the 2019 version etc. This course is set up in such a way that the version you use is not that relevant. We wish you a lot of fun with this Microsoft Excel course.
Other Courses
How to Design 3D Games in Buildbox 3 + Free Templates
Learn all of the Buildbox 3 gameplay design tips and tricks for making cool 3D games.
Learn How to make Professional Actions in Adobe Photoshop
Make Passive Money by Create and Sell Professional Actions online, by Learning this Professional Method
The complete Airtable Custom Blocks development course
Master Airtable App Development by building custom blocks on the Airtable platform.
About the instructors
- 4.59 Calificación
- 175389 Estudiantes
- 17 Cursos
Six Sigma Academy Amsterdam (SSAA)
ACCREDITED TEACHING BY ACADEMICS
Six Sigma Academy Amsterdam or SSAA started when a number of university lecturers from the Netherlands decided to make academic quality education more affordable, practical, time efficient and engaging.
All course developers and lecturers involved are qualified university lecturers as well as Six Sigma Master Black Belts and as such able to train students and future instructors. All the Lean Six Sigma programs we offer are accredited based on the Dutch higher education standards and our student experience shows that the degrees are globally accepted and respected.
Six Sigma Academy Amsterdam or SSAA has trained and certified 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, SSAA lecturers have supervised projects for companies like Audi, the Dutch military and Lufthansa.