Latest Tutorial: PowerPoint Creating a Video from Presentation
Check out my latest tutorial on my website. How to create a video from a PowerPoint Presentation-
Recent Posts
Archives
Buy me a coffee
Donation
If you like this free blog and would like to help keep it going then a coffee will help.
$2.00
Categories
Meta
Latest Tutorials
- About
- AutoFill to Copy Data, Values,Functions and Formulas and Also to Create a Series
- AutoSum to Total Up a Column, Row or Range
- Calculating the Number of Days Between Dates
- Conditional Formatting
- Contact
- Creating a Pie Chart in Excel 2003
- Excel Tutorials
- Formatting Data Series in a Chart
- Freeing Up Memory on Your Mac OS X
- Getting Start with Charts in Excel 2010
- Getting Started with Excel 2010
- Goal Seek
- IF Function
- Introduction to Date Functions
- Introduction to Excel Functions
- Introduction to Functions on a Mac
- Naming Cells and Ranges
- PowerPoint Tutorials
- PowerPoint: Using Slide Master
- Printing a Selected Area
- Recording a Macro in Excel 2003
- Resizing Columns and Rows
- Splitting the First Name and Last Name in a Cell into Two Separate Cells
- SUMIF Function
- The COUNTIF Function
- The Payment (PMT) Function for Calculating Repayments on Loans
- Using a Percentage in a Formula
- Using Data Validation to Create a Drop Down List
- Using Scenarios (also known as the Scenario Manager)
- Using the $ signs in an Excel Formula or Function for Absolute and Mixed Referencing
- Using the TODAY() Function to Calculate Someone’s Age
- VLOOKUP Function
Follow me on Twitter
My Tweets
Tag Archives: excel
Excel: Using the MAX() and MIN() Functions
Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed … Continue reading
Excel: Using the LARGE() and SMALL() Functions
If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so … Continue reading
How to Enter a Series of Dates in Excel That Are Only Weekdays
Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays. All … Continue reading
Posted in Excel, Microsoft Office
Tagged autofill, dates, entering dates, excel, microsoft excel, weekdays
1 Comment
How to Use the SUMPRODUCT Function in Excel
Many people will have at least two columns or rows of numbers that first need multiplying together and then totalling up. In most cases they will create a formula that multiplies them together and then use the SUM function to … Continue reading
Posted in Excel, Excel Functions, Microsoft Office
Tagged excel, excel functions, how-to, maths functions, SUM function, SUMPRODUCT function
Leave a comment
VBA: Using the IF Statement
The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications
Tagged excel, ms project, vba, visual basic for applications, word
1 Comment
How to Use Excel PivotTables
Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office
Tagged data analysis, data source, excel, microsoft excel, pivottables
1 Comment
Excel Formulas, Getting Started with Calculations
There are many things that Excel can do but fundamentally it is used for doing calculations. These can be simple or complex. I’ve done quite a few on functions and also some that use multiple functions but I needed to … Continue reading
Posted in Excel, Office 2010
Tagged autosum, bodmas, excel, excel calculations, formulas, formulas in excel
6 Comments
How to Get Multiple Lines in an Excel Cell
This is a common request in Excel, how do you have more than one line in a cell? All you need to do it turn word wrap on. In the video below you can see how to do it.
Excel Tip: Freeze Panes and Split Windows
If you have large worksheets when you scroll from side to side and up and down you cannot see what is in the top row and first column. Thankfully Excel has a couple of features to help sort this out. … Continue reading