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 2010
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
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
Reducing the File Size of a Word Document That Has Images / Photographs
Adding images and/or photographs to a Word document can significantly increase the size of the file. In all likelihood the images do not need to be as high quality as you would need if you were printing the image out … Continue reading
Posted in Office 2010, word, word 2010
Tagged assignment, dissertation, proposal, reduce file size, word 2011, word 2013
Leave a comment
Word Hyperlinks: Creating Links to Websites, Emails and Files
Adding a link to a website, email address or file in a Word document can be very useful. When you type in a website or email address it automatically creates the link, however, you may want to remove the link … Continue reading
Creating Newspaper Style Columns in Word
If you are creating a newsletter or just need to use columns in a Word document then using columns is something that is easy to use and quick to learn. Here in this video tutorial you will see how to … Continue reading
Posted in word, word 2010
Leave a comment
Gary Schwartz's Blog 