Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Microsoft Excel 2013 Data Analysis Course Overview, Study notes of MS Microsoft Excel skills

Avondale University (AU)MS Microsoft Excel skills

A 7-hour course overview of data analysis using microsoft excel 2013. Topics covered include using autofilter to filter data, inserting subtotals, database functions, lookup and reference functions, statistical functions, logical functions, and using pivottables and pivotcharts to analyze and present data. Students will learn how to filter data using autofilter, insert subtotals, use functions such as sumif, dsum, vlookup, and median, and create pivottables and pivotcharts.

Typology: Study notes

2021/2022

Uploaded on 07/05/2022

lee_95
lee_95 🇦🇺

4.6

(59)

999 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Data Analysis with Microsoft Excel 2013 Course Overview
Microsoft Gold Certified Partner Microsoft Certified Partner for Learning Solutions Adobe Authorized Training Center Corel Authorized Training Partner
Autodesk Authorized Training Center & Certification Center Microsoft Office Specialist Authorized Exam Distributor Prometric Testing Center VUE Testing Center
Data Analysis with
Microsoft Excel 2013
Course Duration:
7 Hours / 1 Day
1 Use AutoFilter to filter your
data
Filter a range of data
Remove a filter
Filtering data by icon set
2 Inserting subtotals in a list of
data in a worksheet
Inserting subtotals
Removing subtotals
SUMIF
3 Database Functions
DSUM
DAVERAGE
DCOUNT & DCOUNTA
DMAX & DMIN
4 Lookup and Reference
Functions
Using VLOOKUP to Find Data
Limit the VLOOKUP Value for
Exact Match
Using the Closest Match for
the VLOOKUP Value
HLOOKUP
INDEX
Match
Lookup function
5 Statistical Functions
MEDIAN
MODE
LARGE
SMALL
RANK
6 Logical function
7 Using PivotTables /
PivotChart to analyze &
present your data
Creating a PivotTable or
PivotChart
Changing the format of your
PivotTable report
Showing PivotTable details
Calculating PivotTable values
Changing or updating
PivotTable data
8 Applying Conditional
Formatting
Adding, changing, conditional
formats
Clearing conditional formats
Apply conditional formatting
to quickly analyse data
pf2

Partial preview of the text

Download Microsoft Excel 2013 Data Analysis Course Overview and more Study notes MS Microsoft Excel skills in PDF only on Docsity!

Data Analysis with Microsoft Excel 2013 Course Overview Microsoft Gold Certified Partner^ ^ Microsoft Certified Partner for Learning Solutions

^ Adobe Authorized Training Center^ ^ Corel Authorized Training Partner Autodesk Authorized Training Center & Certification Center^ ^ Microsoft Office Specialist Authorized Exam Distributor

^ Prometric Testing Center^ ^ VUE Testing Center

6 Logical function 7 Using PivotTables / Data Analysis withPivotChart to analyze &Microsoft Excel 2013present your data^ ^ Creating a PivotTable or Course Duration: PivotChart^ ^ Changing the format of your 7 Hours / 1 DayPivotTable report^ ^ Showing PivotTable details 1 Use AutoFilter to filter your^ ^ Calculating PivotTable values data^ ^ Changing or updating  Filter a range of dataPivotTable data  Remove a filter 8 Applying Conditional  Filtering data by icon set Formatting 2 Inserting subtotals in a list of^ ^ Adding, changing, conditional data in a worksheet formats  Inserting subtotals^ ^ Clearing conditional formats  Removing subtotals^ ^ Apply conditional formatting  SUMIFto quickly analyse data 3 Database Functions  DSUM  DAVERAGE  DCOUNT & DCOUNTA  DMAX & DMIN 4 Lookup and ReferenceFunctions  Using VLOOKUP to Find Data  Limit the VLOOKUP Value forExact Match  Using the Closest Match forthe VLOOKUP Value  HLOOKUP  INDEX  Match  Lookup function 5 Statistical Functions  MEDIAN  MODE  LARGE  SMALL  RANK

Data Analysis with Microsoft Excel 2013 Course Overview Microsoft Gold Certified Partner^ ^ Microsoft Certified Partner for Learning Solutions

^ Adobe Authorized Training Center^ ^ Corel Authorized Training Partner Autodesk Authorized Training Center & Certification Center^ ^ Microsoft Office Specialist Authorized Exam Distributor

^ Prometric Testing Center^ ^ VUE Testing Center

^ COUNTIFS ^ AVERAGEIF Data Analysis with ^ AVERAGEIFS Microsoft Excel 2013 6 邏輯函數 7 使用樞紐分析表或樞紐分析圖 上課時數 : 7 小時 / 1 日 1 使用自動篩選來篩選資料  篩選資料的範圍  移除篩選  依圖示集篩選資料 2 在工作表的資料清單中插入小計  插入小計  移除小計  SUMIF 3 資料庫函數  DSUM  DAVERAGE  DCOUNT & DCOUNTA  DMAX & DMIN 4 尋找與參照函數  VLOOKUP  使用 VLOOKUP 搜尋完全相乎的資料  Using the Closest Match forthe VLOOKUP Value  HLOOKUP  INDEX  Match  查閱與參照函數 5 統計函數  MEDIAN  MODE  LARGE  SMALL  RANK  COUNTIF