Getting started with Excel
This module covers the basics. Surveying the screen, getting acquainted with the user interface.
- The User Interface – surveying the Excel screen
- Work Books , Work sheets, columns, rows and cells
- The Ribbon - find your tools easily
- Tabs and Contextual Tabs
- Quick Access Toolbar – adding your own commands
- Customizing the Status Bar
- Zooming in and out
Building a work book
Navigating the work sheet and selecting cells. Entering and editing text and numbers in cells. Copying cells, mastering the fill-handle. Saving your work.
- Using work sheets
- Entering and editing data – move and copy – the smart tool: The fill-handle
- Comments - inserting comments to cells
Formulas and calculations
In this module you will learn how to make basic calculations. You will learn how to do the math on numbers, referring to a cell or referring to named range in the work sheet. You will also learn to master the five most common functions from the Excel function library.
- Calculation operators and calculation rules – essential when using formulas
- Excel formulas using cell references - your own formulas
- Introduction to build-in Functions - an easy and automatic way of carrying out calculations – ex. Autosum, Statistical functions and Logical functions (the If functions)
- How to use relative or absolute cell references in formulas – using $ signs in formulas
- Using names in formulas
- Error checking settings
In this module you will learn how to improve the way Excel displays your data. You will learn how to change fonts and character sizes and how to add color to emphasize important cells. Or put differently – how you make your work sheet look fabulous.
- Formatting cells – fonts, size, borders colors etc.
- Format numbers, dates and percentages
- Clear formats – how to remove the format settings
- Format painter - an easy way of copying formats
Printing and page layout
In this module you will learn how to improve the look of hour print outs on paper. How to adjust the layout (i.e. margins, orientation, paper size), and how to scale your print to fit a fixed number of pages.
- Preview the sheet before printing
- Make adjustments to the page layout
- Printing the work sheet or work book
The use of multiple sheets
After you’ve built your work book, you can reorganize to your own needs. If you use data in a specific sheet often, you can move it to the beginning of the work book. Another way to save time is to enter the same data or apply the same format to multiple cells in several work sheets simultaneously.
- Creating, managing and entering data in multiple sheets
- Navigation between sheets
- Formulas on multiple sheets – type in the same formulas on several sheets one time – formulas including several sheets
The limitation of working with numbers is that it is hard to keep track of several numbers at a time. By summarizing your data using a chart, you can make it much easier to see patterns and relationships. So, in order to make your information more visual – make charts.
- Enhancing your work sheets by using charts
- Creating different charts
- Chart tools – design, layout and format
Having entered a lot of data in Excel, you may want to change the order in which the work sheet rows are displayed. So, you need to sort your data. Or you may want to hide certain rows not meeting your criteria. So, you will have to use the Excel AutoFilter.
Help and keyboard shortcuts
- Organizing data by using lists
- Creating lists - sorting lists - filtering data using auto filters
- Creating tables and using tables styles – data areas that can alter sizes
In this module you will get an overview of keyboard shortcuts and key tips.
- Using Excel Help
- Excel Standard Keyboard Shortcuts
- Accessing All Commands from the Keyboard Using Key Tips