”Excel – English” gives you access to our entire library of 86 lessons which will make you a champion in Excel. We go through the basics of Excel, how to enter data and make spreadsheets look professional, and then move on to more advanced functions. In the second part of the course you will learn how to work with Pivot tables, how to create functions such as ”Vlookup” and ”Iferror”, and how to save time by creating macros. All our lessons are repeatable, meaning you will have access to all 86 lessons during the subscription period, even after passing the course. The lessons are based on Excel 2013 and will work well for all users with Office 2007/2010/2013/2016/365.
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.
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.