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
Tag Archives: microsoft excel
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
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 2010: Conditional Formatting
Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly … Continue reading
Posted in Excel, Office 2010
Tagged conditional formatting, conditions in excel, excel appearance, microsoft excel
Leave a comment
Gary Schwartz's Blog 