Cart
You have no items in your shopping cart
Microsoft Excel Microsoft Excel 2013 Course Book
Microsoft Excel 2013 Course Book
€47,50

Cheaper somewhere else?

Let us know!

+31367601019 [email protected]

Microsoft Excel 2013 Course Book

|
Click to enlarge
€47,50 Excl. tax
€51,78 Incl. tax
In stock
|
Ordered before 16:00, delivered tomorrow.
You have got counting... hours
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Information

Microsoft Excel 2013 Course Book

This practical Excel 2013 Course Book tells in detail about all the different functions of Microsoft Excel 2013. The Excel 2013 Course Book is intended for anyone who wants to work faster and more efficiently and thus gets the most out of Excel 2013.

The Excel 2013 Course Book contains 405 pages, in which practical assignments and all subjects are discussed. View the Contents for an overview of all topics in the Excel 2013 Course Book.

Content:

Environment 3
Start Microsoft Office Excel 2013 4
Exit Microsoft Office Excel 2013 5
Using / Managing the Ribbon 5
Working with the File tab 6
Undo the last actions 6
Redo previously undone actions 7
Repeat the last action 7

Display 8
Change the display mode 9
Enter full screen mode 10
Change the display of the formula bar 11
Show / hide the gridlines and headings of rows and columns 12
Change the zoom level 12
Activate a window 13
View a worksheet in two different windows 13
Rearrange the view of the windows 13
Hide or show a window 14
Block / unblock rows and / or columns 14
Split the window 15

Workbooks 17
Create a new blank workbook 18
Create 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
Use Excel 2013 workbooks in older Excel versions 23
Use workbooks created in an older version 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
Choose the default workbook 31
Configure auto workbook recovery 31
Restore an earlier version of a file 32
Send a workbook by email 33

Templates 35
Create a custom workbook template 36

Move / Select 38
Moving around in 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
Enter constant data (text, values, etc.) 46
Enter special characters 47
Insert the system clock date / time into a cell 47
Use the Auto-Complete Cell Values ​​Function 47
Enter the same content in multiple cells 48
Beginning a new line in a cell 48
Create a data series 49

Change data 52
Change 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 automatic spelling correction 55

Copy and move 57
Copy a cell contents to adjacent cells 58
Copy / move cells 58
Copy cells to other worksheets 59
Using the Office Clipboard 60
Copy formatting 63
Copy the contents, results and / or formatting of cells 63
Copy and transpose 64
Copy Excel data and make a link 64
Perform simple calculations during copying 65
Copy data as picture 65

Worksheets
Activate 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
Move / copy one or more worksheets 70
Insert / add worksheets 71
Deleting worksheets 71

Rows, columns, cells 72
Insert rows / columns 73
Delete rows / columns 73
Change the width of the column / the height of the row 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
Delete rows that contain duplicates 75

Naming subjects 77
Naming cell range 78
Managing cell names 79
Select a range of cells named 81
View the list of names and references of grouped cells 81

Calculations 82
Participation in the basic principles of formulas 83
Create a simple formula 83
Create an absolute cell reference in a formula 84
Entering a formula with data from multiple worksheets 85
Create a formula that contains a function 86
Using the Auto-Complete Formula function 87
Adding a collection of cells 88
Using simple statistical functions 89
Create a simple conditional formula 89
Create a nested conditional formula 91
Count 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 date data type 99
Perform calculations on time type data 103
Using the Search function 104
Merging data 105
Calculating the value of a recurring payment 106
Calculating the value of borrowed capital 107
Create a two-entry table 107
Using an array formula 108
Using the equation editor 109

Scenario and target value 113
Reaching a Target Value 114

Error check 118
Show formulas instead of results 119
Finding and fixing errors in a formula 119
Evaluating formulas 121
Use Control Window 121
Tracking relationships between formulas and cells 122

Solver 124
Discover and activate the Solver Add-in 125
Define and solve a problem with the Solver 125
Show Intermediate Solutions of Solver 129

Change default formatting
Change the format of the characters Change 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 in the Merge Cells cell contents

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
Apply a predefined conditional format 150
Create a conditional formatting rule 151
Formatting cells based on the content 154
AI Remove All Conditional Formatting Rules 155
Managing conditional formatting rules 156

Styles and themes
Apply a cell still
Make a still
Manage existing cell styles
Apply a theme to a workbook
Customize the theme colors
Customize the theme fonts Customize the theme effects Save a theme

Sorting and overviews 165
Sort table data based on a criterion 166
Sort data by a cell color, by font, or by an icon set 166
Sort table data by multiple criteria 167
Create an overview 169

