Objects in Excel VBA – Workbook, Sheets, Range and Cell
PNRao2022-06-17T03:55:55+05:30Objects in Excel VBA. Tutorials to learn how to deal with different objects in Excel VBA - Workbook, Sheets, Range and Cell with Example codes to acsess it.
Tools For Data Analysis
PNRao2022-06-17T03:56:10+05:30Different tools available in the market for data analysis, this tutorial we will help you to decide which tool you should learn and suitable for your tasks. Tools for Data Analysis will help you to perform analytics. Our easy to follow step by step learning path will help you in mastering Data Analysis.
In this topic:
- Different Kinds of the Tools based on the type of request
- What should I learn? Understanding the Market.
- Where to begin? Learning Paths:
Tables in Excel VBA – Explained with Examples!
PNRao2022-06-17T03:53:40+05:30Managing the data with Tables is very easy in Excel VBA - Examples to show you Creating,Sorting, Filtering Tables and Clearing or Toggling Table Filters.
Sorting and Grouping the Data in SQL – ORDER BY GROUP BY
PNRao2013-07-01T00:00:00+05:30When we are dealing with huge data, we can not analyse the data by looking into each record. We sort and group the data based on certain variables and understand the data. We use Order By, Group by,Where and Having Clauses to Sort and group the data in SQL.
Names in Excel VBA – Explained with Examples!
PNRao2022-06-17T03:53:37+05:30Defining Names in Excel makes our job more easier - VBA Examples to show you Adding Names ,Deleting Names and Hiding and UnHiding Names in Excel VBA.
UPPER Function in Excel
PNRao2022-06-17T03:55:02+05:30UPPER Function in Excel - formula converts all lowercase letters in a text string or cell reference to uppercase. Learn more Formulas, Excel and VBA .
Data Analysis – An Introduction
PNRao2022-06-17T03:56:08+05:30Data Analysis is important to every organization to survive in this competitive world. In recent years every one wants make use of data available to understand their business to take effective decisions. I spent around 10 years in analyzing the data. And played different roles to help my clients to take effective decisions. In this topic I am going to discuss the basics of data analysis to give an overall idea about Data Analysis.
In this topic:
- What is Data Analysis?
- Why do we need Data Analysis?
- Approach to do Data Analysis
- Different kinds of Data Analysis - By Request
- Different kinds of Data Analysis - By Domain
- Useful Links for Data Analysis
- What is Data Analysis?
- Why do we need Data Analysis?
- Approach to do Data Analysis
- Different kinds of Data Analysis - By Request
- Different kinds of Data Analysis - By Domain
- Useful Links for Data Analysis
Excel VBA Object Model
PNRao2022-06-17T03:55:55+05:30Tutorials for understanding Excel VBA Object Model. Understanding the VBA Object Model is important to deal with different Excel Objects. Learn more here...
LOWER Function in Excel
PNRao2022-06-17T03:54:55+05:30LOWER Function in Excel - formula converts all uppercase letters in a text string or cell reference to lowercase. Learn Formulas, Excel and VBA examples
SQL Functions for Data Analysis
PNRao2013-06-15T00:00:00+05:30SQL functions help to aggregate the data while extracting the data from Data base. There are many functions available in SQL to aggregate the data to analyse it.
FIND Function in Excel
PNRao2022-06-17T03:54:54+05:30FIND Function in Excel - formula returns the location or position of a sub-string in a text string. Learn Formulas, Excel and VBA in our free tutorials.
Folders and File Handling in Excel VBA
PNRao2023-03-18T14:16:34+05:30Folder and File Handling in Excel VBA Examples help you to create, delete,copy,move files and folder. And customize File or Folder dialog Box using VBA.