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
Where Do Downloaded Files Go?
Ever clicked on a link to download a file, maybe from a website, link in an email, Dropbox or somewhere else and then wondered where the file you download went. Whether you are using Windows or a Mac they seem … Continue reading
Protecting Your Computer from Cyber Attacks
I’m sorry if I sound like a broken record but the news is regularly alerting us to threats to steal our information, access our bank accounts or take control of our computers. So what do you do about it? Well … Continue reading
Posted in Uncategorized
Leave a comment
How to Turn a Custom Function into an Add-In
Custom functions as you will gave seen from my previous post are really useful, however, you may want to make them available to all of your workbooks or distribute them to other people such as colleagues or classmates. To do … Continue reading
Posted in Uncategorized
Leave a comment
Excel: How to Create a Custom Function
Excel has lots of built-in functions that do everything from summing up a column or row of numbers to loan repayments, statistics, engineering, trigonometry and so much more. Every now and again someone asks how they can create their own … Continue reading
Posted in Excel, VBA, Visual Basic for Applications
Tagged custom functions, microsoft excel
Leave a comment
VBA: Using the IF Statement
The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications
Tagged excel, ms project, vba, visual basic for applications, word
1 Comment
VBA: Understanding Variables
If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading
Changing Your eBay Password
It seems we all have to be on the look out for the next online service that’s going to be hacked and get a warning to change out passwords to avoid some nasty person getting into out account. Recently it … Continue reading
Posted in Computing, eBay, Internet, iPad, Iphone, mobile devices, Shopping Online, Smartphone
Tagged account security, ebay account, ebay password
Leave a comment
How to Use Motion Paths in PowerPoint Including Custom Paths
If you have been using PowerPoint then you have probably added some animations to bullet points at the very least to add a bit of movement to your presentations. Many of us would like to do something a bit different from … Continue reading
Posted in Microsoft Office, Office 2010, PowerPoint
Tagged animation, custom paths, motion paths, powerpoint animation
Leave a comment
How to Check for Dust on Your DSLR Sensor
If you have a DSLR camera and change the lens on it, one of the advantages of a DSLR, there is a chance you can get dust into the camera that can end up on the sensor. If you get … Continue reading
Posted in digital photography, dslr, photography
Tagged canon, eos, eos 5d mark iii, nikon
Leave a comment
Gary Schwartz's Blog 