Microsoft Excel 2007 Advanced - Tutorial

Description:

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
Submitted On:
06 Aug 2017
File Size:
908.13 Kb
Downloads:
43
Submitted On:
06 Aug 2017
Rating:
Total Votes:0



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.

Keywords : Excel tutorial, Excel basics in pdf for beginners, Excel course in pdf, Excel training support in pdf, Download Excel tutorial in pdf.


Download File

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.

Download

Microsoft Excel 2016 Course for Beginners

Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf.

Download

Guide Excel 2010

A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages.

Download


Be the first to comment! Please sign in or register.