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: | 2601 |
| Created: | 2017-09-24 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263
Others related eBooks about Microsoft Excel 2016 Course for Beginners
With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners.
Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages
Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf.
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download.