Get a better understanding of the Excel workflow
Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is a course that both beginners and advanced users can find helpful. In addition to the basics, you’ll also learn more advanced aspects, such as PivotTables and Functions.
- Take the course at your own pace
- Practical exercises and quizzes
- Personal diploma
- Save lessons as favorites
What you will learn
A large amount of the workday depends on Excel. Learn the menu system and keyboard shortcuts for efficient navigation. Once the basics are established, you’ll feel comfortable with the systems, and won’t need to ask your colleagues or Google for help.
Functions – How do they work?
Functions may at first feel very alien, but after going through Excel Essentials, you will be able to easily use the most useful functions such as VLOOKUP, IF, and SUMIF. Learn how to get data from separate ranges of cells, return sums based on references, and more.
Learn how to work with PivotTables and you’ll be able to analyze all kinds of databases. By letting Excel do the basic analysis for you, you will save a ton of time.
By visualizing and presenting data, you and your team can effectively identify insights that lead to better decision-making, strategies, planning, and actions.
- See the full course contents
Course ContentChapter Content0% Complete 0/6 StepsInsert dataNavigate with the mouseNavigate with the keyboardUndo and RedoComments and AnnotationsSaveChapter Content0% Complete 0/7 StepsCreate formulasCreate a functionCopy formulasComplicated formulasAbsolute and Relative Cell ReferencesAutoSumInsert FunctionChapter Content0% Complete 0/5 StepsChapter Content0% Complete 0/8 StepsChapter Content0% Complete 0/12 StepsThe IF-functionVlookupCountIFSumIFAverageIFHlookupNested IF-functionsIFerrorDate functionsText functionsXLOOKUPCombine FunctionsChapter Content0% Complete 0/8 StepsChapter Content0% Complete 0/9 StepsCreate a PivotTableWorking with a PivotTableFilter and slicerInsert a PivotChartGrouping by timeGrouping rows and columnsRefresh the PivotTableChange data sourceCreate PivotTables with multiple data sources (Power Pivot)
Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks you through how to combine functions, which is required to...
With Power Pivot and DAX, you can model data, visualize big data, and easily and efficiently create analyses to gain important insights. Data Analysis Expressions (DAX) is a collection of...