- Automation & ICT / IT
- Microsoft Excel
- Excel Basis / Beginners
- Cursusboek Excel 2016 met Praktijkopdrachten
Cursusboek Excel 2016 met Praktijkopdrachten
OEM ICT trainingen & Advies (CLP)
Features
- 1 day
- Certificaat van Deelname
€ 48,40 All-in-price
- Customers reward us with a 9,8
- Learn when you want
- Best price guarantee
Book this course
- Customers reward us with a 9,8
- Learn when you want
- Best price guarantee
€ 48,40 All-in-price
Book this course
€ 48,40 All-in-price
- Dit is gegarandeerd de beste prijs
About this course
This practical Excel 2016 course book explains in detail about all the different functions of Microsoft Excel 2016. The Excel 2016 course book is intended for anyone who wants to work faster and more efficiently and thus get the most out of Excel 2016.
The Excel 2016 Course Book contains 352 pages, covering practical assignments and all topics. View the Contents for an overview of all topics in the Excel 2016 course book.
Publisher is a Microsoft Gold Partner
Order before 4:00 PM and receive it tomorrow.
Contents:
View 8
Workbooks 17
Templates 35
Move/Select 38
Entering data 45
Change data 52
Copy and move 57
Worksheets
Rows, columns, cells 72
Naming subjects 77
Calculations 82
Advanced Calculations 98
Scenario and target value 113
Error checking 118
Solver 124
Change default formatting
Borders and padding 143
Conditional formatting 149
Styles and themes
Sorting and overviews 165
Data filter 171
Layout 181
Print 189
Creating graphs 195
Chart options 206
Graph objects 224
Object management 236
Data table 248
Pivot table 253
Pivot chart 280
Securing 283
Use parts 289
Data entry optimization 297
Hyperlinks 307
Import/export 313
Macro commands 325
Excel and the Web 331
Adjust 335
Shortcuts 343
Best Practices for Creating Tables 348
The Excel 2016 Course Book contains 352 pages, covering practical assignments and all topics. View the Contents for an overview of all topics in the Excel 2016 course book.
Publisher is a Microsoft Gold Partner
Order before 4:00 PM and receive it tomorrow.
Contents:
- Environment 3
- Start Microsoft Office Excel 2010 4
- Exit Microsoft Office Excel 2010 5
- Use/manage the ribbon 5
- Working with the File tab 6
- Undo the last actions 6
- Redoing previously undone actions 7
- Repeat the last action 7
View 8
- Change the display mode 9
- Activate full screen mode 10
- Change the appearance of the formula bar 11
- Show/hide the gridlines and headings of rows and columns12
- Change the zoom level 12
- Activate a window 13
- Displaying a worksheet in two different windows 13
- Rearrange the appearance of the windows13
- Hide or show a window 14
- Block/unblock rows and/or columns 14
- Splitting the window15
Workbooks 17
- Create a new empty workbook 18
- Creating a workbook from a template 18
- Create a workbook from an existing workbook 20
- Open a workbook 20
- Open a recently used workbook 22
- Save a workbook 22
- Using Excel 2010 Workbooks in Older Excel Versions 23
- Using workbooks created in a version older than Excel 2007 24
- Save a workbook in PDF or XPS format 26
- View/change the properties of a workbook 28
- Compare workbooks side by side 30
- Close a workbook 31
- Choosing the default workbook 31
- Configure workbook autorecovery 31
- Restore an earlier version of a file 32
- Send a workbook via email 33
Templates 35
- Create a custom workbook template 36
Move/Select 38
- Moving around a worksheet 39
- Go to a specific cell 39
- Find a cell 40
- Select cells 41
- Select rows/columns 42
- Select cells based on content 42
Entering data 45
- Entering constant data (text, values, etc.) 46
- Entering special characters 47
- Inserting the system clock date/time into a cell 47
- Use the AutoFill cell values feature 47
- Entering the same content in multiple cells 48
- Starting a new line in a cell 48
- Creating a data series 49
Change data 52
- Changing the contents of a cell 53
- Clear the contents of the cells 53
- Replace the contents and/or formatting of a cell 53
- Spell check 54
- Manage the automatic spelling correction 55
Copy and move 57
- Copy a cell content to adjacent cells 58
- Copy/move cells 58
- Copy cells to other worksheets 59
- Using the Office Clipboard 60
- Copy layout 63
- Copy the contents, results and/or formatting of cells 63
- Copy and transpose 64
- Copy Excel data and create a link 64
- Performing simple calculations while copying 65
- Copy data as image 65
Worksheets
- Activating a worksheet 68
- Rename a worksheet Select worksheets 68
- Change the color of the sheet tabs 68
- Show/hide a worksheet 69
- Display an image as the background of the sheet 69
- Moving/copying one or more worksheets 70
- Insert/add worksheets 71
- Delete worksheets 71
Rows, columns, cells 72
- Inserting rows/columns 73
- Delete rows/columns 73
- Change column width/row height 73
- Adjusting the width of a column/the height of a row 73
- Insert blank cells 74
- Delete cells 74
- Move and insert cells/rows/columns 74
- Remove rows containing duplicates 75
Naming subjects 77
- Naming cell range 78
- Manage cell names 79
- Select a range of cells named 81
- Displaying the list of names and references of grouped cells 81
Calculations 82
- Introduction to the basics of the formulas 83
- Creating a simple formula 83
- Creating an absolute cell reference in a formula 84
- Entering a formula with data from multiple worksheets 85
- Creating a formula that contains a function 86
- Using the AutoComplete Formula feature 87
- Adding a collection of cells 88
- Using simple statistical functions 89
- Creating a simple conditional formula 89
- Creating a nested conditional formula 91
- Counting cells that meet a specific criterion (COUNTIF) 93
- Calculate the sum of a range of cells that meets a criterion (SUMIF) 94
- Using Named Boxes in Formulas 94
- Insert statistical rows 95
Advanced Calculations 98
- Perform calculations with the date 99 data type
- Performing calculations on data of type time 103
- Using the Search function 104
- Merging data 105
- Calculating the value of a periodic payment 106
- Calculating the value of borrowed capital 107
- Creating a two-entry table 107
- Using an array formula 108
- Using the equation editor 109
Scenario and target value 113
- Achieving a target value 114
Error checking 118
- Showing formulas instead of results 119
- Detecting and solving errors in a formula 119
- Evaluating Formulas 121
- Using Window Control 121
- Keeping track of the relationships between formulas and cells 122
Solver 124
- Discover and activate Solver Plugin 125
- Define and solve a problem with Solver 125
- Show intermediate solutions of the Solver 129
Change default formatting
- Change the formatting of the characters Adjust the format of the content Create a custom format
- Align data
- Change the orientation of the cell contents Align the cell contents
- Apply an indent to the cell contents Merge cells
Borders and padding 143
- Applying cell borders 144
- Apply a fill color in cells 146
- Apply a pattern to the background of cells 146
Conditional formatting 149
- Applying predefined conditional formatting 150
- Create a conditional formatting rule 151
- Format cells based on content 154
- Remove all conditional formatting rules 155
- Manage conditional formatting rules 156
Styles and themes
- Apply a cell still
- Make a still
- Manage existing cell styles
- Apply a theme to a workbook
- Adjust the theme colors
- Adjust the theme fonts Adjust the theme effects Save a theme
Sorting and overviews 165
- Sort data from a table based on a criterion 166
- Sort data by cell color, font, or icon set 166
- Sort table data by multiple criteria 167
- Creating an overview 169
Data filter 171
- Activating the AutoFilter 172
- Filter data by content or format 172
- Filtering based on a custom criterion 175
- Applying specific filters to certain data types 176
- Filter by multiple criteria 177
- Clear a filter 178
- Filtering data using an extended filter 178
Layout 181
- Change page layout options 182
- Determining a print range 184
- Insert/remove a manual page break 184
- Repeat rows/columns on every page 184
- Create and manage headers and footers 185
- Creating a watermark 187
- Using views 187
Print 189
- Using the print preview 190
- Printing a workbook/worksheet/selection 191
Creating graphs 195
- Making a graph 196
- Activating/deactivating an embedded graph 198
- Changing the location of the grave leak198
- Flipping Data on a Graph 198
- Changing the chart's data source 199
- Add one or more data series to the chart199
- Remove a data series from the chart 200
- Changing the order of data series in the graph leak 200
- Changing the source of the x-axis labels 201
- Managing Chart Templates 201
- Create/delete a sparkline chart 202
- Modify a sparkline 204
Chart options 206
- Selecting chart elements 207
- Change a chart/series type 207
- Applying a predefined layout to a chart 207
- Show/hide chart elements 208
- Changing the x-axis options 208
- Changing the Y axis 210
- Adding a Secondary Vertical Axis 211
- Change data labels 212
- Applying a quick style to the graph 213
- Change the format of numeric values in a graph 214
- Adding a trendline to a graph 214
- Change the text direction in an element 217
- Changing the format of a 3D chart 218
- Changing the orientation/perspective of a 3D graph 219
- Modifying a pie chart 220
- Connecting the points of a curve-type graph 223
Graph objects 224
- Creating a graphic object 225
- Inserting an image file 227
- Inserting an illustration 227
- Inserting a screenshot229 Inserting a SmartArt graphic231
- Manage shapes of a SmartArt graphic 233
- Changing the overall appearance of the SmartArt graphic 234
Object management 236
- Selecting objects 237
- Managing objects 237
- Changing the format of an object 238
- Adjusting the format of an image 240
- Crop an image 241
- Remove the background from an image 244
- Adjusting the resolution of an image 245
- Formatting an object's characters 246
Data table 248
- Creating a data table 249
- Naming the data table 249
- Resizing a data table 250
- Show/hide table headings 250
- Add a row/column to table 250
- Selecting rows/columns in a data table 250
- Displaying a total row in a data table Creating a calculated column in a table 251
- Apply a table style to an existing data table Convert a data table to a range of cells 251
- Deleting a data table including data 252
Pivot table 253
- Creating a PivotTable 254
- Managing the Fields of a PivotTable 256
- Inserting a calculated field 259
- Change a field's summary function or custom calculation 260
- Using the totals and subtotals fields 264
- Filtering a PivotTable Using a Report Filter 267
- Grouping PivotTable Data 273
- Change the layout/presentation of a PivotTable 276
- Recalculating a pivot table 278
- Deleting a PivotTable 279
Pivot chart 280
- Creating a PivotChart 281
- Removing a rotary puncture 282
- Filtering a PivotChart 282
Securing 283
- Protecting a workbook using a password 284
- Protecting the items of a workbook 284
- Protecting the cells of a worksheet 285
- Allow users to edit cm ranges 286
Use parts 289
- Introduction 290
- Authorize users to modify the same workbook simultaneously 290
- Protecting a shared workbook 291
- Modify a shared workbook 291
- Resolving conflicts 292
- Track changes 292
- Accept or reject changes 294
- Remove a user from a shared workbook 295
- Unshare a workbook 295
- Using the Accessibility Checker 295
Data entry optimization 297
- Creating a custom data series 298
- Modify/delete a custom data series 298
- Creating a drop-down list of values 299
- Determining permitted data 301
- Annotate cells 303
- Divide the contents of a cell over multiple cells 304
Hyperlinks 307
- Creating hyperlinks 308
- Activating a hyperlink 310
- Change/remove a hyperlink 311
Import/export 313
- Importing data from an Access database 314
- Import data from a web page315
- Importing data from a text file 316
- Refresh imported data 317
- Change refresh settings 318
- Activating a connection 319
- Manage existing connections 320
- Inserting an object from another application 321
- Export Excel data to another application 323
Macro commands 325
- Configure Excel to use macros 326
- Saving a macro 326
- Running a macro 327
- Assigning a macro to a graphic object 327
- Changing a macro 328
- Deleting a macro 329
- Saving a workbook with macros 329
- Activate a macro from the active workbook 329
Excel and the Web 331
- Introduction 332
- Save a workbook as a web page 332
- Publish a workbook 333
Adjust 335
- Moving the Quick Access Toolbar 336
- Customizing the Quick Access Toolbar 336
- Show/hide the ScreenTip 337
- Customize the status bar 338
- Customizing the Ribbon 338
- Export/Import a Custom Ribbon 341
Shortcuts 343
- Shortcuts 344
Best Practices for Creating Tables 348
- Basic Principles You Must Master 349
- Now I know the basics. How can I make optimal use of it? 350
- How can I safely distribute and share my data? 350
- How can I save time? 351
- How do I protect the environment? 352
Visual impression
Book this course
- Customers reward us with a 9,8
- Learn when you want
- Best price guarantee
€ 48,40 All-in-price
About the training institute
What is OEM ICT Training & Advice?
OEM ICT Training & Consultancy is the leading specialist in ICT training for businesses and individuals. From end users to IT professionals, we offer courses at every level. With over 200 brands in our portfolio—from Microsoft Office to Certified Ethical Hacker—we always have a suitable solution. Our focus on innovation ensures our training remains current and relevant. Our certified instructors have years of practical experience and guarantee quality and results.
What does OEM ICT Training & Advice do?
We offer comprehensive, customized IT training courses with official certifications from all major brands. We provide Microsoft Office training and exams in five languages: Dutch, English, French, German, and Spanish. We also offer flexible and practical learning paths for software like AWS, Adobe, AutoCAD, and IT security. Thanks to our short lines of communication and dedicated contacts, we are your reliable partner for all your IT training needs.
Why choose OEM Office Elearning Menu?
Nominated as 2nd Best Trainer in the Netherlands in 2024
Rated 9.0 in independent reviews
Official partner of Microsoft, EC-Council, Certiport and more
Microsoft Gold certified e-learning and ICT Award winning content
More than 3,500 satisfied customers – from self-employed to multinational
Best price for customized training from A-brands
OEM Office Elearning Menu is a recognized and proven training provider where quality, customization and results are central.
Our lesson formats:
E-Learning
Learn at your own pace with our interactive online modules – available 24/7. Ideal for official certifications from Microsoft, AWS, and CompTIA, among others.
Advantages: flexible, up-to-date and suitable for all levels.
Open Schedule
Attend classroom or online training sessions at pre-scheduled times with no obligation. Perfect for busy professionals.
Advantages: fixed dates, wide choice, direct entry possible.
In-Company Training
Customized on-site or online training, fully tailored to your team and learning goals.
Benefits: practical, efficient, aligned with business goals.
Virtual Classroom Training
Live online class from a certified trainer, with room for interaction and collaboration.
Benefits: personal contact, live guidance, completely online.
Blended Learning
Combine e-learning with guided sessions for maximum learning outcomes.
Benefits: flexibility and personal guidance.
Workplace support
Practical on-site assistance for direct questions and support with ICT tools and software use.
Benefits: immediate impact, efficiency and time savings.
Contest: Win a €100 Bol.com gift card!
Help us grow by sharing your experience!
Leave a review on Edubookers.com and you'll have a chance to win a €100 Bol.com gift card every month. Every review counts automatically – so entering is easy!
Is your IT knowledge still up to date?
Contact us and discover how we can take you or your team to the next level. At OEM Office Elearning Menu, you're guaranteed to work with a "real trainer." Moreover, we always deliver the best customized training from all major brands at the lowest price. We are a Microsoft Partner, EC Council Partner, and Certiport Partner, and provide Microsoft Gold-certified and ICT Award-winning e-learning. With over 3,500 satisfied customers, from sole proprietors to larger corporations, you're always guaranteed quality. They have given us an average rating of 8.8 in independent reviews.
OEM ICT Training & Consultancy is the leading specialist in ICT training for businesses and individuals. From end users to IT professionals, we offer courses at every level. With over 200 brands in our portfolio—from Microsoft Office to Certified Ethical Hacker—we always have a suitable solution. Our focus on innovation ensures our training remains current and relevant. Our certified instructors have years of practical experience and guarantee quality and results.
What does OEM ICT Training & Advice do?
We offer comprehensive, customized IT training courses with official certifications from all major brands. We provide Microsoft Office training and exams in five languages: Dutch, English, French, German, and Spanish. We also offer flexible and practical learning paths for software like AWS, Adobe, AutoCAD, and IT security. Thanks to our short lines of communication and dedicated contacts, we are your reliable partner for all your IT training needs.
Why choose OEM Office Elearning Menu?
Nominated as 2nd Best Trainer in the Netherlands in 2024
Rated 9.0 in independent reviews
Official partner of Microsoft, EC-Council, Certiport and more
Microsoft Gold certified e-learning and ICT Award winning content
More than 3,500 satisfied customers – from self-employed to multinational
Best price for customized training from A-brands
OEM Office Elearning Menu is a recognized and proven training provider where quality, customization and results are central.
Our lesson formats:
E-Learning
Learn at your own pace with our interactive online modules – available 24/7. Ideal for official certifications from Microsoft, AWS, and CompTIA, among others.
Advantages: flexible, up-to-date and suitable for all levels.
Open Schedule
Attend classroom or online training sessions at pre-scheduled times with no obligation. Perfect for busy professionals.
Advantages: fixed dates, wide choice, direct entry possible.
In-Company Training
Customized on-site or online training, fully tailored to your team and learning goals.
Benefits: practical, efficient, aligned with business goals.
Virtual Classroom Training
Live online class from a certified trainer, with room for interaction and collaboration.
Benefits: personal contact, live guidance, completely online.
Blended Learning
Combine e-learning with guided sessions for maximum learning outcomes.
Benefits: flexibility and personal guidance.
Workplace support
Practical on-site assistance for direct questions and support with ICT tools and software use.
Benefits: immediate impact, efficiency and time savings.
Contest: Win a €100 Bol.com gift card!
Help us grow by sharing your experience!
Leave a review on Edubookers.com and you'll have a chance to win a €100 Bol.com gift card every month. Every review counts automatically – so entering is easy!
Is your IT knowledge still up to date?
Contact us and discover how we can take you or your team to the next level. At OEM Office Elearning Menu, you're guaranteed to work with a "real trainer." Moreover, we always deliver the best customized training from all major brands at the lowest price. We are a Microsoft Partner, EC Council Partner, and Certiport Partner, and provide Microsoft Gold-certified and ICT Award-winning e-learning. With over 3,500 satisfied customers, from sole proprietors to larger corporations, you're always guaranteed quality. They have given us an average rating of 8.8 in independent reviews.
Check availability
Check out what other participants think of this course!
8,0/10
100% of 2 participants recommends!