Excel Basic – conducted in English
Excel Basic Course - conducted in English
Through this course you will learn how to format and arrange your data for improved readability, how to create and format charts, how to use formulas and calculations and use some of Excels tools for handling large amounts of data.
Requirements
You can participate in this course whether you use Excel 2019, 2016, 2013 or Office 365.
No prior knowledge to Excel is needed to participate in this course.
If you have a certain degree of knowledge to Excel or you want a quicker review or a brush up, we can offer you a 1 day course.
Duration
2 days from 09:00 to 16:00
- 2 dage kl. 9:00 - 16:00
- 5.700 kr. ex. moms
-
Kurset tilbydes også som
solo- eller firmakursus
Excel Basic course2 dage
Excel Basic course2 dage
Excel Basic course2 dage
Excel Basic course2 dage
Excel Basic course2 dage
Course content
Introduction to Excel
- Intro to Excel
- Review of the user interface
- Customizing the user interface
Building Excel spreadsheet
- Entering, editing and deleting data in Excel
- Adjusting rows and columns
- Delete, insert columns and rows
- Naming, inserting and deleting sheets
- Insert comments in the cells
- Selecting and Navigating in Excel
- Navigating within the spreadsheet
- Navigating between sheets
- Selecting Data
Formulas and functions
- Building and editing formulas
- Locking cell references
- Introduction to built-in functions such as:
- Sum – Average – Count – Min – Max – IF
- Copying formulas and functions
- Formulas across sheets
Formatting
- Numbers and date formatting
- Font and cell formatting
- Formatting borders and lines
- Conditional formatting
- Zero format
Presentation af data
- Creating and editing charts
- Formatting charts
- Copying of charts and pasting into Word / PowerPoint using links
Working with large amounts of data
- The use of Filters for selecting specific topics
- Sorting Data
- Freeze panes (lock viewing to top rows / leftmost columns)
- Use of Table styles
Printing Spreadsheets
- Using print preview
- Create and manage page layouts
- Repeating headings on all printed pages
Shortcut keys
- Using Keyboard Shortcuts
What you get from the course
Breakfast, lunch,
coffee, tea, cake.
The material can be used as a reference in the future.
After completing the course, you will receive a course certificate.
Even after the course is over, you can always get help.
How we teach
In our courses, the teaching will alternate between theory and practice. We place a high value on active learning in our teaching. This means that even during a review of new topics, you will be actively engaged on the keyboard along with the instructor, followed by a series of tasks you need to complete.
Meet the course instructors.
Related courses
After this course, we recommend that you take our course in Excel PivotTables. You can see the entire Excel course overview here.
Also, check out our Excel courses in Excel Courses in Copenhagen and Aarhus
