Facebook

Excel Basic (conducted in English) kursus

  • Hjem
  • Office
  • Excel
  • Excel Basic (conducted in English) kursus

You will learn

Excel is a spread sheet that allows you to work with all kind of numbers, texts and charts. By participating in this course, you will obtain substantial knowledge of Excel’s most basic and relevant functions, and this will enable you to use Excel more effectively and efficiently than before. Even if you have been using Excel for years, we can teach you many smart things you probably did not know. We think that is why this course is one of our most popular.

After the course you will be able to:

  • Build sheets from scratch, insert notes, use smart copying and move cells, make extended search- and replace and use the fill handle – all in a quick and smart way
  • Build formulas, using some of the many build-in functions and lock cells (using $ signs in your formulas). Necessary when using formulas
  • Set up your sheets for print, ex adjust to whole pages and use page header/footer
  • Work with multiple sheets – copy, move and enter data in multiple sheets at the same time
  • Create and adjust charts to show import data graphically
  • Adjust long list to your needs using sorting and filtering
In the section, ”Course Details” below, you will find more details about the content of this course in Excel

You get

Before the course
  • The opportunity to speak with one of our instructors about finding the right course for you.
During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.
After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This Excel course is a part of 4D's unique collection of English conducted courses, and you do not need to have previous experience with Excel, but we recommend that you show up on the day of the course, willing to learn, and we can promise you the best possible course experience.

Course Details

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
Formatting

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
Charts

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


Lists

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.
  • 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


Help and keyboard shortcuts

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

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K