Analytics Tuts

Analytics Tuts

Analytics and Data Visualization Tutorials

  • Linkedin
  • Twitter
  • Pinterest
  • Facebook
  • Instagram
  • Home
  • R
    • R
    • RShiny
    • RStudio
  • Tableau
  • Excel
  • SQL
  • Alteryx
  • 30 Days Learning Track
    • Alteryx
    • Powerpoint Animation
  • More
    • Microsoft Power BI
    • Downloads
    • Online Courses (MOOCS)
    • Jobs
  • About
  • Advertise

Tag: Excel Functions

Learn MS Excel from Excel guide

February 28, 2017 Niket Kedia Leave a comment

Hello friends! Recently I came accross with an MS Excel guide which contains almost all the MS Excel functions. I am not sure about the author/source but it’s an excellent guide to self Excel learning.
Read more

  • Excel

VLOOKUP and HLOOKUP functions in Excel

July 16, 2016 Niket Kedia Leave a comment

Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more

  • Excel

IF, COUNTIF, SUMIF Functions in Excel

December 12, 2015 Niket Kedia Leave a comment

Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.

Read more

  • Excel

Some Useful Functions in Excel

December 12, 2015 Niket Kedia Leave a comment

In this tutorial we’ll learn the use of different useful functions in Excel.

Read more

  • Excel

Recent posts

  • Updating R to latest version in R studio on Windows
  • SQL Christmas Tree using SQL server Spatial data
  • Using the Values() clause in T-SQL to get max() and sum() of values
  • Quick and Easy Analytics revision

Categories

Tags

Analytics Analytics Tips Analytics Tricks Analytics Tutorials big data Business Analytics Business intelligence (BI) business intelligence software Dashboard dashboard reporting software data analysis Data Analytics databas Database data manipulation Data Science data science in R Data Visualization Data Viz dataviz Downloads Excel excel analytics dashboard Excel Functions Excel Tips Excel Tricks heatmap How To Learn MS Excel Learn Tableau Learn VBA Machine Learning Predictive Analytics Query R RStudio Spreadsheet SQL SQL Scripts Tableau Tableau Dashboard Tableau Functions Tableau Public Tableau Server Tutorial
Copyright © 2015-2018 | Analytics Tuts Theme: Dynamic News