Store.Tips.Net Tips.Net Store

ExcelTips E-books

Need to learn more about Excel in a hurry? Our ExcelTips e-books provide a great resource for discoverying new capabilities or simply honing your skills. Take a look at the titles we have to offer, and you'll quickly discover that Excel can do a lot more than most people believe.

The following items are available for the 'ExcelTips E-books' category. Click the item's title (shown in bold) or click the image for the item to see more details.

Excel Conditional FormattingExcel Conditional Formatting
Conditional formatting allows you to modify how information is displayed based upon criteria that you define. Excel Conditional Formatting is the definitive resource for understanding how to take advantage of this powerful feature of Excel.

Excel Custom FormatsExcel Custom Formats
The fundamental building block to displaying your data is the feature known as custom formats. Here is the definitive guide to mastering the formatting power in Excel.

Excel Filters and FilteringExcel Filters and Filtering
Excel provides two ways to filter your data so that only what you want to see is displayed. Discover how filtering works and how you can apply it to your needs.

Excel Graphics and ChartsExcel Graphics and Charts
Excel allows you to add all sorts of graphics to your worksheets or to convert your data into meaningful charts. Here's the definitive guide to adding the persuasive power of charts and graphics to your worksheets.

Excel Serious SortingExcel Serious Sorting
Sorting data means that you organize it in whatever order you desire. Excel's sorting feature can be used in a variety of ways, depending on the data you are working with.

ExcelTips: Amazing Array Formulas
Array formulas allow you to accomplish amazing things with your data, including things you cannot do with regular formulas. This guide gives you the information you need to master array formulas.

ExcelTips: Powerful Lookup FunctionsExcelTips: Powerful Lookup Functions
Want to access your data indirectly? The answer is to use Excel's lookup function. ExcelTips: Powerful Lookup Functions is a key resource in discovering how to use those functions.

ExcelTips: The MacrosExcelTips: The Macros
Macros provide a way for you to extend the capabilities of Excel. The key to macros is understanding how VBA works. ExcelTips: The Macros provides all the information you need to put macros to work.

ExcelTips: Times and DatesExcelTips: Times and Dates
Excel is great at storing all types of data, including times and dates. ExcelTips: Times and Dates provides the details you need to effectively work with this type of data.

Microsoft Excel VBA GuidebookMicrosoft Excel VBA Guidebook
Creating Excel macros allows you to extend your productivity with Excel. Visual Basic for Applications (VBA) is the programming language used for creating Excel macros. Here is your expert guide on how to finally master creating macros.

PivotTables for the Faint of HeartPivotTables for the Faint of Heart
PivotTables are a powerful tool for consolidating huge amounts of data. PivotTables for the Faint of Heart shows you how to condense that data so you can make sense of it.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.