Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners.
Table of contents
- INTRODUCTION
- MODULE 2 NAMING RANGES
- Naming a cell, range or formula
- Moving to named range
- Pasting names in formulas
- Deleting a named range
- Paste a list of named ranges
- MODULE 3 FUNCTIONS
- if statements
- Text function
- Date and time
- Look up functions
- Financial functions
- Mathematical functions
- Exercices
- MODULE 4 TEMPLATES
- Creating
- Using template
- MODULE 5 AUDITING A WORKBOOK
- Checking data for error
- Finding data precedents
- Watch window
- MODULE 6 DATA VALIDATION
- Setting data validation
- Checking for invalid data
- MODULE 7 MACROS
- Overview of macro/vba
- Recording a macro
- MODULE 8 EXCEL’S ANALYTICAL TOOLS
- Solver
- INDEX
Size : | 908.13 Kb |
Downloads: | 1107 |
Created: | 2017-08-06 |
Others related eBooks about Microsoft Excel 2007 Advanced - Tutorial
With this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL.
Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages
Excel Fundamentals, it's a free PDF download about Microsoft Excel intended to beginners, document in 60 pages created by St. George’s Information Services.
Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks.
Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download.