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
Author Archives: garysch
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
Photography: Introduction to Aperture, F-Stop and Depth of Field
So far I haven’t really discussed photography, one of the things I enjoy doing and something I now do regularly on a professional basis. My blog tends to be about technology and lets face it cameras and photography use a … Continue reading
Posted in camera, digital photography, dslr, photography
Tagged aperture, bokeh, depth of field, digital photography, DSLR, f-number, f-stop
Leave a comment
Block Nuisance Calls and Texts (SMS) on iOS 7
How often do you get annoying calls or text messages? I seem to get them everyday from the same numbers trying to get me to upgrade my phone, tell me I can make a claim and how I can get … Continue reading
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
Tag Files in Mavericks OS X
Searching for files is something I seem to do everyday, I think this has been made worse by the volume of photographs I now take, much of this because it has become a key part of my work. However, it … Continue reading
Posted in mac os x, Mavericks
Leave a comment
Gary Schwartz's Blog 