Microsoft Excel Microsoft Excel 2016 Course Book

Microsoft Excel 2016 Course Book

The Excel 2016 Course Book tells you in detail about all the different functions of Microsoft Excel 2016. The 2016 Course Book is intended for anyone who wants to work faster and more efficiently and thus gets the most out of Excel 2016.The Excel 2016 Course Book contains 392 pages, covering practical assignments and all subjects. View the Contents for an overview of all topics in the Excel 2016 Course Book. 

Content:

Environment 3
Exit Microsoft Office Excel 2016 5
Working with the File tab 6
Redoing previously undone actions 7 Change the display mode 9
Change the appearance of the formula bar 11
Change the zoom level 12
Display a worksheet in two different windows 13
Hide or show a window 14
Split the window 15
Workbooks 17
Create a workbook from a template 18
Open a workbook 20
Save a workbook 22
Using workbooks created in version older than Excel 2007 24
View change the properties of a workbook 28
Closing a workbook 31
Configuring Workbook AutoRecovery 31
Sending a workbook by email 33
Templates 35 Moving around in a worksheet 39
Finding a cell 40
Select rows columns 42 Entering constant data text, values, etc. 46
Insert the date time of the system clock in a cell 47
Entering the same content in multiple cells 48.
Creating a data series 49
Change data 52
Erasing the contents of the cells 53
Spell check 54 Copy cell contents to adjacent cells 58
Copy cells to other worksheets 59
Copy formats 63
Copy and transpose 64
Performing simple calculations while copying 65 Activate a worksheet 68
Change the color of the sheet tabs 68
Display an image as the background of the sheet 69
Insert add worksheets 71 Insert rows columns 73
Changing the width of the column the height of the row 73
Insert blank cells 74
Move and insert cells rows columns 74 Name cell range 78
Select a range of cells named 81. Introduction to the basics of formulas 83
Creating an absolute cell reference in a formula 84
Creating a formula containing a function 86
Adding a collection of cells 88
Creating a Simple Conditional Formula 89
Count cells that meet a specific criterion COUNTIF 93.
Using Named Boxes in Formulas 94 Perform calculations with date 99 data type
Using the Search Feature 104
Calculating the Value of a Recurring Payment 106
Creating a table with two entries 107
Using the Equation Editor 109
Scenario and target value 113 Displaying formulas instead of results 119
Evaluating formulas 121
Maintaining the relationships between formulas and cells 122
Solver 124
Defining and solving a problem with the Solver 125 Change the format of the characters
Adjust the format of the content
Create a custom format
Change the orientation of the cell contents
Align the cell contents Create cell borders 144
Applying a pattern to the background of cells 146.
Conditional formatting 149
Creating a conditional formatting rule 151
Removing all conditional formatting rules 155 Apply a cell still
Manage existing cell styles
Customize the theme colors Sort data of a table based on a criteria 166
Sort data of a table by multiple criteria 167 Activating the Autofilter 172
Filter Based on a Custom Criteria 175
Filter by multiple criteria 177
Filtering data using an enhanced filter 178
Format 181
Determining a print range 184
Repeat rows columns on every page 184
Creating a watermark 187 Using the print preview 190 Creating a chart 196
Changing the Location of the Graph 198
Changing the data source of the chart 199
Remove a data series from the chart 200
Changing the Source of the Labels on the X Axis 201
Create delete a sparkline chart 202 Select chart elements 207
Applying a predefined layout to a chart 207
Changing the X-axis Options 208
Adding a secondary vertical axis 211
Applying a quick style to the graph 213
Adding a trendline to a chart 214
Changing the format of a 3-D chart 218
Modifying a pie chart 220 Creating a graphic object 225
Insert a picture 227
Managing shapes of a SmartArt graphic 23 3 Selecting objects 237
Changing the formatting of an object 238
Crop an image 241
Adjusting the Resolution of an Image 245 Creating a data table 249
Resizing a data table 250
Add a row column to the table 250
Display a total row in a data table
Create a calculated column in a table 251
Deleting a data table including data 25 2
Pivot table 253
Managing the Fields of a PivotTable 256
Changing the Summary Function or Custom Calculation of a Field 260
Filtering a PivotTable Using a Report Filter 267
Changing the Layout Presentation of a PivotTable 276
Delete a pivot table 279
PivotChart 280
Deleting a PivotChart 282 Protecting a Workbook Using a Password 284
Protecting the cells of a worksheet 285 Introduction 290
Protecting a Shared Workbook 29 1
Resolving conflicts 292
Accept or reject changes 29 4
Unsharing a Workbook 295 Creating a custom data series 298
Creating a drop-down list of values ​​299
Annotate cells 303 Creating hyperlinks 308
Changing removing a hyperlink 31 1
Import export 313
Importing data from a web page 315
Refreshing imported data 317
Activating a connection 319
Inserting an object from another application 321 Configuring Excel to Use Macros 326
Running a macro 327
Modifying a macro 328
Saving a workbook with macros 329 Introduction 332
Publishing a workbook 333
Customize 335
Customizing the Quick Access Toolbar 336
Customize the status bar 338
Exporting Importing a Custom Ribbon 341
Shortcuts 343 Basics You Must Master 349
How can I safely distribute and share my data? 350
How do I protect the environment? 352