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: | 1149 |
| Created: | 2017-08-06 |
Others related eBooks about Microsoft Excel 2007 Advanced - Tutorial
Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages
The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007.
Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf.
This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system.
The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners.