Subscribe
Tutorial search

Excel And Tutorials


Sort by:
3 Special Excel Functions to Amaze You
3 Special Excel Functions to Amaze You
Want to up your Microsoft Excel game? This article will show you how to master three functions that will bring your skillset to the next and make you an Excel Wizard!
Difficulty:
Managing Projects with MS Project and Microsoft Excel
Managing Projects with MS Project and Microsoft Excel
Are you a project manager? If so, learning how to use Microsoft`s Excel and MS Project can be pivotal to your success.
Difficulty:
Excel Solver
Excel Solver
Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.
Difficulty:
Excel Countif and Sumif
Excel Countif and Sumif
Great Excel function tutorial covering Count, CountIf, Sum, SumIf, and SumProduct.
Difficulty:
Offset Function
Offset Function
The OFFSET function in Excel has a wide variety of capabilities. It can be thought of as similar to the VLOOKUP and HLOOKUP functions, but with additional flexibility.
Difficulty:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty:
Quick Access Toolbar
Quick Access Toolbar
If you use an Excel command frequently you can add its icon to the Quick Access Toolbar.
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:
Excel Sparklines
Excel Sparklines
Excel Sparklines are graphs that fit in one cell and give you information about the data.
Difficulty:
Excel VBA Function and Sub
Excel VBA Function and Sub
The difference between a function and a sub in Excel VBA is that a function can return a value and a sub cannot. Functions and subs become very useful as program size increases.
Difficulty:
Excel VBA Date and Time
Excel VBA Date and Time
This chapter explains how to get the year, month and day of an Excel VBA date, how to get the number of days between two dates, how to add a number of days to a date, how to get the current date and time, how to get the hour, minute and second of the current time and how to convert a string to a time serial number.
Difficulty:
Lookup in a Column to the Left in Excel
Lookup in a Column to the Left in Excel
Lookup data in a column to the left in Excel. The Vlookup function cannot look to the left in Excel. Index and Match can be used to lookup data from any column.
Difficulty:
Excel Vlookup
Excel Vlookup
The Vlookup function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table.
Difficulty:
Find Payments Due this Week
Find Payments Due this Week
Use Excel to find payments due this week. Use an Excel formula in Conditional Formatting to alert you to payments due this week and next week.
Difficulty:
MMult Function
MMult Function
The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two
Difficulty:
Search Term(s) (1): and