PDFtutorial
Free courses and tutorials to download for free as PDF files

Excel 2016 - Advanced Excel Tools in pdf

This booklet is the companion document to the Excel 2016: Advanced Excel Tools workshop. The booklet will explain how to create a simple macro, how to use nested formulas, how to create templates, hide/unhide rows and columns, and protect/unprotect your spreadsheets and workbook.

Learning Objectives

After completing the instructions in this booklet, you will be able to:

  • Understand what Nested Functions are.
  • Link data between sheets.
  • Understand what Macros are.
  • Create a simple Macro.
  • Hide/unhide information in your spreadsheet.
  • Protect your spreadsheet and workbook.
  • Create templates out of workbooks.

Course, tutorial Summary Excel 2016 - Advanced Excel Tools

Course material to download for free on Excel 2016 - Advanced Excel Tools category Excel.
This course is intended for a strictly personal use, the file is of format pdf level Advanced , the size of this file is 757.74 KB.

The site also offers courses in Excel 2007, 2010, 2013, 2016, charts, PivotTables and PivotCharts, Formulas, Data and Statistics, Pivot Tables, VLOOKUP, and IF functions and many other tutorials. You have to come and see our Excel. You will find your happiness without problem!



List of courses

Excel 2013: Advanced Excel Tools

Download free Microsoft Office Excel 2013 Advanced Excel tools, cours tutorial training, a PDF file by Kennesaw State University. - type of file pdf and size 667.47 KB, tutorial for level Advanced .


Excel 2016 - Advanced Functions & Modifying Spreadsheets

Download free Excel 2016 - Advanced Functions & Modifying Spreadsheets, course tutorial, training, a PDF file by Kennesaw State University. - type of file pdf and size 751.26 KB, tutorial for level Advanced .


Excel 2010 Advanced

Great course material and training Microsoft Excel 2010 Advanced, free to download (PDF file 168 pages) - type of file pdf and size 5.26 MB, tutorial for level Advanced .


Excel for advanced users

Download free Excel 2010 for advanced users course training (PDF file 175 pages) - type of file pdf and size 6.19 MB, tutorial for level Advanced .


New Features in Photoshop CS6 and Advanced Tools

Download tutorial New Features in Photoshop CS6 and Advanced Tools, free PDF course by University of Florida. - type of file pdf and size 2.6 MB, tutorial for level Beginner .


Microsoft Excel 2007 Advanced

Download free course Microsoft Excel 2007 Advanced material and training, PDF tutorial 95 in pages - type of file pdf and size 581.49 KB, tutorial for level Beginner .



Partner sites PDF Tutorials (English) | PDF Manuales (Spanish) | Cours PDF (French)