Articles & Guides

Deep dives into Excel features and workflows.

Filter by tag
Showing 225 of 225 articles
AI in Excel
2026-03-10

Claude for Excel Review: Best for Complex Models and Error Tracing?

Review Claude for Excel for complex models, error tracing, and careful workbook analysis, including the limits that still matter in beta....

#ai#claude#formulas#review#spreadsheets
3 min read
Read Article
AI in Excel
2026-03-06

ChatGPT for Excel: What It Does Well and Where It Still Needs Review

Review ChatGPT for Excel after the March 5, 2026 launch and see where it helps most with formulas, workbook analysis, and spreadsheet workflows....

#ai#chatgpt#formulas#spreadsheets
3 min read
Read Article
AI in Excel
2026-03-03

Gemini vs ChatGPT for Spreadsheet Analysis

Compare Gemini vs ChatGPT for spreadsheet analysis, including uploaded Excel files, cross-platform workflows, summaries, and verification risks....

#ai#gemini#chatgpt#comparison#spreadsheets
3 min read
Read Article
AI in ExcelFormulas
2026-02-26

How to Use =COPILOT in Excel

Learn how to use the =COPILOT function in Excel, what kinds of prompts work best in cells, and where this feature still needs careful review....

#ai#copilot#formulas#microsoft-365
3 min read
Read Article
AI in Excel
2026-02-17

Copilot in Excel vs ChatGPT: Which Is Better for Real Spreadsheet Work?

Compare Copilot in Excel vs ChatGPT for workbook analysis, formula help, messy data, privacy tradeoffs, and day-to-day spreadsheet work....

#ai#copilot#chatgpt#comparison#spreadsheets
4 min read
Read Article
AI in Excel
2026-02-05

How to Upload an Excel File to ChatGPT and Analyze It Safely

Learn how to upload an Excel file to ChatGPT safely, what kinds of workbook questions it handles well, and what you still need to verify manually....

#ai#chatgpt#file-analysis#privacy#cleanup
4 min read
Read Article
AI in ExcelFormulas
2026-01-22

Can AI Fix Broken Excel Formulas? Real Tests With VLOOKUP, XLOOKUP, and SUMIFS

I tested whether AI can fix broken Excel formulas in real scenarios involving VLOOKUP, XLOOKUP-style logic, and SUMIFS errors caused by dirty data....

#ai#formulas#troubleshooting#benchmark#vlookup
4 min read
Read Article
AI in ExcelFormulas
2026-01-08

How to Use AI to Explain Excel Formulas Step by Step

Learn how to use AI to explain Excel formulas step by step, including how to verify the explanation and catch what the model still gets wrong....

#ai#formulas#chatgpt#copilot#troubleshooting
3 min read
Read Article
AI in ExcelFormulas
2025-12-18

Best AI for Excel Formulas: Copilot vs ChatGPT vs Claude

Compare Copilot, ChatGPT, and Claude for Excel formulas using the same prompt, the same workbook task, and the same verification standard....

#ai#formulas#copilot#chatgpt#claude#comparison
4 min read
Read Article
AI in ExcelTroubleshooting
2025-12-04

Why Copilot Is Not Working in Excel: Common Fixes and Requirements

Fix the most common reasons Copilot is not working in Excel, including table setup problems, licensing issues, platform limits, and messy workbook structure....

#ai#copilot#troubleshooting#microsoft-365
4 min read
Read Article
AI in Excel
2025-11-20

How to Use Copilot in Excel for Formulas, Analysis, and Cleanup

Learn how to use Copilot in Excel for real workbook tasks such as formula writing, data cleanup, and quick analysis without trusting the first answer blindly....

#ai#copilot#formulas#cleanup#data-analysis
4 min read
Read Article
AI in ExcelAdvanced
2025-11-14

AI in Excel: Practical Guide to Copilot, ChatGPT, Claude, and Gemini

Learn how to use AI in Excel with Copilot, ChatGPT, Claude, and Gemini. Compare strengths, limitations, use cases, and how to verify AI-generated formulas, analysis, and automation....

#ai#copilot#chatgpt#claude#gemini#data-analysis#automation
16 min read
Read Article
BeginnerFormulas
2024-11-26

Currency Conversion Using Live Exchange Rates in Excel and Google Sheets

This guide covers step-by-step practical instructions, for efficient multiple currency conversion with live exchange rates in Excel and Google Sheets....

#currency
14 min read
Read Article
Beginner
2024-02-28

How to Remove Last Saved By Information from an Excel File on Mac and Windows

Learn how to remove Last Saved By info from Excel files on Mac and Windows to maintain privacy when sharing documents. Follow our easy guide....

#excel-tips#privacy#security
3 min read
Read Article
Time and Date
2024-01-02

4 Methods to Insert a Timestamp in Excel Cell

Explore easy methods to insert timestamp in Excel. Learn shortcuts, formulas, and VBA for effective data tracking in our concise guide....

#date#excel-shortcuts#time#timestamp#tips
5 min read
Read Article
Beginner
2023-12-04

TRUNC Function in Excel: A Comprehensive Guide

Discover the power of Excel TRUNC function with this comprehensive guide. Learn practical applications, and excel at truncating numbers in Excel....

#functions#trunc
7 min read
Read Article
Beginner
2023-10-16

Excel Worksheets: A Beginner's Guide

Want to start using Excel worksheets? With this guide, you can get a basic understanding of what worksheets are and how to make them work for you....

#worksheets
4 min read
Read Article
Formulas
2023-10-09

VLOOKUP Not Working with Text Values: 6 Fixes You Need

Fix your VLOOKUP not working with text issue using our troubleshooting tips. Don't let #N/A or #VALUE errors stop you from getting accurate results....

#functions#lookup
11 min read
Read Article
BeginnerFeatures
2023-09-18

Learn How to Add In Excel Using the SUM Function and AUTOSUM

We focus here on the SUM function and AUTOSUM feature, demonstrating how these tools are essential for understanding how to add in Excel....

#add#sum
5 min read
Read Article
General Updates
2023-05-16

How to Get Excel for Free (Including Best Free Excel Alternatives in 2023)

Is Microsoft Excel free? Learn how to access Microsoft Excel for free and discover Excel free alternatives in 2023....

#excel#excel-alternatives#google-sheets
7 min read
Read Article
Intermediate
2022-01-31

How to Create a Drop Down List in Excel with Data Validation

Are you wondering how to create a drop down list in excel? Don't worry. Our step-by-step guide tells you everything that you need to know....

6 min read
Read Article
FormulasIntermediateTime and Date
2022-01-21

How to Calculate Hours Between Two Dates and Times in Excel

Learn how to calculate hours between two dates and times in Excel using simple formulas for elapsed time, decimal hours, overnight shifts, and workdays....

#time#tips
5 min read
Read Article
General Updates
2020-06-13

How to Convert Excel to Google Sheets

Google Sheets gives you several excellent features, but there may be a time where you need to know how to convert Excel to Google Sheets....

