4.6 – Using the PivotTable Toolbar, Changing Data Field – SNS Courseware

Toggle Side Panel

Sign in Sign up

Search for:

Login

Search for:

Course Content

Syllabus

0/1

Lecture Notes

0/42

1.1 – About Excel & Microsoft

1.2 – Use of Excel & Software

1.3 – Title Bar, Menu Bar, Standard Toolbar

1.4 – Formatting Toolbar & the Ribbon

1.5 – File Tab and Backstage View

1.6 – Formula Bar, Workbook Window, Status Bar

1.7 – Task Pane, Workbook & sheets

1.8 – Creating excel data

1.9 – Filtering excel data

2.1 – Selecting Columns & Rows

2.2 – Changing Column Width & Row Height

2.3 – Autofitting Columns & Rows

2.4 – Hiding_Unhiding Columns & Rows

2.5 – Inserting & Deleting Columns & Rows

2.6 – Cell Address

2.7 – Components of Cell

2.8 – Paste and Paste Special_

2.9 – Range and its operations

3.1 – Using Formulas, Formula Functions – Sum, Average, if, Count, max, min

3.2 – Using Formulas, Formula Functions – Proper, Upper, Lower, Using AutoSum

3.3 – Advance Formulas – Concatenate, Vlookup, Hlookup

3.4 – Advance Formulas – Match, Countif, Text, Trim

3.5 – Spreadsheet Charts: Creating Charts

3.6 – Different types of chart, Formatting Chart Objects

3.7 – Changing the Chart Type

3.8 – Showing and Hiding the Legend

4.1 – Data Analysis: Sorting, Filter, Text to Column, Data Validation

4.2 – Making Macros: Recording Macros

4.3 – Running Macros, Deleting Macros

4.4 – Mathematical functions

4.5 – Summarizing data – pivot table: Creating PivotTables, Manipulating a PivotTable

4.6 – Using the PivotTable Toolbar, Changing Data Field

4.7 – Properties, Displaying a PivotChart, Setting PivotTable Options

4.8 – Adding Subtotals to PivotTables – formula auditing – what-if analysis

5.1 – Introduction to Statistics (Descriptive and Inferential)

5.2 – Descriptive Statistics: Tabular & Graphical Presentation

5.3 – Descriptive Statistics: Numerical Measures (Averages and Variances)

5.4 – Introduction to Probability: Discrete Probability Distributions

5.5 – Continuous Probability Distributions

5.6 – Sampling, Interval Estimation

5.7 – Hypothesis Testing

Puzzles

0/5

UNIT I – Introduction to Excel

UNIT II – Excel Tables

UNIT III – Formula and Charts

UNIT IV – Data Handling & Analysis

UNIT V – Statistical Analysis with Excel

Resource Links

0/2

Reference Websites

Tutorial Websites

Assignments

0/2

YouTube Videos

0/7

Reference videos : Excel for Beginners – The Complete Course

Reference videos : Pivot Table Example 1

Reference videos : Pivot Table Example 2

Reference videos : Pivot Table Example 3

Tutorial Videos : About Excel & Microsoft – 1

Tutorial Videos : About Excel & Microsoft – 2

Tutorial Videos : About Excel & Microsoft – 3

Question Bank

0/5

Unit 1 – Introduction to Excel

Unit 2 – Excel Tables

Unit 3 – Formula And Chart

Unit 4 – Data Handling & Analysis

Unit 5 – Statistical Analysis with Excel

23MEE309 – Excel for Business – Essentials

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

WhatsApp us