Posts

Showing posts from 2020

How to change data source range of Pivot Table | Update Data Source Range of an Existing Pivot Table

Image
via https://youtu.be/UZCLvM3lSSk

How To Get Distinct Count In Excel Pivot | Get Distinct Count of Excel Column Values Using Pivot

Image
via https://youtu.be/_5UQ3CHVcHE

Creating a Doughnut Chart in Google Data Studio | Working with Doughnut Chart in Google Data Studio

Image
via https://youtu.be/_8Z8GI0obi8

How to filter records in SQL using AND operator | SQL AND Operator | AND to filter records in SQL

Image
via https://youtu.be/EfpCUHspLn0

How to filter records in SQL using IN operator | SQL IN Operator | Use IN to filter records in SQL

Image
via https://youtu.be/4n6zeeHvsyQ

Search A pattern in Column | Fetch records that has a pattern in SQL | Pattern Matching in SQL

Image
via https://youtu.be/RxFDUiJpNOY

SQL DISTINCT Statement | How to get unique values from a column in SQL | Get Distinct values in SQL

Image
via https://youtu.be/AWdty5BOjdo

SQL SELECT Statement| select data from a Table | Fetch selected columns from a SQL table

Image
via https://youtu.be/29AVv7ZN5BM

Working with bar graph in Google Data Studio | Add a Bar Graph in Google Data Studio

Image
via https://youtu.be/EHrieDtcDmc

Working with time series in Google Data Studio | Add a Time Series graph in Google Data Studio

Image
via https://youtu.be/8u_cUV7-geU

How to add scorecard in Google Data Studio | Score Card With Average in Google Data Studio

Image
via https://youtu.be/-jSQDsUNnK0

How to add Conditional Formatting in table in Google Data Studio | Table with Conditional Formatting

Image
via https://youtu.be/5zdx4RVaM8o

How to add table with heat map in Google Data Studio | Add multiple Tables in Google Data Studio

Image
via https://youtu.be/e1HrAHShfjA

Adding text and image in Google Data Studio | Insert text and image in Google Data Studio

Image
via https://youtu.be/LWaSumS1ef8

Excel Pivot Table Explained In details | How to Add Pivot table | Use Pivot table for data analysis

Image
via https://youtu.be/2SnRZoksUek

How To Freeze Panes In Excel | How to Freeze Rows in Excel | How to Freeze columns in Excel

Image
via https://youtu.be/eUcqRTE0zx4

How To Use Data Validation In Excel | Data Validation Explained in Details

Image
via https://youtu.be/cNNFIjKHB24

How To Use Flash Fill In Excel | Flash Fill Data In Excel Range | Drag cell to Fill Data in a Range

Image
via https://youtu.be/Vg7v4ArQTLw

How To Sort Data In Excel | Arrange data in Ascending or Descending Order | Excel Custom Sorting

Image
via https://youtu.be/DYDWn3fLP-o

How To Use Text To Columns In Excel | Split data in excel | Using delimiter to split data in Columns

Image
via https://youtu.be/rZQn9FtLv0s

How To Use Clear Content In Excel | Clear Data in Excel range | Delete Data In a Excel Range

Image
via https://youtu.be/5tNFmZyG2tQ

How To Use Auto Sum In Excel | Apply Auto Sum in a cell | Sum of Range in Excel | Auto sum function

Image
via https://youtu.be/ExcMtDhJraA

insert selected column from an existing table to a new SQL table|Copy data from one to another table

Image
via https://youtu.be/omCMlDuQeFI

How to Rename, Hide, Delete Pages and Create a duplicate page in Google Data Studio

Image
via https://youtu.be/We_ptguZHF0

How To Use Line Win Loss Chart In A Cell In Excel | Create Win Loss Chart In A Cell In Excel

Image
via https://youtu.be/EfzmYUmAd5s

How to Add multiple pages in Google Data Studio | Additional Pages in Google Data Studio

Image
via https://youtu.be/cEuKss-6NCg

How To Use Column Chart In A Cell In Excel

Image
via https://youtu.be/yQXzplLfoxg

How to insert data from an existing table to a new table | Insert data of a table into new table SQL

Image
via https://youtu.be/D0kW9kRLE9k

Customizing the theme and Layout in Google Data Studio

Image
via https://youtu.be/pQf1-fMn-co

SQL Comments - How To insert Comment Within SQL Code | Different ways to add comments in SQL queries

Image
via https://youtu.be/MQv8uX45jp0

How To Use Line Mini Chart In A Cell In Excel

Image
via https://youtu.be/N0EPz_D2vvY

How to insert multiple records In a SQL Table using single insert statement

Image
via https://youtu.be/UZsphJv8KAU

How to refresh data in Google Data Studio | Google Data Studio Refreshing multiple data Sources

Image
via https://youtu.be/SQgIohOWSOM