8 min read
Read Article
FormulasGeneral Updates
2020-05-01

The Data Adds Up: Using the Addition Formula in Excel

In this article you'll learn the basic addition formula for Excel with examples and a how-to guide for entering formulas and using the sum feature....

#addition-formula-in-excel
6 min read
Read Article
FormattingGeneral Updates
2020-04-02

Pivot Charts: An All-Encompassing Guide

Pivot charts are often the best way to spot trends or errors, and a better way to present your data. Here's everything you need to know to make them in Exel...

#charts#excel-pivot-chart#pivot-table
6 min read
Read Article
Formulas
2020-03-12

HLOOKUP In Excel: Everything You Need to Know

If you're looking on how to use hlookup in excel, you came in to the right place! In this article, we discussed on how to use it and it's common problem....

#hlookup-in-excel
6 min read
Read Article
FeaturesProduct
2019-11-06

The Best Excel Book to Purchase from Amazon

We have compiled a list of the ten best Excel book options that can help you use Excel with ease and to its full potential. Check this out!...

11 min read
Read Article
Formulas
2019-10-31

How to Create a Database in Excel

Excel database files are useful for creating simple tables or spreadsheets based on numbers and formulas. Learn here on how to create a database in excel....

8 min read
Read Article
General Updates
2019-10-24

Google Sheets vs Excel: How Do They Differ?

Google Sheets vs Excel? Check here for the similarities and differences between the two to help you choose which program is right of your budgeting needs....

8 min read
Read Article
Features
2019-10-22

The History of Microsoft Excel: How It Came to Be

Excel is a popular spreadsheet system, which organizes data in columns and rows. Learn more here about the history of Microsoft excel....

8 min read
Read Article
General Updates
2019-10-16

What to Do When Excel Keeps Crashing

Excel hangs or freezes when you open an Excel workbook. Well, this is a very frustrating issue. Learn more common issues why excel keeps crashing....

8 min read
Read Article
General Updates
2019-09-25

How to Find Outliers in Excel in 5 Easy Steps

This article will give you a walk-through on how to find outliers in Excel and why finding outliers is an essential piece of data analytics in statistics....

8 min read
Read Article
General Updates
2019-08-22

How to Calculate Z Score in Excel: What You Need to Know

Getting some clarity on the topic will make it that much easier to learn how to calculate a z-score in Excel when the time comes....

9 min read
Read Article
General Updates
2019-08-16

How to Find Variance in Excel? Follow These Tips

Knowing how to find variance in Excel is a helpful skill to have while designing any spreadsheet, especially if one understands the nuances of the function....

8 min read
Read Article
General Updates
2019-08-16

How to Print Labels from Excel: Ultimate Guide

By following instructions on how to print labels from Excel, you'll be able to quickly and easily print any label from Excel....

8 min read
Read Article
BeginnerFormatting
2019-07-04

How to Add a Row in Excel: Step by Step Process

Microsoft Excel is a great tool to use for work, school and even for personal data purposes. In case you're wondering, here's how to add a row in excel....

8 min read
Read Article
FeaturesIntermediate
2019-06-20

How to Remove Duplicates in Excel: An Easy Guide

Are you wondering how to remove duplicates in Excel? Check out our easy guide for step by step instructions and all the information you need....

#tips
3 min read
Read Article
Features
2019-06-20

How to Round Numbers in Excel: What You Need to Know

Use Excel’s feature to round decimals or large numbers in a spreadsheet. In this article, we'll show you how to round numbers in Excel....

#round#round-numbers#round-up-numbers
6 min read
Read Article
BeginnerFormulas
2019-06-20

The NOW Function in Excel: What It is and How to Use It

Are you wondering how to use the now function in Excel? Look no further. Our easy step-by-step guide has all of the information that you need to know....

#tips
3 min read
Read Article
BeginnerFormatting
2019-06-19

How to Hide Columns in Excel

As great as columns are in Excel you don’t always need to see every single one. Let’s take a look at how to hide columns in Excel, and unhide them too....

#columns#excel#formatting#hide-columns#how-to-hide-columns-in-excel
6 min read
Read Article
Beginner
2019-06-13

How to Randomize a List in Excel: Our Complete Guide

How to randomize a list in excel? How would you do it? In this article, we listed our complete guide to help you on this kind of formula....

8 min read
Read Article
General Updates
2019-03-29

Sort Your Life into Neat Little Boxes with These Excel Basics

Jobs nowadays require basic knowledge of Excel. Spark your skills with these excel basics we have on this article that will surely speed up your workflow....

28 min read
Read Article
BeginnerFeaturesGeneral Updates
2018-06-25

How to Delete Duplicates in Excel: An Easy Guide

Learn how to easily delete duplicates in Excel with our step-by-step guide. Remove duplicate entries and keep your spreadsheets clean and organized....

#delete#deleting#duplicate#excel#how-to-delete-duplicates-in-excel
6 min read
Read Article
Advanced
2018-06-20

Ready, Set, Scatter: How to Make a Scatter Plot in Excel

This article consists of all the basics of how to make a scatter plot in Excel. By using the guide, readers will be able to generate their own plots as well as format them and add design features....

#excel#how-to-make-a-scatter-plot-in-excel#scatter-plot
7 min read
Read Article
BeginnerFeaturesFormatting
2018-06-14

How to Freeze A Row in Excel: A Practical Guide

Learn to how to freeze a row in excel (or even more than 2 rows) using this practical how-to guide. Excel has an available feature allowing users the ability to freeze a row....

#excel#freeze#freeze-row#freezing-rows-vs-splitting-panes#how-to-freeze-a-row-in-excel#row
8 min read
Read Article
Formatting
2018-06-14

How to Freeze Cells in Excel So Rows and Columns Stay Visible

Do you often work with long rows & columns of data? Minimize the time you spend scrolling up, down, and sideways by learning how to freeze cells in Excel!...

#columns#excel#formulas#freeze-columns#freeze-rows#functions#how-to-freeze-cells-in-excel#keep-visible#rows#stay-visible#tips
7 min read
Read Article
Features
2018-06-14

How to Use Goal Seek in Excel

Use this guide to learn how to use goal seek in excel as well as how to put it into action. To use Goal Seek, you will have to open a new sheet....

#excel#excel-update#excel-web-app#functions#goal-seek-function#how-to-guide#how-to-use-goal-seek-in-excel#tips
5 min read
Read Article
AdvancedFormattingIntermediate
2018-06-13

How to Alphabetize in Excel: Fast & Simple

Using Excel we can properly organize data for our businesses or personal finances. Learn how to alphabetize in excel so it is easy to read and refer back to whenever necessary....

#alphabetize#excel#excel-tips#how-to-alphabetize-in-excel#tips-and-tricks-on-excel
12 min read
Read Article
BeginnerFeatures
2018-06-13

How to Make a Line Graph in Excel

Organize data by learning how to make a line graph in Excel. Present information over time with this simple guide to creating a line graph....

