Skip to content
Play overlay
Preview this course

Microsoft Excel – Part 2

Learn to leverage the power of data analysis and presentation in order to make intelligent organizational decisions.

Sonic Performance Support

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
4.5 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free

Add to basket or enquire

Overview

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Curriculum

5
sections
72
lectures
4h 31m
total

    • 1: Before the Training starts 01:00 PDF
    • 2: A Round of Introductions 01:00 PDF
    • 3: Work with Functions Preview 01:04
    • 4: Handout: Table of Content (PDF) Preview 16:00 PDF
    • 5: Handout: Keyboard Shortcuts (PDF) 01:00 PDF
    • 6: Work with Ranges 00:57
    • 7: Name and Edit Ranges 05:34
    • 8: Use Defined Names in a Formula 03:13
    • 9: Locate and Use Specialized Functions 05:06
    • 10: Work with Logical Functions 02:14
    • 11: IF Function 04:29
    • 12: AND, OR and NOT Function 05:40
    • 13: Combine Functions 06:19
    • 14: The IFS function 05:00
    • 15: The Functions MinIFS and MaxIFS 05:06
    • 16: Functions Similar to the IF Function 05:15
    • 17: Work with Date and Time Functions 01:24
    • 18: TODAY, NOW and DATE Functions 02:54
    • 19: NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 05:28
    • 20: Work with Text Functions 00:48
    • 21: LEFT, RIGHT and MID Functions 02:40
    • 22: FIND Function 03:19
    • 23: Text to Columns Feature 03:39
    • 24: CONCATENATE Function 02:59
    • 25: TEXTJOIN 04:40
    • 26: UPPER, LOWER and PROPER Functions 02:38
    • 27: Quiz – Working with Functions 03:00
    • 28: Dynamic Arrays in Excel 365 03:24
    • 29: XLOOKUP 08:33
    • 30: FILTER and UNIQUE 18:59
    • 31: SORT and SORTBY 11:35
    • 32: SEQUENCE and RANDARRAY 12:59

    • 33: Sort Data – Introduction 00:30
    • 34: Sort Data 03:01
    • 35: Filter Data – Introduction 00:36
    • 36: Filter Data 02:29
    • 37: Query Data with Database Functions 00:42
    • 38: Database Functions 03:12
    • 39: Outline and Subtotal Data 00:36
    • 40: Use Subtotals to Summarize Data 03:28
    • 41: Quiz – Working with Lists 03:00

    • 42: Create and Modify Tables – Introduction 00:44
    • 43: Create and Modify Tables 06:50
    • 44: Use Summary Functions in Tables 03:21
    • 45: Apply Intermediate Conditional Formatting – Introduction 00:41
    • 46: Apply Intermediate Conditional Formatting 02:45
    • 47: Apply Advanced Conditional Formatting 00:35
    • 48: Use Logical Functions to Apply Conditional Formatting 03:32
    • 49: Get New Perspectives on Data with “Excel Ideas” 03:41
    • 50: New Excel Data Type: Stocks 05:36
    • 51: New Excel Data Type: Geography 07:41
    • 52: Quiz – Analyzing Data 05:00

    • 53: Create Charts – Introduction 00:38
    • 54: Create Charts 04:29
    • 55: Modify and Format Charts – Introduction 01:09
    • 56: Modify and Format Charts 05:15
    • 57: Use Advanced Chart Features 00:30
    • 58: Create a Dual-Axis Chart 04:28
    • 59: Funnel Charts 05:52
    • 60: Create a Chart Template 03:02
    • 61: Visualizing Data with Charts – Best Practice 03:52
    • 62: Quiz – Visualizing Data with Charts 01:00

    • 63: Create a PivotTable – Introduction 00:17
    • 64: Create a PivotTable 04:04
    • 65: Analyze PivotTable Data – Introduction 00:38
    • 66: Analyze PivotTable Data 04:29
    • 67: Present Data with PivotCharts – Introduction 00:50
    • 68: Present Data with PivotCharts 05:01
    • 69: Filter Data by Using Timelines and Slicers – Introduction 00:54
    • 70: Filter Data by Using Timelines and Slicers 04:19
    • 71: Quiz – Using PivotTables and PivotCharts 02:00
    • 72: Course Follow-Up 01:35

Course media

Description

The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you.

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.


You will:

  • Work with functions
  • Work with lists
  • Analyze data
  • Visualize data with charts
  • Use PivotTables and PivotCharts

Who is this course for?

This course is suitable for you, if

  • you already have a foundational knowledge in Excel
  • you wish to take advantage of some of the higher-level functionality in Excel to analyze and present data

Requirements

  • The knowledge taught in the course Microsoft 365 – Learn, Understand and Use Basic Functions and Concepts or comparable practical experience is helpful to follow the content shown in this training more easily.
  • This course builds upon the foundational knowledge presented in the Microsoft Excel – Part 1 course.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Microsoft courses, Online courses