Microsoft Excel 2003 Tips'N Tricks
by Prophet Technologies Pty Ltd
2008
Number of pages: 40
Description:
This work is a collection of tips and tricks that may make using Microsoft Excel 2003 a little easier and interesting to use. This work describes how to easily create a series of numbers, view all the formulas on a worksheet, highlight a cell based on special conditions, use conditional (IF) formulas, count cells that meet your criteria, sum cells that meet only your criteria, hide worksheets, lookup answer in another table, freeze headings, and colour code worksheet tabs.
Download or read it online for free here:
Download link
(3.8MB, PDF)
Similar books
Excel 2010 Advanced
by Stephen Moffat - BookBoon
This manual should be used as a point of reference after following attendance of the advanced level Excel 2010 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.
(11078 views)
by Stephen Moffat - BookBoon
This manual should be used as a point of reference after following attendance of the advanced level Excel 2010 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.
(11078 views)
Excel 2010 Introduction
by Stephen Moffat - BookBoon
Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. These can range from simple formulae through to complex functions and mathematical models. This is an introductory level course.
(10348 views)
by Stephen Moffat - BookBoon
Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. These can range from simple formulae through to complex functions and mathematical models. This is an introductory level course.
(10348 views)
Microsoft Office Excel
by Torben Lage Frandsen - BookBoon
Contents: Introduction; A Small Reader's Guide; What is New in Excel 2007; First Look at Excel; Calculations; Copying cells; Formatting; Working with Tables; Charts; Working with Multiple Spreadsheets; Macros -- Automation; Advanced Excel.
(12796 views)
by Torben Lage Frandsen - BookBoon
Contents: Introduction; A Small Reader's Guide; What is New in Excel 2007; First Look at Excel; Calculations; Copying cells; Formatting; Working with Tables; Charts; Working with Multiple Spreadsheets; Macros -- Automation; Advanced Excel.
(12796 views)
Using Excel 2002
by Jean-Paul Van Belle
More advanced concepts of Excel: use the data entry tools, apply advanced cell formatting, use the built-in functions, absolute, relative and mixed cell references, assign and use range names, understand date and time arithmetic, and more.
(16869 views)
by Jean-Paul Van Belle
More advanced concepts of Excel: use the data entry tools, apply advanced cell formatting, use the built-in functions, absolute, relative and mixed cell references, assign and use range names, understand date and time arithmetic, and more.
(16869 views)