#excel#graph#how-to-make-a-line-graph-in-excel#line-graph
9 min read
Read Article
BeginnerFormulas
2018-06-13

How to Subtract in Excel

Learn how to subtract in Excel with this valuable how-to guide. This article will walk you through each step of the process from start to finish....

#excel#how-to-guide#how-to-subtract-in-excel#subtract
6 min read
Read Article
FormulasGeneral Updates
2018-06-01

Excel SUM Formula: What Is It And When Do I Use It?

Perhaps one of Excel's best-known functions is the SUM formula. Learn more about a subset of data by totaling rows, columns and more with excel sum formula....

6 min read
Read Article
BeginnerFeatures
2018-05-23

5 New and Creative Ways To Utilize Excel

Excel is a program that is beneficial to anyone who wants to organize the utility bills or for professionals who need to stay organized at the office. To most Excel users, it can seem like a pretty cut and dry program. W...

8 min read
Read Article
BeginnerFeatures
2018-05-09

The 20 Most Useful Excel Shortcuts to Utilize

Do you use Excel every day but working with it seems slow and tedious? Learn 20 Excel shortcuts that help make creating spreadsheets faster and easier to do....

#excel#excel-shortcuts
8 min read
Read Article
FeaturesFormattingIntermediate
2018-05-08

Pivot Tables (PV Table): Everything You Need to Know

When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...

#excel#functions#pivot-table#pv-table#sheet
6 min read
Read Article
BeginnerFeaturesFormatting
2018-05-02

Learn How to Unhide Cells in Excel Using Keyboard Shortcuts or the Home Menu

Learn how to unhide columns in Excel using keyboard shortcuts or the Home Menu methods. While Excel does not allow you to Hide and Unhide individual cells using the Hide/Unhide command, here’s a trick showing how to hide...

#column#excel#hide-column#how-to-unhide-columns-in-excel#unhide-column
6 min read
Read Article
AdvancedFeaturesFormatting
2018-04-25

The Drop Down Basics: How to Make a Drop Down List in Excel

This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. You can follow the instructions to create a new dropdown list...

#dropdown#excel#how-to-make-a-drop-down-list-in-excel#list
7 min read
Read Article
BeginnerFormulas
2018-04-17

How to Use the AVERAGE Function in Excel

To figure out the average of a group of numbers, makes it easier for you to analyze important data. Learn how to use the average function in Excel right here....

#average#functions
6 min read
Read Article
General Updates
2018-03-31

How to Move Columns in Excel While Keeping Your Data Intact

Ready to hone your skills in working with Excel spreadsheets for a more organized workflow? Start with learning how to move columns in Excel. This especially helps with columns containing large swaths of data....

#copy#cut#drag-and-drop#how-to-move-columns-in-excel#selection
6 min read
Read Article
Formatting
2018-03-30

How to Add Cells in Excel to Sum Up Totals Automatically

Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers....

#excel#excel-2003#excel-2007#excel-2010#excel-2011#excel-update#formulas#functions#tips
5 min read
Read Article
Formatting
2018-03-28

How to Merge Cells in Excel (and Split Them) for Better Layouts

Do you want to make your Excel spreadsheets more presentable? Here are a few useful tips on how to merge cells in Excel that would surely make your work look tidier....

#excel#merge-cells#split-cells#spreadsheet#unmerge-cell
6 min read
Read Article
FormattingFormulas
2018-03-27

How to Use the SUMIF and SUMIFS Functions in Excel

Lessen the time it takes to compute complex equations with the SUMIF and SUMIFS functions on MS Excel. This update may be just what you've been waiting for. Follow this in-depth, easy-to-follow guide to get started...

#criteria#excel-update#formulas#functions#range#sumif
5 min read
Read Article
Product
2014-06-17

Excel for iPad - Paste as Values

A description of my Office for iPad experience with Excel Paste as Values functionality and my decision to get an Office 365 Personal account....

#excel-for-ipad#office-for-ipad#onedrive
4 min read
Read Article
Features
2013-04-28

Where is Control+Home for Excel on a Mac

The control + home keyboard shortcut in Excel for Windows is replicated in Excel for Mac by either fn+control+left arrow or fn+command+left arrow....

#excel-2011#tips
2 min read
Read Article
FormulasTime and Date
2013-02-15

Excel Fractional Part: Extracting Integers and Fractions in Excel

Sometimes you need to extract the integer or decimal part of a number. Sometimes the fractional part. Check this guide on Excel fractional part....

3 min read
Read Article
FormulasTime and Date
2012-11-01

Extract Time from datetime with the MOD Function in Excel

Use the MOD function in Excel to extract a Time value from a Date-Time number. Change the cell formatting to get the time format of your choosing....

#time
1 min read
Read Article
IntermediateTime and Date
2012-10-10

How to Extract Time from DateTime values in Excel

Discover how to skillfully extract time from datetime values in Excel. Learn simple techniques to manage and analyze your data efficiently in this step-by-step guide....

#time
3 min read
Read Article
IntermediateTime and Date
2012-09-16

Extract Date from DateTime Number in Excel

You can extract the Date value from a Date-Time number using the INT function in Excel. Then change the cell formatting to a Date format....

2 min read
Read Article
Intermediate
2012-07-07

Add Macro Button to the Toolbar in Excel 2011

Here is a short tutorial on how to add a macro button to the toolbar in Excel 2011, with a few tips on how to change the button image....

#excel-2011#tips#vba
2 min read
Read Article
FeaturesIntermediate
2012-06-30

Control + Home in Excel for Mac

I figured out how to get a Control + Home keyboard shortcut to work in Excel 2011 (for Mac). It's an Excel Windows favorite of mine....

#excel-2011#keyboard-shortcuts#tips#vba
5 min read
Read Article
FormulasProduct
2012-04-24

Break Even Calculation with an Unlocked iPhone and International Rates

When on Holiday in the UK pick up a Sim card for your unlocked iPhone. Make the smart move with simplicity plans by O2: talk, text, data....

#tips
2 min read
Read Article
FormulasIntermediate
2012-04-09

A Dynamic Dependent Drop Down List with a Horizontal Table Reference

I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the "table headers were actually rows and not columns?" Since...

#excel-2007#excel-2008#excel-2010#excel-2011#names
3 min read
Read Article
Formulas
2012-03-25

The VLOOKUP Function - Inside Out

Learn the VLOOKUP function in Excel by looking at the four arguments in reverse order....

#tips
4 min read
Read Article
FormulasIntermediate
2012-03-22

How to Update a List or Range without OFFSET

I avoid the use of Volatile Functions , especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook....

#excel-2003#excel-2007#excel-2008#excel-2010#excel-2011#vba
3 min read
Read Article
BeginnerIntermediate
2012-03-20

Select Excel's Used Range on a Mac

Selecting the used range in an Excel worksheet is complicated by not having a Home button on the Mac keyboard. Some VBA code can solve this problem....

#excel-2008#excel-2011#keyboard-shortcuts#vba
4 min read
Read Article
Advanced
2012-02-29

Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]

