Microsoft Excel 2007 Advanced - Tutorial
Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners.
Table of contents
- 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
- MODULE 4 TEMPLATES
- 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
- File Size:
- 908.13 Kb
- Submitted On:
Take advantage of this course called Microsoft Excel 2007 Advanced - Tutorial to improve your Office skills and better understand Excel.
This course is adapted to your level as well as all Excel pdf courses to better enrich your knowledge.
All you need to do is download the training document, open it and start learning Excel for free.
Microsoft Word 2016 free tutorial
Download free Microsoft Word 2016 course material and training (PDF file 214 pages)
Advanced Microsoft Excel 2013
Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners.
PowerPoint 2013 course
Download Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners.
Pivot Tables in Microsoft Excel
The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners.
Formulas & Functions in Microsoft Excel
Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott.
Excel 2016 Shortcuts
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.