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: word
How to Create Your Own Template in Microsoft Word
You’ve probably seen the array of templates that come with Microsoft Word, but what if you want to create your own. It’s really easy to do. There are advantages to using templates especially if you have forms or documents you … Continue reading
Posted in Microsoft 365, Microsoft Office, microsoft word, word
Tagged microsoft word, productivity, templates, word template
Leave a comment
How to Crop Photographs and Images in Word
If you are adding a photograph, image or picture to Microsoft Word and you need to crop it you don’t need to do that before you insert it into your document you can crop it directly in Word. The advantages … Continue reading
Posted in Microsoft Office, microsoft word, productivity, Uncategorized, word
Tagged aspect ratio, crop, crop images, crop photo, crop photograph, crop picture, crop to shape, formatting pictures, images, microsoft word, photographs, pictures, rounded corners, word document, word formatting
Leave a comment
Creating an Index in Word
An index is an important way to reference key words or phrases in a Word document. It compliments a table of contents and allows your readers to look for something specific n Thankfully you do not need to type out … Continue reading
Posted in Microsoft Office, microsoft word, word, word 2010
Tagged book, dissertation, index, instructions, manual, Microsoft word, table of contents
Leave a comment
Creating a Table of Contents in Word
You know that feeling where you need to type up some instructions and you think it is not going to be too extensive but ends up being pages and pages, well that was one of the tasks when I recently … Continue reading
Posted in Microsoft Office, microsoft word, word, word 2010
Tagged book, dissertation, index, instructions, manual, table of contents
Leave a comment
Convert a Pages Document to Word or PDF
Pages is such a useful app, and nicely priced too. It has the advantage of connecting up with the iCloud which means I can work on documents on my Mac, iPhone or iPad. It all seems to work seamlessly. However, … 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
Showing the Last Saved Date of a Word Document
There are things that are handy in Word that we can get to display automatically in the body text of a document, header and/or footer like the current date, page number, author, file location etc. This week I was asked … Continue reading
Posted in Microsoft Office, microsoft word, word, word 2010
Tagged display information microsoft, productivity, quick parts, word fields
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: 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
Gary Schwartz's Blog 