Basic Excel Tutorials 10 Articles
Basic excel tutorials, tricks, and tips. Start as a newbie and work up to a pro. In addition, you gain access to our pro network of users. Each basic excel tutorial is designed to be easy to follow and educational.
- Find & Select
- Find & Replace
- Data Filtering – Single and Multiple Filters in Excel
- Calculate Compound Annual Growth Rate
- Calculate Annual Growth Rate
- Check boxes in Excel
- Using Check boxes in Excel
- Selecting All Formula Cells in a Worksheet
- Print to Fit on “X” Number of Pages
- Row vs Column – What is the difference?
Excel Functions 22 Articles
We cover the most popular and useful excel functions. We try and cover all of the functions and show how to use them effectively. Many of the tutorials come with downloadable files. Therefore, it is easy to learn from expert examples. As a result, the learning curve for this area should be small.
- Countif Function in Excel – Single Criteria
- Countifs Function in Excel – Multiple Criteria
- Vlookup Function – Advanced with calculations
- Sumproduct Function in Excel – Multiple Arrays
- Dsum Function in Excel
- PMT Function – Mortgage Calculator in Excel
- Date Function in Excel = Date(year,month,day)
- FV Function – Future Value Calculation in Excel
- AutoSum Function in Excel
- Autofilter Functionality in Excel
Excel Data Analysis 6 Articles
Excel Data Analysis is the primary reason for using the software to begin with. If you can't understand your data, then your whole spreadsheet is useless. Learn how to use features in excel to dissect data. Also, learn how to master Pivot tables and other charting options.
VBA (Visual Basic for Applications) 8 Articles
VBA (Visual Basic for Applications) is programming language that is used in several Microsoft products. We have a beginners course to teach you how create scripts of your own.