Learn Five Useful Excel Techniques

Name: Learn Five Useful Excel Techniques
Rating: 4.2 (251 reviews)

Excel Techniques

Last updated 5/2020

English

What you'll learn

Student will get understanding of five very useful techniques in excel and their practical applications from real life examples. These techniques are: 1. Sorting 2. Filtering 3. Absolute referencing and by cell name 4. Data Visualization using various Excel charts 5. Data analysis using Pivot Table After going through this course, the student will get broader understanding of these techniques to boost up their excel task productivity.

6 sections • 8 lectures • 1h 13m total length

Introduction2:48
Explore five useful Excel techniques, including sorting, filtering, absolute and relative referencing, data visualizations with charts, and powerful data analysis with tables.

Absolute referencing11:17
Learn how absolute referencing in Excel keeps the principal value constant while dragging formulas across rows and columns, using dollar signs to fix rows or columns.
Referencing and by cell name10:22
Use named ranges to reference constants like brokerage rate across multiple worksheets, separating data from constants and updating all calculations automatically when rates change.

Creating charts - Part 18:10
Create a column chart in Excel from a two-year, four-month data set, then title the chart, label the months on the x-axis, and adjust the legend and data labels.
Creating charts - Part 214:31
Create and compare multi-level data visualizations using stack charts, line charts, pie charts, and scatter charts to analyze department skill distributions, trends, and correlations.

Student will get understanding of five very useful techniques in excel and their practical applications from real life examples.

These techniques are:

1. Sorting

2. Filtering

3. Absolute referencing and by cell name

4. Data Visualization using various Excel charts

5. Data analysis using Pivot Table

After going through this course, the student will get broader understanding of these techniques to boost up their excel task productivity.