Home » Office » Microsoft Excel 2007 Advanced - Tutorial

Microsoft Excel 2007 Advanced - Tutorial

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

  • 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

Pages :
File type : pdf
Downloads: 793
Submitted On: 2017-08-06
License:
Author(s):

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.

This tutorial has been prepared for the beginners to help them understand basic Excel Office. After completing this tutorial you will find yourself at a moderate level of expertise in Excel from where you can take yourself to next levels.

This tutorial is designed for Excel students who are completely unaware of Excel concepts but they have basic understanding on Office training.

Download

Tutorials in the same categorie :