Skip to main content

Excel Tips and Tricks





































Top 8 Excel Data Analysis Functions

Data analysis is a process of cleaning, transforming, and modeling data to discover meaningful information for better decision making. Microsoft Excel is one of the top tools for Data Analysis. Excel has some powerful functions and formulas that improve your ability to analyze data.

So without wasting more time, let’s look at some Excel functions which are widely used for Data Analysis.


Sort & Filter

There may be cases where you want to work with a certain group of data while working on a large dataset. Sort function will come handy then.

Shortcut keys - ALT + H + S


Filtering 

You can easily narrow down your data into subgroups with ease using this function.

Shortcut keys - ALT + H + S + F


Conditional Formatting

This function is important and used to separate important data from the remaining data. You can get the desired data based on the entered logic or condition.

Shortcut keys - ALT + H + L


Pivot Tables

Pivot Tables are the most important function used by data analysts. It helps you to sort, group, summarize and analyze data with ease.

Shortcut keys - ALT + N + V + C


CONCATENATE

CONCATENATE is another important function as it helps you combine text, numbers, and dates from different cells into one.

Formula = CONCATENATE (cells you want to combine)


VLOOKUP

VLOOKUP is one of the most useful data analysis functions. It is used to find things in a table or a range by row.

Formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])


What’s Next!

If you are looking to learn different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends, then check out this book “Data Analysis with Excel.”

What will you learn?

  • Performing functions with shortcut keys.
  • Formulas and functions
  • Data visualization with new chart types
  • Gantt and Milestone Chart
  • Smart Art and Organization Chart
  • Putting data in perspective with Pivots
  • Complex data analysis using ToolPak
  • Forecasting in Excel
  • Mail Merge using Excel
  • Macros in Excel
  • What is in Excel 2019

By the end, you will get familiar with Excel Formulas for Data Analysis. You will also understand what Excel skills a data analyst needs to know. To sum things up, you will be able to leverage the power of Excel for data analysis.

 

Labels:

Comments

Post a Comment

Popular posts from this blog

Learn Ms SQL 2005

Page 1 Delete all the rows from all the tables in SQL Server If you are in situation where you just want empty database structure, without having data in it. Run following select statement which will generate set of delete statement to delete all the records for all the tables in your database. SELECT 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';'  FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' ORDER by TABLE_NAME In case your database is large and you want to know status of which table is currently getting deleted you can use following: SELECT 'Print(''Delete started for ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ''');' + 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';' + 'Print(''Delete done for ' + Table_Catalog + '.' + Table...
Post a Comment
Read more

A R Janitorial Services

WelCome To  A R Janitorial Services C arpet cleaning, for beautification, and the removal of stains, dirt, grit, sand, and allergens can be achieved by several methods, both traditional and modern. Clean carpets are recognized by manufacturers as being more visually pleasing, potentially longer-lasting, and probably healthier than poorly maintained carpets. Our carpet cleaning Expertise first vacuum with Heavy Duty Industrial Vacuum Cleaner, spotting is done manually and then shampooing is done with the help of Shampoo Machine and We fulfill the need of cleanliness of your carpet with the best carpet cleaning professionals in the business indeed. No need to worry for all those annoying dirt and dusk under your feet. Extraction is by far the most important step in this process. Since the hot-water extraction method uses much more water than other methods like bonnet or shampoo cleaning, proper extraction and air flow are critical to avoid drying issues. Drying time...
6 comments
Read more

Games and Cricket Patches

HD Cricket 2016 Download Links.. Dowmload Patch In 3 Parts Patch Size:674 MB PART 1 PART 2   PART 3 ROSTER                                                                                                                                 FIXES GRAPHICS You need to have installed  ZAX WILLOWS 256 BATPACK  &  NEW BAT MODEL  in your Cricket 2007 in order to avoid  Async load of .fsh errors , THANK YOU. Credits:  ZaxWorks for Cricket 07 BBL T20 Rampage (Feat. IPL) DOWNLOAD HERE International Cricket 2012 Patch  DOWNLOAD HERE DLF IPL-4 : The Cricket Fever...
Post a Comment
Read more