Armando B. Mendes » Blog Archive » Top Excel Tips For Data Analysts

Top Excel Tips For Data Analysts

Posted by Armando Brito Mendes | Filed under Bases de Dados, SAD - DSS

clicar na imagem apra seguir o link

Excelentes concelhos para utilização das últimas ferramentas implementadas no Excel.

TIPS FOR DATA CLEANING

1) Change format of numbers from text to numeric

2) Unpivot columns in a data set (Multiple consolidation ranges and Power Query)

3) Merge data from several csv files into a single folder (RDBMerge Add-in and Power Query)

4) Fill empty spaces from content above (Ctrl + Enter trick and Power Query)

DATA ANALYSIS

5) Create auto expandable ranges with Excel Tables (Source for pivots, dropdown lists and formulas)

6) How to do two way lookup with INDEX and MATCH

7) Creating OR criteria within SUMIF/COUNTIF (Combination of SUMPRODUCT and SUMIF/COUNTIF)

8) Counting unique items within PivotTables (Using the Excel Data Model)

DATA VISUALIZATION

9) Quickly visualize trends with Sparklines

10) Create dynamic titles in charts (Use of cell references within chart objects)

11) Dealing with empty cells in charts and sparklines [use NA()]

12) Save time with Quick Analysis

Tags: Excel, programação em folha de cálculo

Permalink | March 2nd, 2017

Comments are closed.

Recent Posts

Recent Comments

None found

About

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. Suspendisse bibendum. Cras id urna. Morbi tincidunt, orci ac convallis aliquam, lectus turpis varius lorem, eu posuere nunc justo tempus leo. Donec mattis, purus nec placerat bibendum, dui pede condimentum odio, ac blandit ante orci ut diam.

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. Suspendisse bibendum. Cras id urna. Learn more...

© Copyright 2025 Armando B. Mendes
Design by: styleshout | Colourise by: Theme Lab and Best Linux Web Hosting

Powered by WordPress | Valid CSS | XHTML