Subscribe
Tutorial search

# Excel Sin Tutorials

Sort by:
Autosum feature is used to make summing operation as fast as possible. I presented a few ways you can use Autosum.
Difficulty:
Excel Sumif
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Difficulty:
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
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
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
Keep track of birthdays using Excel to automatically format the birthdays due this month. Never miss a birthday again.
Difficulty:
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
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
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
A few methods to get the weekday of a date as text, using vba and standard functions.
Difficulty:
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
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
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
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
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