Category Archives: Spreadsheets

Information about spreadsheet software.

Excel Gantt Charts

Posted on April 21, 2014 by Ron

Create a Gantt chart in Excel You don’t need specialized or expensive software to create a simple Gantt chart. Instead, you can use Excel. Project managers use a Gantt chart to display scheduled tasks and events in relationship to one … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Gantt Charts

Limit random records

Posted on April 8, 2014 by Ron

Pro tip: Limit random records by group in Excel, without VBA Limiting a random record set to a specific number of records per group isn’t hard if you combine a few Excel features. Meglitinide is a new course of medications … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Limit random records

Excel Ordinal Indicators

Posted on November 20, 2013 by Ron

Pro tip: Add an ordinal indicator to a value in Excel Use a formula or a series of conditional formatting rules to display ordinal indicators in Microsoft Excel. purchase cheap cialis http://ronaldgreenwaldmd.com/ Ginkgo extract treats circulation problems of impotence and … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Ordinal Indicators

Excel 2013 Data Modeling

Posted on November 14, 2013 by Ron

10+ steps to using Excel 2013’s new data modeling feature Use Excel’s new data modeling features to help you turn data into meaningful business information. Those pills which claim to increase the size of vessels and relaxing the muscles near … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel 2013 Data Modeling

Blank cells in Excel

Posted on September 30, 2013 by Ron

Quick Tip: Fill in blank cells in Excel quick and easy Blank cells can spell trouble. Here’s an easy way to fill in those blanks and protect the validity of your data. Out of all the factors the most important … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Blank cells in Excel

Excel Data Validation

Posted on August 30, 2013 by Ron

Use Excel’s Data Validation to display data entry tips for users   If you don’t like the way Excel displays comments, try using Doctor must be informed if a person wishes to buy buy viagra in bulk pills then they … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Data Validation

Multi Cell Array

Posted on March 6, 2013 by Ron

Excel Multi Cell Array Formula Step by Step Tutorial In Excel, an array formula carries out calculations on one or more elements in an array. Array formulas are surrounded by curly braces “{ } “. These are added to a … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Multi Cell Array

Creating a floating column chart

Posted on November 27, 2012 by Ron

An easy technique for creating a floating column chart in Excel This quick Excel technique turns an otherwise complicated charting requirement into a simple task. In most cases, erection buy cheap sildenafil problem occurs due to anxiety and nervousness. Moderate … Continue reading →

Posted in Spreadsheets | Tagged , , | Comments Off on Creating a floating column chart

Text To Columns

Posted on November 20, 2012 by Ron

Using Excel’s Text To Columns feature to clean up foreign data Work smart when cleaning up foreign data. Text To Columns can divide data and get rid of delimiters. When erections do not take place, then it is not a … Continue reading →

Posted in Spreadsheets | Tagged , | Comments Off on Text To Columns

Microsoft Excel Trinkets

Posted on September 17, 2012 by Ron

Shortcuts UPDATED: 2010.04.05.10:36 UTC The 10 most useful Excel keyboard shortcuts Shortcut Action [Alt] [Enter] Insert a new line within a cell [F2] Enable editing within a cell [Shift][F2] Add a comment to a cell [Ctrl] [F2] Open Print Preview … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Microsoft Excel Trinkets