Language

Excel

扩展数据透视表和对数据进行归一化

在数据透视表的最后一节课中,我们通过发现同一个字段如何显示不同的结果、添加运行总数、添加 “与” 字段的差异、添加分组以及使用 “标准化” 来消除重复项来结束有关该主题的培训。中级水平。

Events

Date
Jun 11, 2024
Time
3:30 PM
Please use your learning platform to book onto this event.

Related SEEDL Summaries

Office 365 for Dummies

Office 365 for Dummies

"Office 365 For Dummies" is a comprehensive guide to the cloud-based productivity and collaboration suite from Microsoft. The book is written by Rosemarie Withee, Ken Withee, and Jennifer Reed and is designed to help users get up and running with Office 365 quickly and easily. 

View Office 365 for Dummies
Excel Pivot Tables Recipe Book: A Problem-Solution Approach

Excel Pivot Tables Recipe Book: A Problem-Solution Approach

"Excel Pivot Tables Recipe Book: A Problem-Solution Approach" by Debra Dalgleish is a comprehensive guide designed to help users master the powerful features of Excel pivot tables through practical, real-world scenarios. The book is structured as a collection of "recipes," each addressing a specific problem or task that users might encounter when working with pivot tables. This approach makes it easy for readers to find and apply solutions to their own pivot table challenges.

View Excel Pivot Tables Recipe Book: A Problem-Solution Approach
Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets

Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets

Paul McFedries' "Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets" is a practical and visually oriented guide designed to help users harness the powerful features of Excel pivot tables and pivot charts. This book is part of the "Your visual blueprint" series, known for its step-by-step visual format that makes complex concepts accessible and easy to understand.

View Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets

Related Courses

Office 365 Excel - Course
3 Events

Charts Part 2

This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second axis, Adding Trendlines, Forecasting...

On Demand:
60 minutes
Next Event:
Date
Jun 18, 2024
Time
12:30 PM
Office 365 Excel - Course
2 Events

Formulas Refresher

This one-hour session is an essential for any Excel user that has never had formal training or is a bit rusty! In it we cover some...

On Demand:
60 minutes
Next Event:
Date
Aug 5, 2024
Time
11:00 AM
Office 365 Excel - Course
2 Events

Extending and Customising a Pivot Table

In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...

On Demand:
60 minutes
Next Event:
Date
Sep 9, 2024
Time
9:30 AM
Office 365 Excel - Course
2 Events

Hints and Tips Part 1

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some popular hints...

On Demand:
60 minutes
Next Event:
Date
Jun 10, 2024
Time
11:00 AM
Office 365 Excel - Course
2 Events

Pivot Tables From Scratch

Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour session we explode some of...

On Demand:
60 minutes
Next Event:
Date
Jul 15, 2024
Time
11:00 AM
Office 365 Excel - Course
2 Events

Logical Functions

Logical functions in Excel allow you to have the program make decisions based on criteria you specify. A simple example could be to...

On Demand:
60 minutes
Next Event:
Date
Jun 17, 2024
Time
9:30 AM
Office 365 Excel - Course
2 Events

Data Tables (Sensitivity Analysis)

Sensitivity analysis is a process by which different results can be predicted according to a number of variables. This is an important...

On Demand:
60 minutes
Next Event:
Date
Jun 17, 2024
Time
11:00 AM
Office 365 Excel - Course
2 Events

Hints and Tips Part 6

Excel added a new feature a few years ago that makes it super easy to fill lists of things in a different way once it recognises a...

On Demand:
60 minutes
Next Event:
Date
Jul 23, 2024
Time
2:00 PM

FAQ's

You can view the system in your local time by going to My Account > Edit Profile (Or click the timezone in the top bar > edit profile), once here you'll see a dropdown called timezone. If you change this to your timezone the platform will reflect this.
If you go to the My Account area, you will see all the learning events you've attended. You can download the related handouts for as long as you maintain your subscription. You can watch recordings of all events for up to 30 days after the event.
If you go to the My Account area, you will see all the learning events you've attended. You can access the recording of any session you attended for 30 days afterwards.
They will be emailed to you automatically and are accessible via the certificates tab on the My Account page.
Any courses or modules which are CPD accredited are clearly indicated
There may be an issue with your choice of speaker, please check your settings in Zoom.
Yes - our courses are designed to be accessed using any mobile device
On your Login page, hit the Forgotten Password button. Follow the instructions on the next Reset Password screen and you're done!
Product
Premium
Duration
60 minutes
Facilitator
David Millard
Recommendation
100%
of Users who said they'd recommend this course.
On Demand
You must be logged in to access this.
Register Today
in order to access events you must sign up for a SEEDL Account
Register Now