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: visual basic for applications
Speed Up Your Work Using Macros in Excel
The thing about Excel is you can have the same old tasks to do day after day. Import some data, then format it to look like the data the previous day and the day before that, then create a chart, … Continue reading
Posted in Excel, Uncategorized
Tagged excel, macro, macros, Microsoft 365, microsoft excel, record macro, vba, visual basic for applications
Leave a comment
VBA: Using the IF Statement
The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading
Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications
Tagged excel, ms project, vba, visual basic for applications, word
1 Comment
Recording Macros in Excel to Make Tasks Easier
Excel is a great program and it is even better when you get it to do repetitive or complex tasks at a click of a button. You’ve thinking but how is that possible when everyone has different requirements and tasks … Continue reading
Posted in Excel, Office 2010
Tagged automating tasks, visual basic, visual basic for applications
1 Comment
Gary Schwartz's Blog 