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.

Course 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 Basicsd 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 Basicsd 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 Basicsd 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 Basicsd 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 dataBasics 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