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
Monthly Archives: December 2013
Microsoft Access: How to Use the Append Query
So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can … Continue reading
Microsoft Access: How to Use the Delete Query
As the names suggests this type of action query is going to delete data so if you are doing this for the first time try this on some data you are not worried about losing or on a copy of … Continue reading
Posted in Excel
Tagged action queries, action query, delete queries, delete query, make table query, microsoft access
1 Comment
Microsoft Access: How to Use Make Table Query
Microsoft Access has different types of queries to do everything from just viewing selected data to archiving it using a make table query, deleting data, appending data and updating data. For the next few days I will be adding video … Continue reading
Posted in Microsoft Access, Office 2010
Tagged access queries, access query, action queries, action query, archive data, make table query, microsoft access
1 Comment
Excel Using Text Functions
Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID. You can … Continue reading
Excel How to Use Subtotals
Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine … Continue reading
Posted in Excel
Tagged excel data, excel subtotals, grouping and totalling, microsoft excel, subtotals
1 Comment
Combining VLOOKUP and HLOOKUP Functions
HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading
Posted in Excel, Office 2010
Tagged excel functions, hlookup function, lookup matrix, microsoft excel, vlookup function
2 Comments
Free Apps, Songs, Books, TV Shows and Movies for your iPhone and iPad…
…with the free 12 days of Christmas app from iTunes. Everyday from the 26th December for 12 days there is one free item. I have done this now for the past few years and although not everything is something I … Continue reading
Posted in iOS, iOS 7, iOS6, iOS7, iPad, Iphone, iTunes
Tagged free apps, free books, free films, free movies, free songs, free TV shows
Leave a comment
Excel Database Functions
So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one … Continue reading
Posted in Excel, Office 2010
Tagged database functions, DMAX, DMIN, DSUM, DVAVERAGE, ECDL adavanced, excel database, excel functions
1 Comment
Excel: Using the HLOOKUP Function
Some time ago I did a tutorial on VLOOKUP and have finally got around to doing one on the HLOOKUP function. It is very similar except that the data is in columns as opposed to rows as you would find … Continue reading
Posted in Uncategorized
Leave a comment
Remove Duplicates in Excel
I’m often asked how to remove duplicate entries in an Excel list or database, they are the same thing but Microsoft have more recently called them lists. Thankfully it is easy to do, particularly on more recent versions of Excel. … Continue reading
Posted in Excel, Office 2010
1 Comment