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: action queries
Microsoft Access: How to Use the Update Query
If you have been following my blog since the beginning of this week you will have seen that I have been looking at action queries in Microsoft Access. These are queries that are using for changing the data sets such … Continue reading
Posted in Microsoft Access, Microsoft Office, Office 2010
Tagged action queries, action query, microsoft access, update query
Leave a comment
Microsoft Access: How to Use the Delete Query
As the names suggests this type of action query is going to delete data so if you are doing this for the first time try this on some data you are not worried about losing or on a copy of … Continue reading
Posted in Excel
Tagged action queries, action query, delete queries, delete query, make table query, microsoft access
1 Comment
Microsoft Access: How to Use Make Table Query
Microsoft Access has different types of queries to do everything from just viewing selected data to archiving it using a make table query, deleting data, appending data and updating data. For the next few days I will be adding video … Continue reading
Posted in Microsoft Access, Office 2010
Tagged access queries, access query, action queries, action query, archive data, make table query, microsoft access
1 Comment