How To Insert, Delete A Row Or Column In Excel | Insert and Delete Multiple Rows or Column in Excel

Image
via https://youtu.be/HGu1hp23nkk

How to Insert Data Only for Specific Columns in a SQL Table

Image
via https://youtu.be/mnK8-gP1DSs

Connect google spreadsheet and excel files with Google Data Studio| Add Data Source in Data Studio

Image
via https://youtu.be/iIpcSHNn3Z8

How To Add Conditional Formatting In a Range in Excel | Use Conditional Formatting In a Excel Range

Image
via https://youtu.be/inh0fZojqgc

SQL Insert Statement | How To Insert Records Into A Table | Inserting data into SQL Tables

Image
via https://youtu.be/tMp4PvlOktg

How to create a new report in google data studio | Build a New Data Studio Report

Image
via https://youtu.be/L42ExxC1qP8

How To Add Borders In Excel | Use Borders In Excel | Change Borders Color in Excel

Image
via https://youtu.be/UQNqZwZLuPg

How To Create A Table in SQL | Create a new table in SQL Database

Image
via https://youtu.be/_-IBNdWXSBs

Advantage & limitations of Google Data Studio | Why Google data Studio is a better reporting tool

Image
via https://youtu.be/BosKQQ6fgM4

How To Merge & Center Cells In Excel | Merge multiple cells in Excel | Use of Merge a range in Excel

Image
via https://youtu.be/kMnFnDZIBc4

Create a Database in SQL | How To use Data base in MYSQL | Database Details & Properties

Image
via https://youtu.be/hIxzGztxkbo

How to create Google Data Studio account | How to open Google Data Studio

Image
via https://youtu.be/VELOqIzDLn8

How To Wrap Text In an Excel Cell | How to apply Wrap text in Multiple Cells in Excel

Image
via https://youtu.be/N-B3-CSXGX0

SQL Operators Explained In Details | Different Type of SQL Operators | Detailed use of SQL Operator

Image
via https://youtu.be/THU365rrBhI

Introduction to Google Data Studio | What is Google Data Studio | How to use Google Data Studio

Image
via https://youtu.be/FKsK6TPJqLc

How To Align Content In Excel | How To move text or number to left, right & center in an Excel cell

Image
via https://youtu.be/CqS6kVpsqGw

SQL Data Types Explained in Details | What is SQL Data Types | Different Type of SQL Data Types

Image
via https://youtu.be/bjFP4mSGvpU

Apply Format Painter to change format of cells in Excel | What Is Format Painter In Excel

Image
via https://youtu.be/MgMeHQrF4E8

Introduction to Workbench | How to run SQL Queries | Where to run SQL Queries

Image
via https://youtu.be/-EjbSCBsjiE

Excel Cells Fonts And Background Color | Change Fonts And Background Color In Excel Cells

Image
via https://youtu.be/DayEzvBqZPY

How To Select Data In Excel | How to Copy And Paste Data In Excel

Image
This page introduces you to some of the Basics of, how you can select a range of data in Excel.This article will surely become handy when you have to copy and  paste huge data from multiple sources into excel.

How to Insert Data or values in Excel From Text File, MS Access DB and Webpage

Image
This page introduces you to some of the Basics of, how you can import data into Excel. This article will surely become handy when you have to import huge data from multiple sources like Text, MS Access and webpages. 

Introduction To Excel Ribbon | How to Use Excel Ribbon | Excel Ribbon Tabs Detailed | Excel Ribbon Components

Image
This page introduces you to some of the Basic of Excel ribbons that will surely help you to understand about functionalities provided by excel on its ribbon. Excel Ribbon is a strip of buttons and icons. The buttons and icons in Excel Ribbon are grouped into different tabs based on the category of their functionalities. Main components of Excel Ribbon are:- Tabs: Tabs contain groups of Excel commands arranged based on the command's functionality File- The File tab in Excel Ribbon is used to open Excel Backstage View. It contains many options to work with the Excel file & customization. Home- Home Tab contains commonly used Excel commands like copy, paste, format, find, replace etc. Insert- Insert Tab contains objects you can insert to your worksheets like tables, pictures, charts, icons, shapes etc. Page Layout -Page Layout tab contains options mainly for page setup and print. Formulas-Formulas tab contains options mainly for inserting and troubleshooting Excel functions. Dat...

How to Create, Save, Copy, Hide and Unhide Excel Worksheets?

Image
This page introduces some of the Basic Excel skills that will help, you to understand how to create a new worksheets within a excel workbook, save a workbook, copy a sheet within a workbook as well as other workbook and how hide & UN-hide excel sheets.

What is MS Excel | Introduction To Excel | Excel for Data Analysis | Excel for Data Scientist

Image
    Microsoft Excel is a spreadsheet developed by Microsoft for Windows, mac-OS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. This Introduction To Excel video provides you the basis of MS excel and how to use Excel in day to day work.