This VBA code checks to see if the Analysis TookPak Add-In is installed in Excel 2003 when the file is opened, and will notify the user if not....

#excel-2003#excel-2007#excel-2010#tips#vba
3 min read
Read Article
General Updates
2012-01-06

An Excel Crossroads - Mac and Windows

The Mac is my computer of the future but I need Windows versions of Excel, so enter Parallels software to make things easy to decide the issue....

#excel-2003#excel-2007#excel-2008#excel-2010#excel-2011#mac-os-x#macbook-pro#parallels#windows-7
3 min read
Read Article
Advanced
2011-12-20

Select a Column of Non-Sequential Data

This macro will select a column of non-sequential data when the active cell is located in the column heading....

#tips#vba
2 min read
Read Article
General Updates
2011-12-01

Microsoft Office on the iPad

An Excel app from Microsoft may be coming in 2012 according to the latest buzz....

#excel#ipad#numbers
1 min read
Read Article
IntermediateTime and Date
2011-10-31

Pay Periods and Funky PivotTable Controls

Use a PivotTable to find how many months in a year have an extra pay period. Excel 2011 PivotTable controls are funky looking, comparatively speaking....

#excel-2011#pivottables
3 min read
Read Article
FormulasIntermediate
2011-09-06

Fill Down a Formula with VBA

Here is some VBA code I use to copy a formula down to the end of a data range. It assumes a heading in row 1 and the formula in row 2....

#vba
2 min read
Read Article
Features
2011-08-29

How to Customize Default Workbook and Default Worksheet in Excel for Mac

Boost productivity is by customizing the default workbook and default worksheet in Excel to reflect your preferences....

#tips
3 min read
Read Article
BeginnerFeatures
2011-08-23

Settings and Shortcuts for Excel 2003

Here is a list of things I do to "normalize" Excel 2003. Along with a few explanations, reasons, and/or rationalizations....

#tips
5 min read
Read Article
AdvancedProduct
2011-07-12

Microsoft Query Incompatible with Mac OS X Lion [Updated]

Excel for Mac users should beware, Microsoft Query is an incompatible app in the upcoming Lion upgrade for Mac OS X....

#excel-2008#excel-2011
2 min read
Read Article
AdvancedFormattingFormulasTime and Date
2011-07-08

International Short Date Formatting for the TEXT Function

A quick method to automatically give the TEXT function a short date format that matches the computers region settings by using some VBA code in Excel....

#tips#vba
3 min read
Read Article
Beginner
2011-06-27

That Damn Delete Key in Excel for Mac

The Delete Key on a Mac doesn't work in Excel for Mac to delete cell and range contents like a Windows computer. fn+Delete is the magic combination....

#excel-2008#excel-2011#tips#video
3 min read
Read Article
BeginnerTime and Date
2011-06-22

Regional Date Format in Excel for Mac and Windows

Discover how to set and use regional date format in Excel effectively. Enhance your spreadsheets with this essential Microsoft Excel tip....

#tips
6 min read
Read Article
FormulasIntermediate
2011-05-25

A Dynamic Dependent Drop Down List in Excel

Learn how to create dynamic dependent drop-down lists in Excel....

#excel-2007#excel-2010#excel-2011#names
6 min read
Read Article
Product
2011-05-19

Pivot Tables in Google Docs

Google Docs now offers pivot tables in their online spreadsheets. This is the beginning of true change in the spreadsheet world....

#google-docs
2 min read
Read Article
Features
2011-05-17

Where is the Insert Tab in Excel 2011?

The Excel 2007 and 2010 Ribbon both have an Insert Tab, which does not exist in Excel 2011 (Mac). Here is a chart to tell where each item is located....

#excel-2010#excel-2011
2 min read
Read Article
Features
2011-05-11

Worksheet Tab Protection Icon in Excel 2011

I opened a file from a colleague and realized that the padlock icon on the worksheet tab meant that the worksheet was protected. Only in Excel 2011....

#excel-2010#excel-2011
1 min read
Read Article
Features
2011-05-06

Ribbon Home Tab Comparison - Excel 2010 Windows and 2011 Mac

The Ribbon Home Tab in Excel 2010 (Windows) is quite different than in Excel 2011 (Mac) so here is a guide to finding those things that seem lost....

#excel-2007#excel-2010#excel-2011#ribbon#tips
4 min read
Read Article
Advanced
2011-05-04

Select One Column of Data with VBA

Select one column of data in a table by using some simple VBA code and a Form button....

#vba
2 min read
Read Article
Features
2011-05-03

Create a List in Excel 2008

The List feature in Excel 2008 is a hybrid with a List Wizard providing lots of functionality. However a List with a Defined Name is not updated....

#excel-2008
5 min read
Read Article
Features
2011-04-30

Create a List in Excel 2003

The List Object in Excel 2003 is the forerunner of the modern Excel Table with some of the same features....

#excel-2003
3 min read
Read Article
BeginnerFeatures
2011-04-29

Spreadsheet Size in Excel for Windows

Saving an older XLS file to the newer XLSX file format in Excel will not produce a bigger spreadsheet, unless you know the quirk involved....

2 min read
Read Article
BeginnerFeatures
2011-04-28

Spreadsheet Size in Excel for Mac

When you open an XLS file in Excel for Mac versions 2008 and 2011, there are 1,048,576 rows and 16,384 columns. How odd....

2 min read
Read Article
Intermediate
2011-04-20

Dynamic Table Reference with INDEX

A Defined Name with the INDEX function gives a dynamic range reference to a Table column, but moving a Table column can invalidate the reference....

3 min read
Read Article
Advanced
2011-04-19

The Table Address and Structured Data in Excel

Structured data in Tables include #All, #Data, #Headers, #Totals, and @ which are available in formulas to reference different parts of the Table....

2 min read
Read Article
FeaturesIntermediate
2011-04-18

Total Row Formulas in Excel Tables

Excel Tables have a Total Row that can be toggled on and off from the Ribbon. Several functions are available when the Total Row is turned on. In Excel 2010 and...

4 min read
Read Article
Beginner
2011-04-15

5 Obvious Things that 80% of People Don’t Know About Excel

This guest post by ExcelEverest explains five obvious things that 80% of people don’t know about Excel. Check out ExcelEverest.com to learn Excel....

4 min read
Read Article
Intermediate
2011-04-13

Formulas and Structured Data in Excel Tables

Tables automatically extend formulas when data is entered. If a formula is changed in a Table cell, all rows in the column are automatically modified....

4 min read
Read Article
Beginner
2011-04-11

Table Names in Excel

Each Table created in Excel is given a default name that can be used in formulas, to select table data, and shows up in formula autocomplete lists....

2 min read
Read Article
FeaturesIntermediate
2011-04-07

Excel Tables - Styles, Conditional Formatting and Data Validation

Format Excel Tables with Table Styles, Conditional Formatting, and Data Validation. Turn off worksheet gridlines to make the Table more distinctive....

8 min read
Read Article
BeginnerFeatures
2011-03-31

