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
Switching Data Around in Excel
Have you got some data in an Excel worksheet that you have going across in a row but would prefer to have in a column or vice versa? Many times I have seen people copy cells one by one into … Continue reading
Posted in Excel, Office 2010
Tagged Columns to rows, Excel paste special, Rows to columns, Transpose data
Leave a comment
Finding Your Way Around Excel 2010
Seems like the Ribbon that Microsoft have introduced in Office 2007 should have been a good idea but it seems to have confused people, I know this because my wife found the switch over difficult and I did lots of … Continue reading
Posted in Excel
Leave a comment
Using Excel Functions on a Mac
OK, so this one is a little specific but as both a Windows and Mac user the one thing that does frustrate me is that Excel on a Mac uses the Insert Function differently to how it works on Windows. … Continue reading
Posted in Excel
Tagged excel functions, if function, insert functions, mac functions, pmt function, vlookup
Leave a comment
Printing a Selection with Excel 2010
This is another one of those questions I get asked regularly “how can I print just this section in Excel?”. Thankfully the answer to this is easy and can be done in one of two ways. One is to select … Continue reading
Excel 2010 and Functions
Excel is one of the best software packages out there. It can be used for doing simple things like creating lists or doing straightforward calculations through to automating processes and advanced calculations. There is something for everyone and it is … Continue reading
Gary Schwartz's Blog 