Posts Tagged ‘MS Excel’
How to Automatically Add a Decimal Point in MS Excel
It’s so easy to enter numbers into an MS Excel cell and have Excel add the decimal point automatically for you. Select the Excel button. Select Excel Options. Click and select the Advanced options. Select the “Automatically insert a decimal point” check-box. Select the number of places from the drop-down list. You’re done. If you’ve…
Read MoreHow to Create Shortcuts to MS Office Files and Folders
© Ugur Akinci Creating shortcuts to MS Office files and folders is a great way to organize your content by providing multiple navigation points to the same document. Shortcuts eliminate the need to have the multiple copies of the save document in multiple locations. With this method, when you edit the source file, all shortcuts…
Read MoreHow to Use Structured References in MS Excel
How to use structured references in MS Excel is a skill that you should develop to maximize your productivity when using MS Excel. MS Excel has three types of ways to refer to a data cell: Relative reference (like B1) Absolute reference (like $B$1) Structured reference (you need to use a table) “Why should I…
Read MoreHow to Create a MS Excel Pivot Table – An Introduction
Creating a MS Excel Pivot Table is very easy if your data is in proper TABULAR LAYOUT FORMAT. Here is a sample table representing the imaginary Atlantic and Pacific region sales of a fictitious fish company. (Click to enlarge the images) As you can see, it’s not easy to look at this data and answer…
Read MoreHow to Format Your Tabular Data Properly for MS Excel Pivot Table
Pivot Table is a great feature of MS Excel. It allows you to analyze your data and find interesting relationships and patterns that may not be so obvious originally. It’s a great data mining tool that’s built right into MS Excel 2010. However, before you can make your data shine through the magic touch of…
Read MoreHow to Create and Update a MS Word Chart
Here is a good way to create a MS Word chart that you may need to edit at some point in the future. The KEY IDEA is this: create your chart in MS Excel and then copy-paste it into your Word document. That way, the chart will maintain a link to the Excel document. Anytime…
Read MoreHow to Punctuate Items Listed in a Table Cell or Unordered List
Punctuation of table cell or unordered list items presents a special problem in technical writing since more often than not such lines include technical specs. Punctuation questions, like whether to end each line with a period or not, acquires a special significance since Parallelism “Parallelism” is one of those cardinal rules in technical writing. In…
Read MoreMicrosoft Excel 2010 – New Features to Analyze Data
MS Excel – How to Add Names and Addresses to a Searchable Database
© 2009 Ugur Akinci If you’d like to create a searchable address database in MS Excel, the best way to do it is to assign a separate column to every data component with which you’d like to sort or search your database. For example, here is a good example of how to do it: In…
Read More
How to Concatenate Excel Text in Different Cells
Introduction Knowing how to concatenate the content of different Excel cells can save you a lot of headaches. Imagine you have the name of your company in cell A1, and, the address in F1, but you would like to add the address to the company name and display them in a new cell, D1. This…
Read More