Table Design in Excel

I design a regular data table in Excel, show how it fails, then convert to an Official Excel Table and show how a Table remembers cell formatting....

4 min read
Read Article
BeginnerFeatures
2011-03-30

Migrating to Tables in Excel

I'm going on quest to find out all about Tables in Excel....

2 min read
Read Article
FeaturesIntermediate
2011-03-25

Fat Fingers on the Space Bar - A Conditional Formatting Example

There is a Conditional Formatting solution for entering a blank or space character into a cell. A space character causes #VALUE! errors in formulas....

5 min read
Read Article
Advanced
2011-03-23

Speeding up VBA with the PrintCommunication Property in Excel 2010

Excel 2010's PrintCommunication property in VBA suspends communication with the printer while the code for PageSetup runs, making the code faster....

#vba
4 min read
Read Article
IntermediateTime and Date
2011-03-22

How to Quickly Convert 1904 Dates to the 1900 Date System in Excel

Learn how to convert 1904 date system values to the 1900 date system in Excel. This guide covers methods for accurate date and date systems management in Excel....

#1904#date-systems#time#vba
4 min read
Read Article
FeaturesIntermediate
2011-03-21

Use Formula Auditing to Help Explain Formulas Excel

When you need to present a complicated spreadsheet, the Formula Auditing feature in Excel visually helps to explain formula relationships....

1 min read
Read Article
Intermediate
2011-03-16

Documentation for VBA in Excel

Documentation for VBA in Excel is arduous yet can save you loads of time when you have forgotten the details of a project....

#vba
2 min read
Read Article
General Updates
2011-03-14

Putting Windows 7 on a Mac to Run Excel for Windows

I put three versions of Excel for Windows - 2003, 2007, 2010 - on my MacBook Pro with the Boot Camp Assistant. Had to be done, but scary nonetheless....

4 min read
Read Article
FeaturesIntermediate
2011-03-09

How to Copy Data to Another Worksheet with Advanced Filter

Unlock the power of Excel's Advanced Filter to seamlessly copy and organize data between worksheets. Learn techniques for precise data migration and efficient workflow....

#advanced-filter#tips#vba
4 min read
Read Article
Beginner
2011-03-08

Set the Number of Default Worksheets in Your Workbook

Control the default number of worksheets in a Workbook in Excel....

1 min read
Read Article
Beginner
2011-03-07

View Excel Spreadsheets with the Google Docs Viewer

If you have a Gmail or Google Docs account, getting a quick look at an Microsoft Excel file is now supported with the Google Docs Viewer....

#cloud-computing
2 min read
Read Article
FeaturesIntermediate
2011-03-03

Sorting with Custom Lists in Excel

Sorting with a Custom List makes things simpler when Excel doesn't have a default sort order to fit your needs....

#tips
3 min read
Read Article
BeginnerFormulas
2011-03-01

How to Convert GPS Coordinates in Excel

Learn how to easily convert GPS coordinates in Excel. Discover tips and tricks to input, display, and map latitude and longitude data in Excel....

#conversions#coordinates#gps
4 min read
Read Article
BeginnerFeatures
2011-02-25

Open File As Read Only in Excel

To discourage users from making any changes to a macro file you can have the file recommend Read-Only when it's opened....

1 min read
Read Article
FormulasIntermediateTime and Date
2011-02-23

A Woopra Chat About Excel

Convert minutes and seconds to a value of minutes followed by the text MIN and formatted correctly with no decimal places by using the TEXT function....

#tips
2 min read
Read Article
Beginner
2011-02-21

My First Excel 2011 Chart

My first chart made in Excel 2011 with a data table below, a sparkline chart, and a picture of the ski slope. The chart shows break a event point....

#charts#excel-2010#excel-2011#sparkline
2 min read
Read Article
Features
2011-02-18

Sorting Columns From Left To Right in Excel Causes Problems

You may never have the opportunity to Sort columns of data from Left to Right , but beware of some apparent problems . A reader mentioned that when sorting from...

#excel-2010#excel-2011#tips
4 min read
Read Article
Features
2011-02-16

Sorting Columns Left to Right in Excel

A little know option in the Excel Sort feature allows sorting columns of data from left to right instead of the normal top to bottom....

#tips
3 min read
Read Article
FormattingTime and Date
2011-02-14

Let Excel Convert Hours Between Two Dates and Times

Let Excel Convert Hours Between Two Dates and Times by subtracting one time/date from another the use the custom time format [h]:mm or [h]:mm:ss....

2 min read
Read Article
Beginner
2011-02-11

The Mini Toolbar in Excel

Do basic formatting in Excel with the Mini Toolbar. It appears above the shortcut menu when you right-click an object - cell, range, chart, or shape....

#excel-2007#excel-2010
2 min read
Read Article
Beginner
2011-02-09

F2 in Excel for Mac

The F2 key is a fundamental shortcut in Excel for Windows. But how works F2 in Excel for Mac?...

#excel-2011#excel-shortcuts
2 min read
Read Article
Beginner
2011-02-04

Add Freeze Sheet Panes to the Quick Access Toolbar

Add a one-click Freeze Panes command to the Quick Access Toolbar in Excel 2010 and 2007....

#excel-2007#excel-2010
2 min read
Read Article
Beginner
2011-02-02

Excel 2011 Preferences

Default Preferences that should be changed in Excel 2011 [Mac] for General, View, Edit, Calculation, and Ribbon....

#excel-2011
2 min read
Read Article
Intermediate
2011-01-31

Excel 2011 Keyboard Shortcuts on Your Desktop

Locate Excel 2011 Keyboard Shortcuts Help web page and save to your computer for off-line access via your web browser, Firefox, Chrome, or Safari....

#excel-2010#excel-2011
5 min read
Read Article
Intermediate
2011-01-28

Import Data From the Web in Excel

Import data from a web page into an worksheet with Excel 2010 and 2007 (windows versions). This external data query can be refreshed if data changes....

#excel-2007#excel-2010#keyboard-shortcuts
3 min read
Read Article
Beginner
2011-01-26

Copy a Help Topic URL in Excel 2010

Help topics in Excel 2010 are shown in a separate window from Office.com that allows the URL to be easily copied from the Help topic's Properties....

#excel-2010#keyboard-shortcuts#tips
3 min read
Read Article
FormulasIntermediate
2011-01-24

INDEX and MATCH Functions Together Again in Excel

The INDEX and MATCH functions perform a lookups in Excel. INDEX returns a cell from an array, MATCH contributes the row and/or column position....

2 min read
Read Article
FormulasIntermediate
2011-01-21

The INDEX Function in Excel

The INDEX function returns a cell value from a range, given a row and/or column position number. Three examples are given in this article....

3 min read
Read Article
FormulasIntermediate
2011-01-19

The MATCH Function in Excel

The MATCH function in Excel returns the position number of a matched value from within a range, not the value itself....

3 min read
Read Article
FeaturesFormulasIntermediate
2011-01-17

Goal Seek in Excel

If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature...

