### 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

## 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

## Compare Data in Excel Lists

This is one of those things I get asked about on a regular basis. It is when someone has two lists and they need to check that they have the same data. It could be an old list that needs … Continue reading

Posted in Excel
Tagged comparing data, comparing lists, excel, excel database, excel list, vlookup
Leave a comment

## Printing a Selection with Excel 2010

This is another one of those questions I get asked regularly “how can I print just this section in Excel?”. Thankfully the answer to this is easy and can be done in one of two ways. One is to select … Continue reading