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
Author Archives: garysch
Using Practice Session for a Zoom Webinar
Zoom webinars have become very popular this year and I have helped run many of them along with virtual conferences. One of the things I find useful is the practise (UK spelling) session, it allows me to get all the … Continue reading
How to Get Even Wider Angle Photos on Your iPhone
iPhones are pretty good for getting wide-angle photos and some like the iPhone 11 Pro and the iPhone 12 Pro have an extra lens that gives an extra wide view. However, there are times where you want to get even … Continue reading
Posted in Uncategorized
Leave a comment
How to Get Better Quality Zoom Recordings
Zoom is used a lot now for meetings and webinars and I’m sure like many you record them to edit and add to your website, YouTube, Vimeo or other social media platform. The quality of the recordings are ok and … Continue reading
Using WhatsApp on an iPhone with Dual SIM
One of the things I hadn’t taken into account when I got my iPhone was how would WhatsApp work with two SIM cards in the same iPhone. I was so pleased to be able to take one phone with me … Continue reading
Posted in iOS, Iphone, WhatsApp
Tagged dual sim, iphone, iPhone dual sim, WhatsApp, WhatsApp dial sim
Leave a comment
Using Your iPhone When on a FaceTime Call
One of the things about FaceTime, if you are doing a video call, is that if you want to do something else like look something up, check an email or any of a whole multitude of things you can do … Continue reading
How to Use Consolidate Data in Microsoft Excel
If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate … Continue reading
How to Use Excel Flash-fill
Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading
Posted in Excel, excel data
Tagged autofill, excel autofill, excel data, excel list, excel tip, excel tutorial, flash fill, flash-fill, flashfill, learn excel, Microsoft 365, microsoft excel, office 365
Leave a comment
How to Remove Duplicates in an Excel List
If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to … Continue reading
Using Your Apple Watch to Take Photos with Your iPhone
Why not go one step further than taking a selfie with your iPhone and Apple Watch. Since you can use the Apple Watch as a remote control for your iPhone camera why hold your iPhone at arms length when you … Continue reading
Posted in Apple, Apple Watch, Iphone, photography
Tagged Apple Watch, iphone, photography, selfie
Leave a comment
Improve Your Recordings or Your Zoom, Skype and MS Teams Calls Using a Ring Light
This is a common problem when filming yourself and that is getting the lighting right. It doesn’t just apply to filming if you are on a video call, like Zoom, Skype or MS Teams, then you know how often people … Continue reading
Posted in Android, camera, elearning, Iphone, MS Teams, skype, Smartphone, Zoom
Leave a comment