2 min read
Read Article
FormulasIntermediateTime and Date
2011-01-14

What Day of the Year is It?

The embedded spreadsheet will take a date value and return the Day of Year with a formula that uses the DATE Function....

#cloud-computing
2 min read
Read Article
FormulasIntermediateTime and Date
2011-01-12

Use the DATEDIF Function to Quickly Calculate Date Difference in Excel

Use the DATEDIF Function in Excel to find the number of Years, Months and Days between two dates. Only documented in Excel 2000 but in later versions....

3 min read
Read Article
Intermediate
2011-01-10

The Repeat Command in Excel for Mac

Add the Repeat command icon to the Standard Toolbar in Excel for Mac, 2011 and 2008, from the Customize Toolbars and Menus dialog box....

#excel-2008#excel-2011#tips
2 min read
Read Article
Intermediate
2011-01-07

Redo and Repeat Commands in Excel [Updated]

The Repeat command is useful in Excel and intertwined with the Redo command. Add the Repeat command to the Quick Access Toolbar to discover its uses....

#excel-2007#excel-2010#tips
3 min read
Read Article
Intermediate
2011-01-05

Fixing the F4 Button in Excel for Mac

The F4 key in Excel for Mac is a shortcut for the Paste command, which can be reassigned to the Redo command so it works similar to Excel for Windows....

#tips
2 min read
Read Article
Beginner
2011-01-03

What Version of Excel am I Using?

A reference to find out what version of Excel you are using. Excel for Windows - versions 2010, 2007, 2003. Excel for Mac - versions 2011, 2008....

#excel-2003#excel-2007#excel-2008#excel-2010#excel-2011#tips
2 min read
Read Article
FormulasIntermediate
2010-12-29

The TRIM Function in Excel and VBA

The Excel TRIM Function removes all spaces from text except single spaces between words. The VBA TRIM Function removes leading and trailing spaces....

1 min read
Read Article
General Updates
2010-12-27

Top 10 Articles for 2010

The top ten Excel articles on Excel Semi-Pro for 2010....

1 min read
Read Article
Beginner
2010-12-23

Apple Keyboard Symbols in Excel

One key to understanding Excel 2001 for Mac is knowing the keyboard shortcuts , but to communicate them requires displaying the symbols that are specific to a M...

#excel-2008#excel-2011
2 min read
Read Article
Advanced
2010-12-22

Automatically Expand a Named Range in Excel

Automatically expand the name reference of a data table when a user adds more data by using the sheet deactivate routine to call a simple subroutine....

#vba
2 min read
Read Article
Beginner
2010-12-21

Keyboard Shortcuts in Excel 2011

Create, Delete, or Peruse Keyboard Shortcuts in Excel 2011 or 2008 by using the Customize Keyboard dialog box....

#excel-2008#excel-2011
3 min read
Read Article
FormulasIntermediate
2010-12-20

VLOOKUP Function in Excel: The Essential Guide

The VLOOKUP function in Excel explained in relatively non-technical terms for the laymen. Two examples, FALSE and TRUE, from the fourth argument....

6 min read
Read Article
Beginner
2010-12-17

Recently Used File List in Excel

The number of files Excel will show in the Recently Used File List depends on the version of Excel you're using and vary between 9 and 99 files....

#excel-2003#excel-2007#excel-2008#excel-2010#excel-2011
2 min read
Read Article
Beginner
2010-12-16

Use Function Keys Normally in Excel 2011

Since I'm relatively new to the world of Mac but an old hand with Windows, making an effort to discover Excel 2011 for Mac comes with some adjustments. Using th...

#excel-2011#tips
2 min read
Read Article
BeginnerFormulas
2010-12-15

Logical Operations in Excel

Logical operations in Excel on four TRUE/FALSE outcomes of A an B. Then ADD, MULTIPLY, and use functions AND, OR, NOT, NAND, NOR, & equals comparison....

3 min read
Read Article
IntermediateProduct
2010-12-14

VBA Help System Lacking in Excel 2011

The VBA Help system for Excel 2011 for Mac is a tangled web of confusion that's frustrating and difficult to say the least. Excel 2010 is much better....

#excel-2010#excel-2011#vba
2 min read
Read Article
FormulasIntermediate
2010-12-13

Excel ISNUMBER or IsNumeric Function

The VBA function IsNumeric is different than the Excel worksheet function ISNUMBER....

#vba
3 min read
Read Article
Beginner
2010-12-09

Worksheet Navigation in Excel

Keyboard and mouse shortcuts for navigating Excel worksheets in Windows and Mac....

#tips
1 min read
Read Article
AdvancedFormulasTime and Date
2010-12-08

Calculate the Xth Weekday of Any Month in Excel

A simple formula to calculate the Xth Day of any month using four inputs: Year, Month, Week, and Day. Data validation with custom formatting required....

#excel-2003#excel-2007#excel-2008#excel-2010#excel-2011#tips
5 min read
Read Article
BeginnerFeatures
2010-12-07

Quick Access File List in Excel 2010

In Excel 2010 there's an new optional feature at the bottom of the File>Recent menu to Quickly access this number of Recent Workbooks....

1 min read
Read Article
BeginnerFormatting
2010-12-06

Indent Left and Right to Align Cell Contents

Both Left and Right Indenting is useful to align cell contents in Excel to make data more readable. Left Indent for text and Right Indent for numbers....

#tips
2 min read
Read Article
IntermediateProduct
2010-12-03

Microsoft Office 2011 Document Connection

The Microsoft Document Connection program comes with Office 2011 for Mac and is a great way to access your SkyDrive files in the cloud....

#cloud-computing#excel-2011
2 min read
Read Article
FeaturesIntermediate
2010-12-01

Equation Editors in Excel 2010 and Word 2011

The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as graphical object. Word 2011 has the same Equation Editor....

#cloud-computing#excel-2010#excel-2011#word-2011
4 min read
Read Article
Beginner
2010-11-29

Switch Between Relative and Absolute References in Excel for Mac

Use the keyboard shortcut Cmd+T to switch between relative, absolute, and mixed formula references in Excel for Mac....

#excel-2008#excel-2011#tips
1 min read
Read Article
FormulasIntermediateTime and Date
2010-11-24

Converting Pace in Minutes per Mile to MPH and Back Again in Excel

I'm converting Pace to MPH and then reversing the process, converting MPH to Pace, to create a conversion chart....

#conversions#time#tips
4 min read
Read Article
BeginnerFormulas
2010-11-22

Convert Seconds with the TIME Function in Excel

An iTunes playlist download shows time in seconds. Convert these seconds with the TIME Function in Excel and some custom formatting....

#tips
2 min read
Read Article
FormulasIntermediate
2010-11-20

3 Proven Formulas to Calculate Letter Grades in Excel

There are several ways to turn student scores into letter grades in Excel. Here we guide educators and academic professionals to manage a gradebook using Excel....

#education#grades#tips
4 min read
Read Article
FormulasIntermediate
2010-11-18

Nested IF Functions in Excel

