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
Tag Archives: microsoft excel
How to Use Consolidate Data in Microsoft Excel
If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate … Continue reading
How to Use Excel Flash-fill
Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading
Posted in Excel, excel data
Tagged autofill, excel autofill, excel data, excel list, excel tip, excel tutorial, flash fill, flash-fill, flashfill, learn excel, Microsoft 365, microsoft excel, office 365
Leave a comment
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
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
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
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
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
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