Subscribe
Tutorial search

Excel Sin Tutorials


Sort by:
Adding Numbers using Autosum
Adding Numbers using Autosum
Autosum feature is used to make summing operation as fast as possible. I presented a few ways you can use Autosum.
Difficulty:
Excel Sumif
Excel Sumif
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Difficulty:
Excel Date & Time Functions
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
Difficulty:
Using Sparklines in Excel 2010
Using Sparklines in Excel 2010
Use Sparklines in Excel 2010 as a visualisation tool to see data trends at a glance. Sparklines are mini charts inserted inside cells of Excel 2010.
Difficulty:
Array Formulas in Excel
Array Formulas in Excel
Arrays in Microsoft Excel are not a single function, but actually a variety of different formulas that you can use to simplify your work with arrays.
Difficulty:
Highlight Birthdays Due this Month in Excel
Highlight Birthdays Due this Month in Excel
Keep track of birthdays using Excel to automatically format the birthdays due this month. Never miss a birthday again.
Difficulty:
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
If you work with a team of people using Excel, you may want to protect your Excel Spreadsheet from changes. Adding a password in order for people to make changes does just that.
Difficulty:
Excel VBA Loop
Excel VBA Loop
The Excel VBA Loop (or For Next loop) is a very useful programming statement which is often used in Excel VBA. First we will look at an easy example of how to loop through a one-dimensional range. You can also loop through a two-dimensional range using a Double Loop. In a similar way you can use three loops (a triple loop) to loop trough two-dimensional ranges on different Excel Worksheets. Besides For Next loops, there are other loops in Excel VBA, such as Do While Loops and For Each Next Loops.
Difficulty:
Excel VBA Array
Excel VBA Array
An Excel VBA Array is a group of variables. You can refer to a specific variable (element) of an Array by using the Array name and the index fnumber. This tutorial explains how to declare and initialize a one-dimensional and two-dimensional Array, how to Redim an Array and how to find the size of an Array.
Difficulty:
Get the Weekday as Text in Excel VBA
Get the Weekday as Text in Excel VBA
A few methods to get the weekday of a date as text, using vba and standard functions.
Difficulty:
Better Charts in Excel using Photoshop
Better Charts in Excel using Photoshop
When creating charts in Excel, you are limited to generic colors and themes. However, by exporting the graph into Photoshop, you can easily transform a once boring graph into a stunning masterpiece.
Difficulty:
Excel 2003 Using Range Names
Excel 2003 Using Range Names
In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis.
Difficulty:
Sorting Worksheet Data
Sorting Worksheet Data
This technique introduces you to the process of sorting worksheet data. It begins by covering the basic sorting of the records in a data list using one, two, or even three fields in the list.
Difficulty:
How to make True Time Scale Line Chart Using Scatter Graph
How to make True Time Scale Line Chart Using Scatter Graph
Adjusting time scale on x-axis in standard line chart could be a headache. It is kind of a trial and error process to make the time scale fit in, distribute the labels properly and last date being shown correctly at the end of x-axis.
Difficulty:
MS-Excel Formulas
MS-Excel Formulas
Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.
Difficulty:
Search Term(s) (1): sin