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 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.
(9995 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.
(9995 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.
(12431 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.
(12431 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.
(16554 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.
(16554 views)
How to Use Microsoft Excel
by Joseph M. Manzo
This is a textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel.
(9917 views)
by Joseph M. Manzo
This is a textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel.
(9917 views)