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
Filtering Data in Excel Using Autofilter
We all know Excel is great for doing calculations but it is also handy for managing lists of data which means being able to filter information to find what you are looking for. When Excel 2007 came out there were … Continue reading
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
Sorting Data in Excel
Excel is great for storing lists of data and you may need to manage that data by sorting it into order. Here is how you can sort data in Excel by doing a quick sort or by adding levels to … Continue reading
Posted in Uncategorized
Leave a comment
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
Tips for Making Your Wifi Go Faster
Have you wondered if your wifi or broadband is going as fast as it should. I often hear people saying that they don’t get the speed they expect when they get broadband. The provider quotes them a speed and then … Continue reading
Posted in Internet, wifi
Leave a comment
Excel 2010: Conditional Formatting
Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly … Continue reading
Posted in Excel, Office 2010
Tagged conditional formatting, conditions in excel, excel appearance, microsoft excel
Leave a comment
Switching Data Around in Excel
Have you got some data in an Excel worksheet that you have going across in a row but would prefer to have in a column or vice versa? Many times I have seen people copy cells one by one into … Continue reading
Posted in Excel, Office 2010
Tagged Columns to rows, Excel paste special, Rows to columns, Transpose data
Leave a comment
What’s New in iOS 6 for iPhone and iPad
A new iPhone is here and so is iOS 6 for other iPhones and the iPad and there are some changes that you are going to like and one or two you might not. One change that you might not … Continue reading
Sending a Message or Setting a Reminder When Declining a Call on Your iPhone with iOS 6
When you get a phone call on your iPhone and you are busy you can send a text message to let them know you will call them later or set a reminder to call them in an hour or when … Continue reading
Posted in Uncategorized
Leave a comment
Turning Off Notifications Temporarily in OS X Mountain Lion
If you’re doing a presentation or you need to do some work without being distracted or notifications are simply bugging you then you can temporarily switch them off easily.
Posted in Uncategorized
Leave a comment
Gary Schwartz's Blog 