November 2017 - Tactical Process Automation

Home
About

Tactical Process Automation

Home
About
Videos
Downloads

20171129

Weighted Average

Calculate Weighted Average in Excel

Ajay 11:23

Calculating Average is part of analysis, to analyze the average performance of the range of data set. Today we will try to focus method ...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: analytics, Complex formulas, Data Analysis, Excel Advance Functions, Weighted Average

20171125

Rules in Conditional Formatting

Data Analysis in Excel - Conditional Formatting

Ajay 20:59

Data analysis is one of the most crucial process to run business smoothly, every business units has to analyze their business. Anal...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Color Coding in excel, Excel 2013, Excel Advance Functions, Excel Dashboard, Rules in Conditional Formatting

20171123

Rules in Conditional Formatting

Formula in Conditional Formatting in Excel

Ajay 03:30

Mostly it become necessary to analyze the data in different ways like what is the current situation to previous quarter and from this poin...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Excel 2013, Excel Advance Functions, How to use conditional formatting in excel, Rules in Conditional Formatting

20171122

How to use conditional formatting in excel

How to create own rule in Conditional Formatting in Excel

Ajay 01:15

Any idea, yes we can also create our own rule to visualize the data in Excel. In last article Conditional formatting in Exce...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: 2016, Advance Excel, Conditional Formatting, Excel 2013, How to use conditional formatting in excel

20171120

How to use conditional formatting in excel

Conditional Formatting in Excel

Ajay 02:51

Conditional formatting in Excel is a powerful feature to visualize data or output in dashboard. There are multiple method or pr...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Conditional Formatting, Excel Advance Functions, Excel Dashboard, How to use conditional formatting in excel

Newer Posts Older Posts Home

Search This Blog

Reverse String using Excel VBA

Normally this is an interview question being asked by company technical recruiters. This is an logical question and every aspirants must b...

Contact

Name

Email *

Message *

Total Pageviews

Powered By Blogger

March (1)
August (1)
July (1)
April (3)
March (4)
February (2)
January (3)
December (6)
November (18)

Labels

VBA Excel Advance Functions Advance Excel Macro Excel Dashboard Excel Nested function Excel automation Excel Excel 2013 Logical Function MS Excel excel formulas Conditional Formatting Excel Range Excel functions Collection in Excel Color Coding in excel Data Analysis Data handling Date & time functions Dynamic Name Range INDEX Statistical functions for-Next loop tactical automation Create Name Range Data Validation Error Handling LOOPs Split String in Excel User Defined Functions User defined Data Type

Recent

Popular

Caculate GPA-CGPA in Excel

GPA and CGPA concept is used to evaluate the performance of students in many institution across globe. Every country has is own methodolog...
Create Named Range in Excel

Create Dynamic named ranges in Excel and use them in formulas, data validations dynamically. There are multiples ways to create the name...
Calculate Percentile in Excel

Percentile in Statistics is method of evaluation individuals performance in a group or set of people. Percentile is not the ranking positi...
Low Cost Automation

Tactical Automation is low cost approach for business units that helps to ease manual efforts by automating the process steps with the hel...
Business Process Automation

Business Process Automation (BPA) is the strategic process to automate the manual efforts used to run the business. Process Automation is ...

Comments

Blog Archive

Designed with by Way2Themes | Distributed By Best Blogger Themes