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
Photoshop Layers: Adding Text
If you want to add some text to a photograph using Photoshop then you are better off adding it as a layer. It give you more control and retains the original image should you ever change your mind. Here you … Continue reading
Understanding Photoshop Layers
Layers are a really useful feature of Photoshop, however, all too often I meet people who hear about them and then put off using Photoshop yet they are quite easy to use. Once I explain what they are for and … Continue reading
Posted in adobe creative cloud, photography, Photoshop
Tagged adobe photoshop, composite, layers, photoshop layers
3 Comments
The Trick to Moving PowerPoint Presentations from a Mac to a Windows PC
I hear this all to often “I’m not getting a Mac again as I can’t use my PowerPoint presentations on a Windows PC”. Well yes you can and the same applies from Windows to a Mac. I usually hear this … Continue reading
Wi-Fi Assist Could Be Using Up Your Mobile Data Allowance on Your iPhone pt iPad
It seems like a good idea that if you don’t have a good wifi connection your iPhone or iPad will switch to using your mobile connection whether it be 3G or 4G. The down side to this is if it … Continue reading
Posted in iOS 9, iPad, Iphone, wifi
Tagged 3g, 4G, data allowance, ios 10, ios 9, iPad, iphone, mobile data, wifi assist
Leave a comment
Marking Up Photos You Email in iOS 9
I imagine many of us send photos using our email and I bet that is almost a daily occurrence. Whoever had the idea of putting a camera in a phone is partly to blame and also a stroke of genius. … Continue reading
Posted in iOS 9, iPad, Iphone, iPhone 5S, iPhone 6, iPhone 6 Plus
Tagged annotate photo, draw on photo, email photo, mail app, markuo map, text on photo, zoom in ion photo
Leave a comment
Using Dropbox to Share Files and Folders
I can’t believe that at one point I would have to share files by sending floppy discs, CDs or DVDs to clients, colleagues, friends and family. Today not only can I send bigger files it is almost instant. It seems … Continue reading
Posted in file management
Tagged android dropbox app, backup, dropbox, file sharing, ios dropbox app, sharing photographs, sharing video
1 Comment
Public Transport Info in the New Maps App in iOS 9
Next time you are running for that bus or train and wondering if you are going to make it you can check when it is going to arrive with the new Apple Maps in iOS 9. If it looks like … Continue reading
Posted in iOS, iOS 9, iPad, Iphone
Tagged apple maps, bus times, london underground times, metro times, public transport information, train times, travel information
Leave a comment
New Notes App in iOS 9
I use the Notes app on my iPhone and iPad a lot. I always seem to be hitting something down and have found the app really useful. However, with the release of iOS 9 Apple have upped the ante and … Continue reading
How to Select Visible Cells in Excel
If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals. What would help is a command or … Continue reading
Posted in Excel, Office 2010
Tagged copy and paste, hidden columns, hidden rows, subtotals
Leave a comment
Getting Started with Charts for Excel for Mac 2011
Charts are a really useful way to present data and to analyse it. Aside from being good at doing calculations Excel is also good at creating charts. There are lots of different options for creating the charts and what you … Continue reading
Posted in Charts, Excel
Tagged excel 2011, excel charts, excel charts for mac, excel mac
Leave a comment
Gary Schwartz's Blog 