Project Plan Template Excel – Free Download
PNRao2025-09-15T13:20:56+05:30Project planning is a critical part of successful project management. [...]
MOM Format – Minutes of Meeting Excel Template [Free Download]
PNRao2025-07-23T07:42:22+05:30Template Overview This template is a professional-grade tool from the [...]
ANALYSISTABS Version 4.0.0
PNRao2022-06-17T03:57:29+05:30ANALYSISTABS Version 4.0.0 is releasing today. I have added new utilities to navigate worksheets and enhanced Slider and Widget tools.
New Features
- Activate Worksheet: To quickly navigate the worksheets in the workbook
- Hide Sheets: To hide the active worksheet
- Unhide sheets: To Unhide the hidden worksheet
- Hide All Sheets: To quickly hide all worksheets in the workbook (except active worksheet)
- Unhide All Sheets: To quickly unhide all worksheets in the workbook
- Enhancements:New features added in Slider and Widget creators
ANALYSISTABS Version 3.0.0
PNRao2022-06-17T03:57:27+05:30Wish You Happy New Year - 2014
The new version 3 of ANALYSISTABS Excel Add-in is ready to release on 1st Jan 2014. This is more robust and powerful than the previous versions. This version is optimized to work on both 32 bit and 64 bit Operating Systems.Get ANALYSISTABS
Categorical or Comparative Data Analysis using Excel VBA
PNRao2022-06-17T03:57:12+05:30Categorical or Comparative Data Analysis is helpful to study the categorical data to understand and compare the metrics between different categories. For example, we can study effect of particular drug in various countries in health care projects. If we consider retail data, we may study POS (Point of Sales) Data, how is the sales in various regions of the country, or how many units are selling from each store or from each department of the supermarket.
Trend Analysis or Longitudinal Data Analysis using Excel VBA
PNRao2022-06-17T03:57:09+05:30Trend or Longitudinal Data Analysis is helpful to study historical data to understand change in data over particular time frame. Learn more with Examples.
In this topic, you can download example macro tool for Trend Analysis, with explanation of the below topics:
- Understanding requirement
- Understanding the Data
- Design and Planning
- Cleaning the Data
- Identifying the variables and creating new variables
- Plotting the Charts and Tables to understand the Data
- Providing Interactivity using VBA
- Providing Help or Guidelines to users
- Understanding Summarized Data
- Writing Overall Summary and Insights
Remove Alpha Special characters from Range using Excel VBA
PNRao2022-06-17T03:57:08+05:30Examples using Procedures and Function to Remove Alpha Special characters from Range using Excel VBA to get only numeric data from specific range.
Chart Styles Layouts and Templates in Excel
PNRao2022-06-17T03:57:01+05:30Creating Charts in Excel is very easy, we change the [...]
Create Charts in Excel
PNRao2022-06-17T03:56:49+05:30Well! we have seen some basics of charts in the [...]
Excel Chart Elements and Chart wizard
PNRao2022-06-17T03:56:45+05:30Many of our readers asking me to post tutorials to [...]
Excel Chart VBA Examples and Tutorials
PNRao2023-03-18T14:12:36+05:30Here are the top most Excel Chart VBA Examples and Tutorials, show you how to deal with chart axis, chart titles, background colors,chart data source, chart types, series and many other chart objects.
VBA MsgBox Excel Examples – 100+ Message Box Macros
PNRao2023-09-24T14:00:14+05:30The Message box(MsgBox) displays a message, optional icon, and selected set of command buttons in a dialog box.It waits for the user to click a button, and returns an Integer value.