spreadsheet Tutorials
-
Aug
5
Freeze a Column in Microsoft Excel
Written by David Samson, in Category Microsoft ExcelMicrosoft Excel offers users a helpful function known as Freeze Panes. Freeze Panes allows users to freeze a …
-
Jul
30
Using Relative References in Excel Formulas
Written by David Samson, in Category Microsoft ExcelThis tutorial will demonstrate how to use relative references in Microsoft Excel Formulas. Microsoft Excel allows users to …
-
Jul
27
Stop Excel from Autocorrecting Words
Written by David Samson, in Category Microsoft ExcelWhen writing a list, Microsoft Excel autocorrects some words by default. Sometimes this feature can be frustrating. Excel …
-
Jul
23
Combine Two Columns Into One in Microsoft Excel
Written by David Samson, in Category Microsoft ExcelFor many Microsoft Excel users, combining two columns into one can be an especially helpful function. If you …
-
Jul
21
AutoSum a Column or Row in Excel
Written by David Samson, in Category Microsoft ExcelMicrosoft Excel offers a convenient and easy to use function known as AutoSum. With AutoSum, Excel can automatically …
-
Jul
20
Add Headers or Footers to an Excel Spreadsheet
Written by David Samson, in Category Microsoft ExcelWhen making a spreadsheet in Microsoft Excel, you may find it helpful to attach a header or footer …
-
Jul
14
Store Numbers as Text in Microsoft Excel
Written by David Samson, in Category Microsoft ExcelWhen you input a number into Microsoft Excel, it is automatically stored as a number. Makes sense, right? …
-
May
5
How to Use Paste Special in Microsoft Excel
Written by David Samson, in Category Microsoft Excel, SoftwareNot sure how to add a photo to your Microsoft Excel spreadsheet? Paste special is a feature that …
-
Feb
2
Sorting Data Using Multiple Columns in Excel
Written by Jeremy Reis, in Category Microsoft ExcelMicrosoft Excel is great at processing large amounts of data. You can quickly look at information, calculate different values based on it, and sort data to find the largest or smallest values. You can also sort multiple columns of data so you can sort on multiple data points. Learn how in this Excel tutorial.
-
Feb
1
Using Go To Special in Excel
Written by Jeremy Reis, in Category Microsoft ExcelGo To Special allows you to select unique types of cells such as blank ones, formulas, numbers, and more. This is a great command to clean data and process your Excel spreadsheet.