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
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
Excel: Using Data Tables
Analyzing data in Excel is one of its great features and there are a number of tools for doing this, aside from sometimes just changing a value and seeing what happens. If you have done this then there is an … Continue reading
Posted in Excel, Uncategorized
1 Comment
Microsoft Access: How to Use the Delete Query
As the names suggests this type of action query is going to delete data so if you are doing this for the first time try this on some data you are not worried about losing or on a copy of … Continue reading
Posted in Excel
Tagged action queries, action query, delete queries, delete query, make table query, microsoft access
1 Comment
Excel Using Text Functions
Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID. You can … Continue reading
Excel How to Use Subtotals
Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine … Continue reading
Posted in Excel
Tagged excel data, excel subtotals, grouping and totalling, microsoft excel, subtotals
1 Comment
Combining VLOOKUP and HLOOKUP Functions
HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading
Posted in Excel, Office 2010
Tagged excel functions, hlookup function, lookup matrix, microsoft excel, vlookup function
2 Comments
Excel Database Functions
So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one … Continue reading
Posted in Excel, Office 2010
Tagged database functions, DMAX, DMIN, DSUM, DVAVERAGE, ECDL adavanced, excel database, excel functions
1 Comment
Remove Duplicates in Excel
I’m often asked how to remove duplicate entries in an Excel list or database, they are the same thing but Microsoft have more recently called them lists. Thankfully it is easy to do, particularly on more recent versions of Excel. … Continue reading
Posted in Excel, Office 2010
1 Comment
Gary Schwartz's Blog 