Excel Advanced (e-learning) (English)
Excel Advanced (e-learning) (English)
In het kort
Would you like to learn more about the advanced possibilities of Excel at your own pace? In this training you will discover how to use advanced filters, create pivot tables and use macros. Also, you decide where and when you study.
Would you like to learn more about the advanced possibilities of Excel at your own pace? In this training you will discover how to use advanced filters, create pivot tables and use macros. Also, you decide where and when you study.
Audience
You already know how Excel works in a basic way, but you know that there are many more possibilities. You want to discover and utilize those possibilities. You like to study in a flexible way and want to be able to plan where and when you study.
Prior knowledge
To follow this course you need prior knowledge of Excel at the level of Excel Basic - Online. This means that you, among other things:
- Can enter numbers and dates
- Can make simple calculations
- Select and copy data in cells
- Can print parts of worksheets
Approach
With this online course you can learn at your own pace, at a time and place that suits you best. You will get started with advanced options of Excel. You will learn quickly using professional and English e-learning and associated exercises. With this e-learning you will discover all the ins and outs of Excel, including many tips and tricks on how to work with Excel faster and more efficiently. You will learn, among other things, how to work with references, filters and pivot tables. Within the study program you are flexible in which subjects you want to study. Skip topics you’re already familiar with.
You have access to the e-learning environment for 3 months, which consists of the following components:
- English spoken video classes
- Exercises in the application itself
- Assessments
Meer weten over de kosten van deze opleiding? Vraag dan een persoonlijk kostenoverzicht aan, volledig afgestemd op jouw opleidingswensen.
Wat ga je leren?
Content
- Working with Advanced Tables
- Displaying multiple lines in a cell
- Using absolute cell references
- Copying, linking and transposing data
- Using the system date and date formats
- Creating simple conditions
- Applying custom number formats
- Applying and managing conditional formatting
- Naming cell ranges
- Using data validation
- Using named ranges in formulas
- Presenting Data with Charts
- Creating and moving charts
- Managing charts
- Selecting chart elements
- Adding and removing chart elements
- Formatting chart elements
- Editing chart text
- Working with legends and the plot area
- Printing charts and adjusting page layout
- Formatting Charts
- Editing data labels
- Formatting data series and chart axes
- Managing data series
- Changing chart types
- Managing chart templates
- Creating 2D map charts
- Creating and managing sparklines
- Working with Pictures and Objects
- Creating graphic objects
- Selecting, moving and deleting objects
- Copying and resizing objects
- Editing text boxes and shapes
- Formatting drawing objects
- Inserting and managing pictures
- Rotating, aligning and grouping objects
- Working with Data Lists
- Calculating subtotals
- Creating and managing Excel tables
- Formatting and sorting tables
- Adding calculated columns
- Using AutoFilter and custom filters
- Finding blank and duplicate values
- Filtering with criteria
- Copying filtered data
- Using sorting and filtering tools
- PivotTables and PivotCharts
- Creating PivotTables
- Editing PivotTables and adding calculations
- Changing the data source
- Selecting, copying, moving and deleting PivotTables
- Formatting and printing PivotTables
- Filtering PivotTables and using slicers
- Creating PivotTables from multiple data tables
- Adding fields and calculated items
- Grouping PivotTable data
- Creating PivotCharts
- Working More Efficiently
- Converting data
- Using data series
- Creating custom views
- Adding cell comments
- Checking for errors
- Evaluating formulas
- Using the Watch Window
- Using Advanced Functions
- Using lookup functions
- Using text functions
- Calculating dates and times
- Using AND, OR and NOT functions
- Creating nested formulas
- Using conditional functions
- Using array formulas
- Working with copied calculations
- Consolidating data
- Using financial functions
- Creating two-variable data tables
- Advanced Excel Features
- Using Goal Seek
- Using Solver
- Managing scenarios
- Creating hyperlinks
- Creating and customising themes
- Creating, editing and using templates
- Exporting Excel data to PDF, XPS, email and web pages
- Converting Excel files
- Importing, updating and managing data
- Managing workbook properties
- Sharing and protecting workbooks
- Protecting cells
- Finalising workbooks
- Creating, protecting and using forms
- Advanced Tools
- Using macros
- Recovering files and previous versions
- Customising the Ribbon
- Applying spreadsheet best practices
- Collaborating on workbooks
Alle kosten in één overzicht
Weet precies waarvoor je betaalt, zodat je zonder zorgen aan je opleiding kunt beginnen.
De hierboven vermelde totaalprijs is exclusief btw en geldt wanneer je de opleiding zelf betaalt bij betaling in één termijn. Je kunt bij langere opleidingen ook per jaar of per maand betalen.
Studie- en lesmateriaal
Je ontvangt alles wat je nodig hebt om succesvol te studeren, waaronder:
✓ Toegang tot het online leerplatform
✓ Leslocatie met uitgebreide lunch
*Arrangement- & locatiekosten
Volg je de opleiding op locatie? Dan zorgen wij voor een inspirerende leeromgeving met koffie, thee en een uitgebreid lunchbuffet. De kosten hiervoor hangen af of je voor de dag- of avondvariant kiest. Vraag hiervoor het kostenoverzicht aan. Kies je voor de online variant? Dan betaal je uiteraard geen arrangementskosten.
Je kunt alvast geheel vrijblijvend een plek reserveren voor deze opleiding. Vul het formulier in, dan nemen we contact met je op om je inschrijving samen af te ronden.
Bekijk beschikbare startdata!
Bekijk hieronder onze actuele lesplanning en schrijf je in voor een startdatum naar keuze.
Eerstvolgende startdatum
Hulp nodig bij je opleidingskeuze?
Heb je na het lezen van alle informatie vragen of twijfel je nog ergens over? Onze opleidingsadviseurs geven je graag gratis en vrijblijvend persoonlijk studieadvies, op basis van jouw leerdoelen en behoeften. Laat je gegevens achter en wij nemen zo spoedig mogelijk contact met je op om het advies te bespreken. Computrain hecht waarde aan toegankelijkheid en gelijke deelname. Heb je specifieke vereisten of behoefte aan extra ondersteuning bij je deelname aan de training, dan kun je dit vooraf bij ons aangeven.