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
How to Remove Duplicates in an Excel List
If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to … Continue reading
Excel’s Newest Function XLOOKUP
VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading
Creating a Chart in Excel When Data is Not Next to Each Other
Excel has some great features for creating charts, I remember when I first started using it and saw how easy it was to create one. You would not believe what I had to do to create a chart before then … Continue reading
Posted in Excel, Microsoft Office
Leave a comment
How to Enter a Series of Dates in Excel That Are Only Weekdays
Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays. All … Continue reading
Posted in Excel, Microsoft Office
Tagged autofill, dates, entering dates, excel, microsoft excel, weekdays
1 Comment
Excel: How to Enter the Same Day but Different Month and Year
We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on … Continue reading
Posted in Excel, Microsoft Office
Tagged autofill, autofill dates, autofill months, autofill years, excel autofill
Leave a comment
How to Select Visible Cells in Excel
If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals. What would help is a command or … Continue reading
Posted in Excel, Office 2010
Tagged copy and paste, hidden columns, hidden rows, subtotals
Leave a comment
Getting Started with Charts for Excel for Mac 2011
Charts are a really useful way to present data and to analyse it. Aside from being good at doing calculations Excel is also good at creating charts. There are lots of different options for creating the charts and what you … Continue reading
Posted in Charts, Excel
Tagged excel 2011, excel charts, excel charts for mac, excel mac
Leave a comment
Copying Excel Data into a Word Document
If you use both Excel and Word you may well want to copy data from Excel into Word and what would be really convenient is if the data in Word updated when you change it in Excel. Well that is … Continue reading
Posted in Excel, microsoft word, productivity
Tagged excel tip, linking data, microsoft excel, microsoft office, Microsoft word, paste special, productivity, word tip
Leave a comment
Selecting Data in Non-Adjacent Cells to Create Excel Chart
Creating charts in Excel is pretty straightforward and you can see how to that in this video, getting started with charts. What normally happens is you select a group of cells and then insert a chart but what do you … Continue reading
Posted in Excel, Microsoft Office
Tagged excel charts, excel graph, microsoft excel, nonadjacent cells, plot chart, plot graph, selecting cells
1 Comment
Useful Site of Excel Functions
Excel is such a useful program but many people using it only scratch the surface. One of the most useful things about Excel are its functions for doing calculations. They are basically built in formula to work out everything from … Continue reading
Posted in Excel, Excel Functions, Microsoft Office
Tagged excel functions, hlookup, pmt, sum, vlookup
Leave a comment
Gary Schwartz's Blog 