19. januari 2021 - 9:00 tot 16:15
International Leadership Academy, The Hague
Deel het op:

Microsoft Excel 2016 – Level 1 (Basic) | dinsdag, 19. januari 2021

Learn a fast and efficient way to work with Excel from the leading experts from Westhaghe Training & Advies. In this one-day Excel level 1 course you will learn the basic skills of Excel. Formatting and efficiency are central in this course.


Who is this course for?


This course is designed for those who want to learn to work with Excel. This course is suitable for those who have limited experience of using Excel. Prerequisites for this course are knowledge of the operating system Windows 2000/XP/Vista/W7/W8).


What’s Involved?


With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:



Starting with Excel


What do you do with Excel


The button “Tell me what you want to do” (only in Office 2016)


Describe Screen and  Views


Use the Ribbon


Customize the Quick Access Toolbar


Navigate in Excel / Go To


Insert/edit data


Clear cells


Select cells and data


Use the Help system



 


Using files



Create, open, save, send and close workbooks


A workbook based on a template


Create a PDF version of a worksheet


Reopen a not saved workbook


Recover previous versions



 


Edit a worksheet



Move and copy data


Create custom lists


Insert and delete columns, rows and cells


Hide and unhide columns and rows


Find and Replace


Check spelling



 


To structure a Excel map



Format worksheet tabs


Change the following order of worksheets


Insert and delete worksheets


Copy and move worksheets



 


Make calculations



Perform basic calculations


Use basic functions (calculating)


Copy and fill calculations to other cells


Using an absolute reference



 


Format: Column width  and Row height, Font, Alignment, Number



Change Column width  and Row height


Change Font type and Font size


Add or change Cell fill and Cell borders


Align cell content


Merge (and centre) cells


Apply Number format



 


Format: Styles, Conditional formatting



Apply cell styles


Format as Table


Copy format



 


Print Excel sheets



Print titles (Title rows and Title columns)


Header and Footer


Setup Margins


Setup Page orientation


Insert and remove Page Breaks


Setup a Print Area



 


Programme Dates


Tuesday 19th January 2021


Programme Cost


€195 Euros


Programme Facilitator


Westhaghe Training & Advies - Bert Roos


Cancellation  


Cancellation can be made up to six weeks before the first day of delivery by contacting us directly at email .  Any participant cancellation after this time is non-refundable.