Nested IF Functions means having at least one IF Function contained within another IF Function, which can get complicated. Use a binary outcome chart....

#tips
3 min read
Read Article
BeginnerFormulas
2010-11-16

The IF Function in Excel

The IF Function has three arguments. The first is required, the last two optional. Comparison calculation operators and example IF Functions shown....

#tips
3 min read
Read Article
AdvancedFormulas
2010-11-13

Single-Cell Array Formula in Excel

The Evaluate Formula dialog box shows interim calculations for single-cell array formulas to reveal array values Excel holds in internal memory....

#arrays
4 min read
Read Article
FormulasIntermediate
2010-11-11

Multi-Cell Array Formula in Excel

A Multi-Cell Array formula is entered by selecting a range, typing a formula, then holding the Control and Shift keys down while pressing Enter....

#arrays
4 min read
Read Article
Product
2010-11-09

Excel 2011 Ribbon Screen Shots

Just a few screen shots of the new Ribbon in Excel 2011, with a Home tab comparison to Excel 2010....

#excel-2010#excel-2011
3 min read
Read Article
Advanced
2010-11-06

Hide or Show Names in Excel with VBA

Names can be hidden or shown in Excel with some simple VBA code....

#names#vba
3 min read
Read Article
Intermediate
2010-11-04

Update Excel 2003 to Use Newer Excel Files

Install the Office Compatibility Pack so you can open Excel 2007 and 2010 workbook files from older versions of Excel: 2003, 2002, or 2000....

#tips
1 min read
Read Article
Product
2010-11-02

Excel 2011 for Mac - Installation, Preferences, and VBA

I install Excel 2011, review some Preferences, and take a quick peek at the VBA....

#cloud-computing#excel-2011#excel-web-app
4 min read
Read Article
Intermediate
2010-10-30

Hide Worksheets in Excel

Change the visible property of a worksheet to make it very hidden and won't show in the Unhide sheet dialog box....

#tips#vba
3 min read
Read Article
Product
2010-10-28

A New Charts Editor - Google Docs Keeps Improving

Google Docs new Charts Editor is an upgrade by Google, who keeps on improving their free spreadsheet offering in the cloud. Microsoft beware....

#cloud-computing
2 min read
Read Article
Beginner
2010-10-26

Absolute and Relative Cell References in Excel

Learn what a relative and absolute cell reference means in rows and columns, then use relative and absolute in one formula with two cell references,...

#excel-2010#tips
5 min read
Read Article
FormulasIntermediate
2010-10-23

Use the DATE Function to Find the Last Day of a Month

The DATE Function will return the last day of the month prior to the Month argument, by using zero (0) for the Day argument....

#tips
1 min read
Read Article
FeaturesIntermediateProduct
2010-10-21

Introduction to PowerPivot

PowerPivot works with Excel 2010 to import millions of rows of data from different sources, build relationships, and visualize data with PivotTables....

#excel-2010
2 min read
Read Article
FeaturesFormulasIntermediate
2010-10-19

A Sparkline Example in Excel 2010

Create a dynamic range sparkline graphic to show the last seven data points. Sparklines are new in Excel 2010 and don't work with earlier versions....

3 min read
Read Article
FormulasIntermediate
2010-10-16

Put an OFFSET Formula Inside a Named Range

Create a Named Range using a formula with the OFFSET Function to capture the last 7 days of a range....

1 min read
Read Article
FormulasIntermediate
2010-10-14

The OFFSET Function - Last 7 Data Points

Use the OFFSET Function to return the last 7 rows of a range....

3 min read
Read Article
Beginner
2010-10-12

Switch Between Workbooks Faster in Excel 2007 and 2010

Add the Switch Window command to the Quick Access Toolbar in Excel 2010 and 2007 to switch between workbooks with only two clicks, like Excel 2003....

#tips
2 min read
Read Article
FormulasIntermediate
2010-10-09

Become the OFFSET Function and Tell a Short Story

I become the OFFSET function to tell a simple story of how I give you a value for the last cell in a range by using an example....

3 min read
Read Article
IntermediateTime and Date
2010-10-07

How to Convert Decimal Hours to Time in Excel

Master the art of converting decimal hours to time format in Excel. Easily track minutes and hours In work and log books, events and when analyzing time data....

#time#tips
4 min read
Read Article
Beginner
2010-10-05

Column Width Unit of Measure in Excel Versions

The units differ for column widths between Excel made for Windows and Mac, 8.43 characters verses 1.04 inches, respectively....

#tips
2 min read
Read Article
Beginner
2010-10-02

How to Start a New Line in Excel Cell With Keyboard Shortcut and Formula

If you need to include multiple lines of text within a single cell of a worksheet, you can start a new line in Excel cell by using a line break....

#tips
5 min read
Read Article
Intermediate
2010-09-30

Keep Track of Passwords in Excel [Updated]

Keep track of passwords in Excel with a password protected file....

#tips
4 min read
Read Article
FormulasIntermediate
2010-09-28

Enter a Constant Value in a Name

Create a Name in Excel that holds a constant value....

#excel-2008#names#tips
3 min read
Read Article
Intermediate
2010-09-25

Name and Select a Range with the Name Box in Excel

Name a cell, range, or non-contiguous range by using the Name box, then go quickly to that Named Range....

#tips
2 min read
Read Article
Beginner
2010-09-23

Use the Name Box to Select a Range in Excel

Use the Name box to select a cell, range or multiple ranges in Excel....

#tips
2 min read
Read Article
Intermediate
2010-09-21

Use the Name Box to View Recently Used Functions in Excel

Quickly see the Excel functions you've recently used with the Name box....

#tips
1 min read
Read Article
Intermediate
2010-09-18

Copy a Worksheet Picture in Excel 2003 or Excel 2008

Copy a picture of a spreadsheet in Excel 2003 or Excel 2008 for Mac and paste into your presentation software or elsewhere....

#excel-2003#excel-2008#tips
2 min read
Read Article
Intermediate
2010-09-16

Insert Screenshots in Excel 2010

Insert an image into an Excel 2010 worksheet from any program that is currently running on your computer and not minimized to the task bar....

#tips
1 min read
Read Article
General UpdatesIntermediate
2010-09-14

Save Time Entering Decimal Points in Excel

Have Excel automatically enter fixed decimal places for you....

#tips
1 min read
Read Article
FormulasIntermediate
2010-09-11

Figure Those Pesky Fractions in Excel

Enter fractions in Excel by adding a space after the integer and before the fraction. Easily create a list of fractions.....

#tips
2 min read
Read Article
BeginnerGeneral Updates
2010-09-09

Number Format Shortcut in Excel

A keyboard shortcut to format a number with a thousands separator and two decimal places. Control + Shift + ! (exclamation point)...

#tips
1 min read
Read Article
FormulasIntermediate
2010-09-07

Stock Price Formula in a Spreadsheet

The GoogleFinance Function returns a stock price by default, given stock symbol for a company or mutual fund....

