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 data
Getting Started with Excel Tables – Effortless Filtering, Sorting and more
One thing about Excel is that it is really useful for organising data. You can sort it, filter it, rearrange it and analyse it. There are also many functions that can be used too. To make it even easier there … Continue reading
Posted in Excel, excel data
Leave a comment
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
Gary Schwartz's Blog 