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: Excel
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
How to Use the SUMPRODUCT Function in Excel
Many people will have at least two columns or rows of numbers that first need multiplying together and then totalling up. In most cases they will create a formula that multiplies them together and then use the SUM function to … Continue reading
Posted in Excel, Excel Functions, Microsoft Office
Tagged excel, excel functions, how-to, maths functions, SUM function, SUMPRODUCT function
Leave a 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
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
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
Gary Schwartz's Blog 
Excel: Inserting, Editing and Deleting Comments
Excel can contain lots of information and sometimes it would be handy to add a note to various cells within the worksheet as reminders, things to check, how you created a formula or even where you got the resources for … Continue reading →