#cloud-computing
1 min read
Read Article
FormulasIntermediate
2010-09-04

The TEXT Function in Excel

The TEXT Function in Excel converts a value to text and lets you specify the display formatting by using special format strings....

2 min read
Read Article
FormulasIntermediateTime and Date
2010-09-02

The WEEKDAY Function in Excel

Excel 2010 has new function arguments for the WEEKDAY Function. It returns an integer value based upon the day of the week....

#excel-2010
2 min read
Read Article
BeginnerTime and Date
2010-08-31

Date and Time Calculation in Excel

Date and Time are the components of a serial number value, and are represented by an integer and decimal, respectively....

#tips
3 min read
Read Article
FormulasIntermediate
2010-08-26

Convert Seconds to a Time Format in Excel

Convert a large number of seconds to a hours:minute:seconds format using the TIME, INT and MOD functions....

3 min read
Read Article
BeginnerFormulas
2010-08-24

Using the SUM Function for a Running Total in Excel

Using the SUM Function in Excel to provide a running total time for song duration....

2 min read
Read Article
FormulasIntermediate
2010-08-21

Putting the TIME, INT and MOD Functions to Work in Excel

Convert a Time in seconds to a minutes:seconds format by using the INT and MOD functions inside the TIME function....

2 min read
Read Article
FormulasIntermediate
2010-08-19

The TIME Function in Excel

Using the TIME Function to display minutes and seconds in a readable time format....

1 min read
Read Article
FormulasIntermediate
2010-08-17

The MOD Function in Excel

Understanding how the MOD Function works to extract the number of seconds left over after dividing a number of seconds by 60....

2 min read
Read Article
FormulasIntermediate
2010-08-14

QUOTIENT, ROUNDDOWN and INT Functions in Excel

Three functions to get the integer portion of a division calculation: QUOTIENT, ROUNDDOWN, INT Functions in Excel....

2 min read
Read Article
FormulasIntermediate
2010-08-12

iTunes Playlist Export Task – Convert Seconds to a Time Format

Converting seconds to a minutes:seconds time format requires several formulas....

1 min read
Read Article
FormulasIntermediateTime and Date
2010-08-10

Convert a Text String Date to Date Serial Number

One formula to convert a text string date to a date serial number using double negation, MID Function, Ampersand Operator, and the RIGHT Function....

2 min read
Read Article
FormulasIntermediateTime and Date
2010-08-07

The VALUE Function in Excel – Converting Text Dates

Converting text string Dates to numeric serial number values using the Excel VALUE Function and with alternate methods: addition, multiplication, division, and double negation....

#tips
2 min read
Read Article
FormulasIntermediate
2010-08-05

The TYPE Function in Excel

The TYPE Function in Excel will indicate the type of data in a cell. In this case between Text and Numeric....

1 min read
Read Article
FormulasIntermediate
2010-08-03

CONCATENATE Function or Ampersand Operator in Excel

Choosing between the CONCATENATE Function or Ampersand Operator in Excel. Ampersand is easy and simple....

2 min read
Read Article
FormulasIntermediate
2010-07-31

The RIGHT Function in Excel

The RIGHT Function returns a specified number of characters from the end of a text string in Excel....

2 min read
Read Article
FormulasIntermediate
2010-07-29

The MID Function in Excel

Use the MID Function to extract characters from the middle of a text string in Excel....

2 min read
Read Article
FormulasTime and Date
2010-07-28

Extract a Date from Text in Excel

Extract a Date from Text values by using a formula in Excel....

2 min read
Read Article
General Updates
2010-07-25

Excel Files on the iPad or iPhone

Documents To Go® Premium allows Excel files to be viewed, edited, and created on the iPad and iPhone. Add Dropbox to the mix and you can access your Excel files in the cloud with ease....

#cloud-computing#excel-app
2 min read
Read Article
Intermediate
2010-07-22

Removing Duplicates in Excel 2008

Remove duplicate values from a data set in Excel 2008 for Mac....

#remove-duplicates#tips
2 min read
Read Article
Intermediate
2010-07-17

Removing Duplicate Values in Excel 2003

In Excel 2003 removing duplicate values is a manual process. Here is a method that worked well for me on this particular data set....

#remove-duplicates#tips
2 min read
Read Article
Intermediate
2010-07-13

Text To Columns in Excel

Parse text data with Excel's Text to Columns feature....

#tips
3 min read
Read Article
Beginner
2010-07-10

Change Excel 2008 to Look Normal

Change the default spreadsheet view in Excel 2008 for Mac to Normal....

#excel-2008#tips
2 min read
Read Article
Beginner
2010-07-08

Pin Documents, Workbooks, and Places to the Recent File List in Excel

Pin documents, workbooks, and places to the recent file list, or jump list, in Excel 2007 and Excel 2010....

#tips
1 min read
Read Article
Beginner
2010-07-06

Add Freeze Panes Command to the Excel Quick Access Toolbar

Add the Freeze Panes command to the Quick Access Toolbar in Excel 2007 & 2010 to get back to the two-click functionality in Excel 2003. Excel 2008:mac requires the Normal page layout to Freeze Panes....

#tips
2 min read
Read Article
Intermediate
2010-07-02

Open a CSV File

I have a Lose It! app on my iPhone that automatically backs up data to my web account. The website makes it easy to download reports using CSV files, essentiall...

#tips
2 min read
Read Article
General Updates
2010-06-30

Excel on the Web – Another Spreadsheet in the Cloud

A look at the Excel Web App spreadsheet with integration to Excel 2010 desktop program....

#cloud-computing#excel-2010#excel-web-app
6 min read
Read Article
IntermediateTime and Date
2010-06-28

Generate a List of Dates in Excel

Generate a date series in Excel quickly with the Edit, Fill, Series pop-up box....

#tips
2 min read
Read Article
IntermediateTime and Date
2010-06-24

Microsoft Excel Date Systems for Windows and Mac

Excel date systems for Windows and Mac are drastically different and can be confusing. Sharing Excel files between Windows and Mac computers can be confusing because of the two different date systems....

#tips
4 min read
Read Article
Beginner
2010-06-22

Navigating Regions in Excel

Navigating large regions of data can be very quick and easy using keyboard or mouse shortcuts . You can also select entire rows or columns, although multiple ro...

#tips
4 min read
Read Article
Beginner
2010-06-19

Select a Current Region of Data in Excel

How to quickly select regions of data in Excel...

#tips
3 min read
Read Article
Beginner
2010-06-17

Organizing Data Into Regions

Why it's important to organize data into regions or ranges in Excel....

#tips
2 min read
Read Article
Beginner
2010-06-15

Expand Menus in Excel 2003

Show full menus in Excel 2003...

#excel-2003#tips
1 min read
Read Article
Product
2010-02-13

Microsoft Excel 2010 on the iPad with the OnLive Desktop

The OnLive Desktop brings a Windows desktop to the iPad so you can enjoy a full version of Microsoft Excel 2010. Truly amazing....

#excel-2010#ipad
3 min read
Read Article