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
Using the SUMIFS Function in Excel
I would say one of the first things people learn in Excel is how to total up a column or row of numbers. This is done very simply by using the SUM function. The AutoSum button in most cases does … Continue reading
Posted in Excel, Microsoft Office, Office 2010
Tagged autosum, countifs, excel function, sum, sumif
Leave a comment
Counting Empty Cells in Excel Using the COUNTBLANK Function
So you might be aware of some useful functions that allow you to count up how many cells have text or a value in it using the COUNT function, you can also count cells based on specific criteria using COUNTIF … Continue reading
Posted in Excel, Microsoft Office, Office 2010
Tagged count, countblank, countif, excel function
Leave a comment
Upgrading to iOS 8
Another software update to Apple’s latest iOS for iPhone, iPad and iPod touch is almost here, 17th September 2014, and although upgrading is usually straightforward it is a really good idea to backup your device first. In fact I highly … Continue reading
Posted in iCloud, iOS, iOS 8, iPad, Iphone, Uncategorized
Tagged ios 8, iphone upgrade, upgrade ios
Leave a comment
How to Stop Videos Playing Automatically in Facebook on iPhone and iPad
Not so long ago Facebook added a feature where video started playing automatically as you scrolled through your timeline. I found this particularly frustrating and others have said to me that this has eaten away significantly at their mobile data … Continue reading
Posted in facebook, iPad, Iphone
Tagged Facebook, facebook autoplay, facebook video, iOS, iPad, iphone, ipod touch
Leave a comment
Showing the Last Saved Date of a Word Document
There are things that are handy in Word that we can get to display automatically in the body text of a document, header and/or footer like the current date, page number, author, file location etc. This week I was asked … Continue reading
Posted in Microsoft Office, microsoft word, word, word 2010
Tagged display information microsoft, productivity, quick parts, word fields
Leave a comment
Better Security on Apple’s iCloud Available to You
So some celebrities thought a good place to store photographs of themselves in various states of undress was somewhere online! I guess they could be forgiven for believing that online cloud storage like Apple’s iCloud should offer them security and … Continue reading
Posted in cloud, iCloud, mobile computing, mobile devices, security
Tagged apple's icloud, celebrity photos, cloud, leaked photos, security
Leave a comment
Making Font Bigger on iPhone
As so many of my friends are hitting that age where they need reading glasses it has become apparent that reading the text on their iPhones has become a little tricky or they have to keep putting on their glasses. … Continue reading
Posted in iOS, iOS 7, Iphone, Uncategorized
Tagged font size, iOS, iPad, iphone, text size
Leave a comment
Open Favourite Documents Quickly in Word, Excel, PowerPoint and Access
We all have documents we use regularly and even though they conveniently appear on our recent file list we can make them even more prominent. This can be done by pinning these files in the recent files list. This is … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, windows 7, word, word 2010
Tagged jump lists, pinning documents, recent documents, recent files, windows
Leave a comment
Using Do Not Disturb Feature on iPhone and iPad
Before the Do Not Disturb feature came along on my iPhone I had to make sure it was switched to silent before going to sleep. Like so many I keep my iPhone on overnight but if it wasn’t switched to … Continue reading
Organizing Meetings Made Easy Using Doodle.com
Organizing meetings, training sessions or events by email often takes ages or never happens. However, there is something I have been using along with many other people I know. Doodle.com. It is easy to use and you can give people … Continue reading
Posted in Management, productivity, Technology, utility
Leave a comment
Gary Schwartz's Blog 