Data filter 171
Activating the AutoFilter 172
Filter data by content or format 172
Filtering based on an adjusted criterion 175
Apply specific filters to certain data types 176
Filtering on multiple criteria 177
Deleting a filter 178
Filtering data using an extended filter 178

Layout 181
Change page layout options 182
Determining a print range 184
Inserting / Deleting 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
Create a graph 196
Activate / Deactivate An Embedded Graph 198
Change the location of the grave leak 198
Invert data of a graph 198
Change the data source of the graph 199
Add one or more data series to the graph 199
Remove a data series from the graph 200
Changing the Order of Data Series in the Grave 200
Changing the Source of the Labels on the X Axis 201
Manage chart templates 201
Create / Delete a Sparkline Graph 202
Change a sparkline 204

Chart options 206
Selecting chart elements 207
Changing a chart / series type 207
Applying a predefined format to a chart 207
Show / Hide Chart Elements 208
Changing the x-axis options 208
Change the Y axis 210
Add a secondary vertical axis 211
Change data labels 212
Apply a quick style to graph 213
Changing the Format of Numeric Values ​​in a Graph 214
Add a trendline to a graph 214
Change the text direction in an element 217
Changing the layout of a 3D graph 218
Changing the Direction / Perspective of a 3D Graph 219
Changing a pie chart 220
Connecting the points of a curve type graph 223

Chart objects 224
Create a graphic object 225
Inserting an image file 227
Insert a picture 227
Insert a screenshot 229 Insert a SmartArt picture 231
Managing Shapes of a SmartArt Graphic 233
Change the general presentation of the SmartArt graphic 234

Object management 236
Selecting objects 237
Managing objects 237
Change the format of an object 238
Adjusting the layout of an image 240
Crop an image 241
Remove the background from an image 244
Adjusting the resolution of an image 245
Formatting the Characters of an Object 246


Data table 248
Create a data table 249
Naming the data table 249
Resizing a data table 250
Show / Hide table headers 250
Add a row / column to table 250
Select rows / columns in a data table 250
Display a total row in a data table Create 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
Delete a data table including data 252

Pivot table 253
Create a pivot table 254
Manage the fields of a pivot table 256
Insert a calculated field 259
Change the summary function or custom calculation of a field 260
Use of the totals and subtotals fields 264
Filter a pivot table using a report filter 267
Grouping PivotTable Data 273
Change the layout / presentation of a pivot table 276
Recalculate a Pivot Table 278
Deleting a Pivot Table 279

Pivot chart 280
Create a pivot chart 281
Removing a Pivot Grip 282
Filter a pivot chart 282

Protect 283
Protect a workbook using a password 284
Protect the items of a workbook 284
Protect the cells of a worksheet 285
Allowing Users to Edit Ranges 286

Use parts 289
Introduction 290
Authorize users to change the same workbook simultaneously 290
Secure a shared workbook 291
Change a shared workbook 291
Resolving conflicts 292
Track changes 292
Accept or ignore changes 294
Removing a user from a shared workbook 295
Stop sharing a workbook 295
Using the accessibility check 295

Data entry optimization 297
Create a custom data series 298
Modifying / Deleting 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
Create hyperlinks 308
Activate a hyperlink 310
Change / remove a hyperlink 311

Import / export 313
Importing data from an Access database 314
Import data from a web page 315
Importing data from a text file 316
Refreshing imported data 317
Change refresh settings 318
Activate a connection 319
Manage existing connections 320
Insert an object from another application 321
Export Excel data to another application 323

Macro commands 325
Configuring Excel to use macros 326
Save a macro 326
Run a macro 327
Assign a macro to a graphic object 327
Modify a macro 328
Delete a macro 329
Save a workbook with macros 329
Activate a macro of the active workbook 329

Excel and the Web 331
Introduction 332
Save a workbook as a web page 332
Publishing a workbook 333

Adjust 335
Move the quick access toolbar 336
Customizing the Quick Access Toolbar 336
Show / Hide Screen Tips 337
Customize the status bar 338
Adjusting the Ribbon 338
Export / Import a Custom Ribbon 341

Hot keys 343
Hot keys 344

Best Practices for Creating Tables 348
Basics You Must Master 349
Now I know the basics. How can I make the most of it? 350
How can I securely distribute and share my data? 350
How can I save time? 351
How do I protect the environment? 352

 

Heeft u niet gevonden wat u zocht?
Let us help!
Reviews
average of 0 review(s)
No reviews found
Read or write a review
Write a review




Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »