This course is a practical Guide Excel 2016 Level 1 for Beginners in PDF to download for free. The purpose of this training is to identify the elements of the Excel window, to create and format a table, to use a few simple calculation formulas and to print a table.
Table of contents
- Excel Basics
- Opening/Closing the file
- Saving the file
- Installing the “Analysis ToolPak” for PC
- Installing the “Analysis ToolPak” for Mac
- Entering data into Excel
- Simple cell formatting
- Entering data into cells
- Spreadsheet Organization
- Subscripts and superscripts
- Widening/condensing column widths
- Merge and center
- Wrapping Text
- Cell type
- Autofill with patterns
- Sorting data
- Using formulas and functions
- Built-in Functions
- Absolute and relative referencing
- Data visualization
- Inserting a scatter plot
- Gridlines and border styles
- Extracting tables and graphs
- Regression Tool in the Analysis ToolPak for PC/Mac
- Using the Analysis ToolPak for PC/Mac
| Size : | 824.82 Kb |
| Downloads: | 2578 |
| Created: | 2017-09-24 |
Others related eBooks about Microsoft Excel 2016 Course for Beginners
Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf.
With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners.
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download.
Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages