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
Category Archives: Microsoft Office
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
Syncing Office for iPad with Your Mac
If you have got Office for iPad you’ll have soon realised how useful it is and in my opinion better than the other programs that try and use Office files like Word, Excel and PowerPoint. You’ll also have noticed it … Continue reading
Posted in Excel, iPad, Microsoft Office, PowerPoint, word
Tagged microsoft cloud, office for ipad, onedrive, skydrive, sync documents
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
How to Use Excel PivotTables
Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office
Tagged data analysis, data source, excel, microsoft excel, pivottables
1 Comment
Importing and Exporting Data in Excel
Excel does many useful things and entering data so that you can do calculations or manipulate data. However, sometimes you need to bring that data in from somewhere else or you need to export it to be used in another … Continue reading
Posted in Excel, Microsoft Office
Tagged excel export, excel import, export csv, export text file, import csv, import text file, save as csv
Leave a comment
Getting Started with PowerPoint
If you have watched any presentation over the past couple of decades then the chances are you have watched a PowerPoint presentation. If you need to create your own presentation and have either not done one before or need a … Continue reading
Microsoft Access: How to Use the Update Query
If you have been following my blog since the beginning of this week you will have seen that I have been looking at action queries in Microsoft Access. These are queries that are using for changing the data sets such … Continue reading
Posted in Microsoft Access, Microsoft Office, Office 2010
Tagged action queries, action query, microsoft access, update query
Leave a comment
Microsoft Access: How to Use the Append Query
So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can … Continue reading
Gary Schwartz's Blog 