Microsoft Excel 2003 Tips'N Tricks
by Prophet Technologies Pty Ltd
Number of pages: 40
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.
Home page url
Download or read it online for free here:
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.
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.
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.
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.