Sitemap

Posts

• 4 Methods to Insert a Timestamp in Excel Cell (January 2, 2024)
• TRUNC Function in Excel: A Comprehensive Guide (December 4, 2023)
• Excel Worksheets: A Beginner's Guide (October 16, 2023)
• VLOOKUP Not Working with Text Values: 6 Fixes You Need (October 9, 2023)
• Learn How to Add In Excel Using the SUM Function and AUTOSUM (September 18, 2023)
• How to Get Excel for Free (Including Best Free Excel Alternatives in 2023) (May 15, 2023)
• How to Create a Drop Down List in Excel with Data Validation (January 31, 2022)
• How To Calculate Hours Between Two Dates in Excel (January 21, 2022)
• How to Convert Excel to Google Sheets (June 12, 2020)
• The Data Adds Up: Using the Addition Formula in Excel (May 1, 2020)
• Pivot Charts: An All-Encompassing Guide (April 2, 2020)
• HLOOKUP In Excel: Everything You Need to Know (March 12, 2020)
• The Best Excel Book to Purchase from Amazon (November 6, 2019)
• How to Create a Database in Excel (October 31, 2019)
• Google Sheets vs Excel: How Do They Differ? (October 24, 2019)
• The History of Microsoft Excel: How It Came to Be (October 22, 2019)
• What to Do When Excel Keeps Crashing (October 16, 2019)
• How to Find Outliers in Excel in 5 Easy Steps (September 25, 2019)
• How to Calculate Z Score in Excel: What You Need to Know (August 21, 2019)
• How to Find Variance in Excel? Follow These Tips (August 16, 2019)
• How to Print Labels from Excel: Ultimate Guide (August 16, 2019)
• How to Add a Row in Excel: Step by Step Process (July 4, 2019)
• How to Remove Duplicates in Excel: An Easy Guide (June 20, 2019)
• How to Round Numbers in Excel: What You Need to Know (June 20, 2019)
• The NOW Function in Excel: What It is and How to Use It (June 20, 2019)
• How to Hide Columns in Excel (June 19, 2019)
• How to Randomize a List in Excel: Our Complete Guide (June 13, 2019)
• Sort Your Life into Neat Little Boxes with These Excel Basics (March 29, 2019)
• How to Delete Duplicates in Excel: An Easy Guide (June 25, 2018)
• Ready, Set, Scatter: How to Make a Scatter Plot in Excel (June 20, 2018)
• How to Freeze Cells in Excel So Rows and Columns Stay Visible (June 14, 2018)
• How to Use Goal Seek in Excel (June 14, 2018)
• How to Freeze A Row in Excel: A Practical Guide (June 14, 2018)
• How to Alphabetize in Excel: Fast & Simple (June 13, 2018)
• How to Make a Line Graph in Excel (June 13, 2018)
• How to Subtract in Excel (June 13, 2018)
• Excel SUM Formula: What Is It And When Do I Use It? (June 1, 2018)
• 5 New and Creative Ways To Utilize Excel (May 23, 2018)
• The 20 Most Useful Excel Shortcuts to Utilize (May 9, 2018)
• Pivot Tables (PV Table): Everything You Need to Know (May 8, 2018)
• Learn How to Unhide Cells in Excel Using Keyboard Shortcuts or the Home Menu (May 2, 2018)
• The Drop Down Basics: How to Make a Drop Down List in Excel (April 25, 2018)
• How to Use the AVERAGE Function in Excel (April 17, 2018)
• How to Move Columns in Excel While Keeping Your Data Intact (March 31, 2018)
• How to Add Cells in Excel to Sum Up Totals Automatically (March 30, 2018)
• How to Merge Cells in Excel (and Split Them) for Better Layouts (March 28, 2018)
• How to Use the SUMIF and SUMIFS Functions in Excel (March 27, 2018)
• Excel for iPad - Paste as Values (June 16, 2014)
• Where is Control+Home for Excel on a Mac (April 28, 2013)
• Excel Fractional Part: Extracting Integers and Fractions in Excel (February 14, 2013)
• Extract Time from datetime with the MOD Function in Excel (November 1, 2012)
• How to Extract Time from DateTime values in Excel (October 9, 2012)
• Extract Date from DateTime Number in Excel (September 15, 2012)
• Add Macro Button to the Toolbar in Excel 2011 (July 7, 2012)
• Control + Home in Excel for Mac (June 30, 2012)
• Break Even Calculation with an Unlocked iPhone and International Rates (April 23, 2012)
• A Dynamic Dependent Drop Down List with a Horizontal Table Reference (April 9, 2012)
• The VLOOKUP Function - Inside Out (March 25, 2012)
• How to Update a List or Range without OFFSET (March 22, 2012)
• Select Excel's Used Range on a Mac (March 20, 2012)
• Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code] (February 28, 2012)
• An Excel Crossroads - Mac and Windows (January 5, 2012)
• Select a Column of Non-Sequential Data (December 19, 2011)
• Microsoft Office on the iPad (November 30, 2011)
• Pay Periods and Funky PivotTable Controls (October 31, 2011)
• Fill Down a Formula with VBA (September 6, 2011)
• Zoom to 125 Percent - Excel 2011 Default Workbook (August 29, 2011)
• Settings and Shortcuts for Excel 2003 (August 23, 2011)
• Microsoft Query Incompatible with Mac OS X Lion [Updated] (July 12, 2011)
• International Short Date Formatting for the TEXT Function (July 7, 2011)
• That Damn Delete Key in Excel for Mac (June 27, 2011)
• Regional Date Formats in Excel (June 21, 2011)
• A Dynamic Dependent Drop Down List in Excel (May 25, 2011)
• Pivot Tables in Google Docs (May 19, 2011)
• Where is the Insert Tab in Excel 2011? (May 17, 2011)
• Worksheet Tab Protection Icon in Excel 2011 (May 11, 2011)
• Ribbon Home Tab Comparison - Excel 2010 Windows and 2011 Mac (May 5, 2011)
• Select One Column of Data with VBA (May 4, 2011)
• Create a List in Excel 2008 (May 3, 2011)
• Create a List in Excel 2003 (April 30, 2011)
• Spreadsheet Size in Excel for Windows (April 29, 2011)
• Spreadsheet Size in Excel for Mac (April 28, 2011)
• Dynamic Table Reference with INDEX (April 20, 2011)
• The Table Address and Structured Data in Excel (April 19, 2011)
• Total Row Formulas in Excel Tables (April 18, 2011)
• 5 Obvious Things that 80% of People Don’t Know About Excel (April 15, 2011)
• Formulas and Structured Data in Excel Tables (April 13, 2011)
• Table Names in Excel (April 11, 2011)
• Excel Tables - Styles, Conditional Formatting and Data Validation (April 7, 2011)
• Table Design in Excel (March 31, 2011)
• Migrating to Tables in Excel (March 30, 2011)
• Fat Fingers on the Space Bar - A Conditional Formatting Example (March 25, 2011)
• Speeding up VBA with the PrintCommunication Property in Excel 2010 (March 23, 2011)
• How to Quickly Convert 1904 Dates to the 1900 Date System in Excel (March 22, 2011)
• Use Formula Auditing to Help Explain Formulas Excel (March 21, 2011)
• Documentation for VBA in Excel (March 16, 2011)
• Putting Windows 7 on a Mac to Run Excel for Windows (March 14, 2011)
• How to Copy Data to Another Worksheet with Advanced Filter (March 9, 2011)
• Set the Number of Default Worksheets in Your Workbook (March 8, 2011)
• View Excel Spreadsheets with the Google Docs Viewer (March 7, 2011)
• Sorting with Custom Lists in Excel (March 3, 2011)
• How to Convert GPS Coordinates in Excel (March 1, 2011)
• Open File As Read Only in Excel (February 25, 2011)
• A Woopra Chat About Excel (February 23, 2011)
• My First Excel 2011 Chart (February 21, 2011)
• Sorting Columns From Left To Right in Excel Causes Problems (February 18, 2011)
• Sorting Columns Left to Right in Excel (February 16, 2011)
• Let Excel Convert Hours Between Two Dates and Times (February 14, 2011)
• The Mini Toolbar in Excel (February 11, 2011)
• F2 in Excel for Mac (February 9, 2011)
• Add Freeze Sheet Panes to the Quick Access Toolbar (February 4, 2011)
• Excel 2011 Preferences (February 2, 2011)
• Excel 2011 Keyboard Shortcuts on Your Desktop (January 31, 2011)
• Import Data From the Web in Excel (January 28, 2011)
• Copy a Help Topic URL in Excel 2010 (January 26, 2011)
• INDEX and MATCH Functions Together Again in Excel (January 24, 2011)
• The INDEX Function in Excel (January 21, 2011)
• The MATCH Function in Excel (January 19, 2011)
• Goal Seek in Excel (January 17, 2011)
• What Day of the Year is It? (January 14, 2011)
• Use the DATEDIF Function to Quickly Calculate Date Difference in Excel (January 12, 2011)
• The Repeat Command in Excel for Mac (January 10, 2011)
• Redo and Repeat Commands in Excel [Updated] (January 7, 2011)
• Fixing the F4 Button in Excel for Mac (January 5, 2011)
• What Version of Excel am I Using? (January 3, 2011)
• The TRIM Function in Excel and VBA (December 29, 2010)
• Top 10 Articles for 2010 (December 27, 2010)
• Apple Keyboard Symbols in Excel (December 23, 2010)
• Automatically Expand a Named Range in Excel (December 22, 2010)
• Keyboard Shortcuts in Excel 2011 (December 21, 2010)
• VLOOKUP Function in Excel: The Essential Guide (December 20, 2010)
• Recently Used File List in Excel (December 17, 2010)
• Use Function Keys Normally in Excel 2011 (December 16, 2010)
• Logical Operations in Excel (December 15, 2010)
• VBA Help System Lacking in Excel 2011 (December 14, 2010)
• Excel ISNUMBER or IsNumeric Function (December 13, 2010)
• Worksheet Navigation in Excel (December 9, 2010)
• Calculate the Xth Weekday of Any Month in Excel (December 8, 2010)
• Quick Access File List in Excel 2010 (December 7, 2010)
• Indent Left and Right to Align Cell Contents (December 6, 2010)
• Microsoft Office 2011 Document Connection (December 3, 2010)
• Equation Editors in Excel 2010 and Word 2011 (December 1, 2010)
• Switch Between Relative and Absolute References in Excel for Mac (November 29, 2010)
• Converting Pace in Minutes per Mile to MPH and Back Again in Excel (November 24, 2010)
• Convert Seconds with the TIME Function in Excel (November 22, 2010)
• 3 Proven Formulas to Calculate Letter Grades in Excel (November 20, 2010)
• Nested IF Functions in Excel (November 18, 2010)
• The IF Function in Excel (November 16, 2010)
• Single-Cell Array Formula in Excel (November 13, 2010)
• Multi-Cell Array Formula in Excel (November 11, 2010)
• Excel 2011 Ribbon Screen Shots (November 9, 2010)
• Hide or Show Names in Excel with VBA (November 6, 2010)
• Update Excel 2003 to Use Newer Excel Files (November 4, 2010)
• Excel 2011 for Mac - Installation, Preferences, and VBA (November 2, 2010)
• Hide Worksheets in Excel (October 30, 2010)
• A New Charts Editor - Google Docs Keeps Improving (October 28, 2010)
• Absolute and Relative Cell References in Excel (October 26, 2010)
• Use the DATE Function to Find the Last Day of a Month (October 23, 2010)
• Introduction to PowerPivot (October 21, 2010)
• A Sparkline Example in Excel 2010 (October 19, 2010)
• Put an OFFSET Formula Inside a Named Range (October 16, 2010)
• The OFFSET Function - Last 7 Data Points (October 14, 2010)
• Switch Between Workbooks Faster in Excel 2007 and 2010 (October 12, 2010)
• Become the OFFSET Function and Tell a Short Story (October 9, 2010)
• How to Convert Decimal Hours to Time in Excel (October 7, 2010)
• Column Width Unit of Measure in Excel Versions (October 5, 2010)
• How to Start a New Line in Excel Cell With Keyboard Shortcut and Formula (October 2, 2010)
• Keep Track of Passwords in Excel [Updated] (September 30, 2010)
• Enter a Constant Value in a Name (September 28, 2010)
• Name and Select a Range with the Name Box in Excel (September 25, 2010)
• Use the Name Box to Select a Range in Excel (September 23, 2010)
• Use the Name Box to View Recently Used Functions in Excel (September 21, 2010)
• Copy a Worksheet Picture in Excel 2003 or Excel 2008 (September 18, 2010)
• Insert Screenshots in Excel 2010 (September 16, 2010)
• Save Time Entering Decimal Points in Excel (September 14, 2010)
• Figure Those Pesky Fractions in Excel (September 11, 2010)
• Number Format Shortcut in Excel (September 9, 2010)
• Stock Price Formula in a Spreadsheet (September 7, 2010)
• The TEXT Function in Excel (September 4, 2010)
• The WEEKDAY Function in Excel (September 2, 2010)
• Date and Time Calculation in Excel (August 31, 2010)
• Convert Seconds to a Time Format in Excel (August 26, 2010)
• Using the SUM Function for a Running Total in Excel (August 24, 2010)
• Putting the TIME, INT and MOD Functions to Work in Excel (August 21, 2010)
• The TIME Function in Excel (August 19, 2010)
• The MOD Function in Excel (August 17, 2010)
• QUOTIENT, ROUNDDOWN and INT Functions in Excel (August 14, 2010)
• iTunes Playlist Export Task – Convert Seconds to a Time Format (August 12, 2010)
• Convert a Text String Date to Date Serial Number (August 10, 2010)
• The VALUE Function in Excel – Converting Text Dates (August 7, 2010)
• The TYPE Function in Excel (August 5, 2010)
• CONCATENATE Function or Ampersand Operator in Excel (August 3, 2010)
• The RIGHT Function in Excel (July 31, 2010)
• The MID Function in Excel (July 29, 2010)
• Extract a Date from Text in Excel (July 27, 2010)
• Excel Files on the iPad or iPhone (July 25, 2010)
• Removing Duplicates in Excel 2008 (July 22, 2010)
• Removing Duplicate Values in Excel 2003 (July 17, 2010)
• Text To Columns in Excel (July 13, 2010)
• Change Excel 2008 to Look Normal (July 10, 2010)
• Pin Documents, Workbooks, and Places to the Recent File List in Excel (July 8, 2010)
• Add Freeze Panes Command to the Excel Quick Access Toolbar (July 6, 2010)
• Open a CSV File (July 2, 2010)
• Excel on the Web – Another Spreadsheet in the Cloud (June 30, 2010)
• Generate a List of Dates in Excel (June 28, 2010)
• Microsoft Excel Date Systems for Windows and Mac (June 23, 2010)
• Navigating Regions in Excel (June 21, 2010)
• Select a Current Region of Data in Excel (June 19, 2010)
• Organizing Data Into Regions (June 17, 2010)
• Expand Menus in Excel 2003 (June 15, 2010)
• Microsoft Excel 2010 on the iPad with the OnLive Desktop (February 12, 2010)