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
File Size:
908.13 Kb
Downloads:
138
Submitted On:
2017-08-06



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.

Download File


Microsoft Word 2016 free tutorial

Download free Microsoft Word 2016 course material and training (PDF file 214 pages)

Download

Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners.

Download

PowerPoint 2013 course

Download Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners.

Download

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

Formulas & Functions in Microsoft Excel

Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott.

Download

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.

Download