PC / Excel Technique

PC / Excel Technique

Excel’s Conditional Formatting and Multiple Conditions【Excel Skill】

A situation where it's easy to find the best next actions is called 'Actionable'. You can make your data analysis action...
PC / Excel Technique

Excel Macro and VBA: Fundamental Basics (Record Macro Button and VBE)

This article is about Excel Macro fundamental basics and explains how to use the 'Record Macro' button, how to edit the ...
PC / Excel Technique

How to Use Excel Pivot Table 【Screen Demonstration】

This article explains source data formats for a Pivot Table, each section of the Pivot Table's work screen - the Field L...
03.26.2018
Data Analysis

What is Standard Deviation? There are too many Excel functions for Standard Deviation!

This article explains 'What Standard Deviation is', 'Why it's needed', and differences between 'Population' and 'Sample'...
02.26.2018
PC / Excel Technique

Excel: How to Sum Data by Week, Month and Year【Data Analysis Excel Skill】

Excel Date Aggregation: We need to sum data by week, month or year frequently. The easiest way is to use a work column a...
03.14.2018
PC / Excel Technique

Excel Absolute and Relative Cell References and Autofill Function【Data Analysis Excel Skill】

You can learn the differences in Absolute and Relative Cell References with case study examples. Mastering Cell Referenc...
03.05.2018
PC / Excel Technique

TEXT Function, which makes dates and numbers easily read and understood【Excel Skills】

Today's topic is 'The TEXT Function'. This TEXT function's role is to make dates and numbers easily read and understood ...
03.05.2018
Sponsored Links
View My Stats