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
Category Archives: Office 2010
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
Add Video to a PowerPoint Presentation
Whenever you go to a presentation it seems that most of the time they are using PowerPoint to help get their message across and adding video can certainly help. Video has certainly become easier to create even using your phone … Continue reading
Mail Merge Using Microsoft Word and Excel
We see it everyday, personalised emails, letters and brochures sent to us. It makes it feel like someone has made the extra effort to write to us. As it happens this is quite easy to do using a feature in … Continue reading
Posted in Excel, Microsoft Office, microsoft word, Office 2010, word, word 2010
Tagged mail merge, merge excel, merge to email
1 Comment
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
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
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
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
Protecting Worksheets in Excel
Protecting worksheets in Excel allows you to stop anything being changed on a worksheet or specifying that particular cells can be changed whilst others cannot. This is very useful if you want to make sure that certain cells are not … Continue reading
Posted in Excel, Microsoft Office, Office 2010
Tagged lock cells, password excel, protect sheet, protect worksheet
1 Comment
Gary Schwartz's Blog 