Skip to content

Become a Data Expert

Menu
  • Brand Analysis
  • Reports
    • Datastudio
    • MIS
    • Excel
  • Tools
  • About
    • Contact
    • Privacy Policy

Category: Excel

Posted onDecember 10, 2019January 21, 2020Excel

How to find unique value in Google Spreadsheets?

by sameer

There is a better option to find out unique values in specific data. Google spreadsheet gives the option for this. Unique formula its very easy…

Read More
Posted onJune 16, 2018September 30, 2019Excel

Make summarizing and reporting easy with Excel PivotTables

by sameer5 Comments on Make summarizing and reporting easy with Excel PivotTables

Excel’s PivotTable feature lets you organize and summarize data into a meaningful report format without changing the data set. Beyond reporting, PivotTables offer a quick…

Read More
Posted onMarch 19, 2018May 5, 2018Excel

Excel SUMIFS Function with Example

by sameer

Summary SUMIFS is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when adjacent cells meet criteria based on…

Read More
Posted onMarch 15, 2018March 15, 2018Excel

Excel SUMIF Function with Example

by sameer

Summary SUMIF is a function to sum cells that meet a single criteria. SUMIF can be used to sum cells based on dates, numbers, and…

Read More
Posted onMarch 13, 2018March 19, 2018Excel

Excel Sum Function Examples

by sameer

Summary The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include…

Read More
Posted onFebruary 23, 2018January 24, 2019Excel

Excel VLOOKUP Function

by sameer

Summary VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards…

Read More

Search

Recent Updates

  • Cohort Analysis
  • Simple Python Code to start the Web Scrapping
  • Coronavirus – COVID 19 Chart of India
  • How to find unique value in Google Spreadsheets?
  • WebScraper.io The best Chrome Extension for Crawling

Tags

amazon brand analysis Correlation data studio data visualization emotion analysis google analytics google tools graphs keyword analysis machine learning mis mis report R code report reviews sagemailer sentiment analysis statistics sumifs text cleaning text frequency webmaster
© Opencase.in
Amphibious Theme by TemplatePocket ⋅ Powered by WordPress