Who's this course for?
”Excel Essentials English” is an online course in Microsoft Excel perfect for anyone who is self taught or a beginner in Excel and wish to master the software.
What will i learn?
The course will satart off by teaching you the basics in Excel, how to line up your data to look professional and other basic functionalities. We then move on to more advanced areas like Pivot tables, how to perform certain functions such as "Vlookup and "Iferror" as well as how to save time using macros.
The lessons are based on Excel 2016 and will work well for all users with Office 2007/2010/2013/2016/365.
If you have any questions, just contact us!
This is included:
- Full access for 12 months
- 86 lessons
- Video time: 3,5h
- Time to complete to course: 7-9h
- Avarage lesson time: 2 min 38 sec
- Personal diploma upon completion
In this chapter, we go through the Excel window, the names of each part, and where they are located. The chapter difficulty is low, and if you are already familiar with Excel this chapter will be quick to go through.
In this chapter, we go through some basic functionalities in Excel such as inserting data and saving a file. The level of difficulty is low, but you can find useful tips even for those who regularly work in Excel.
This chapter starts with creating a simple formula, by combining the values in two different cells. The level of difficulty is then increased, and by the end of the chapter you will be able to combine the values of multiple cells by using the Autosum button.
Formatting means that we work with the appearance of the cells and worksheets. This chapter begins with the basic formatting of text and numbers, and moves on to more advanced formatting, where the format of a cells depends on its contents.
In this chapter, we will review how to control what is visible in the worksheet and its appearance. Among other things we show you how to insert or hide rows and columns, and how to move data in a spreadsheet using the right techniques.
In this chapter we show the various settings for printing, making it possible for the printout to look the way you wish, regardless of the content of the workbook.
Charts are excellent tools for visualizing and presenting the figures and numbers in a workbook. In this chapter, we show you how to create a chart and how to use the settings to achieve the appearance that you want.
This content of this chapter will be useful when you have a spreadsheet with large data series. These functions are simple tools to get a better overview, and to quickly find certain pieces of data.
This chapter begins with explaining basic functionality for spreadsheets, and then moves on to showing how to create links between data from separate workbooks.
In this chapter we teach you how to use functions. Once you have learned to handle those explained in these ten lessons you will be able to create any one of the approximately 400 functions found in Excel.
In this chapter we show you how to prevent colleagues and friends from entering and editing information in your workbooks, and how to control what changes you want to allow.
Databases can quickly become large and difficult to handle. In this chapter, we go through techniques and functionalities which make working in databases easier.
The Pivot table is a function for analyzing the content of databases. It is arguably the most popular tool in Excel, and in this chapter we show how to create and work with Pivot tables and Pivot charts.
Goal Seek and the Scenario Manager are two types of impact assessment where Excel does the work for you. This type of functionality will save you a lot of time if used properly.
Macros save you time by recording a series of commands that can be activated by a keyboard shortcut. Many perceive macros to be slightly complicated, but in this chapter we show how easy it actually is to set up and execute macros.