Lightnews — Scholar-powered news

Mastering Microsoft Excel pivot tables

Excel Cookbook @theexcelcookbook.bsky.social · 3d

Thank you to everyone who joined me for yesterday's Mastering PivotTables class. For those who missed it, I will be rerunning the course on December 10th.

Excel Cookbook @theexcelcookbook.bsky.social · 11d

The class covers PivotTables in-depth and includes different aggregations, grouping, filtering, and calculations. The Power Pivot section shows how to base a PivotTable on multiple related tables and includes measures, KPIs, using date tables to group by financial year and quarter, and named sets.

1

Excel Cookbook @theexcelcookbook.bsky.social · 11d

Do you want to learn more about using Excel PivotTables or Power Pivot? If so, join me for my Mastering Excel PivotTables course on October 8 on the #OReilly learning platform: learning.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

Go beyond the basics to gain proficiency of this important skill

learning.oreilly.com

Excel Cookbook @theexcelcookbook.bsky.social · 18d

Thank you to everyone who joined me for today's class.

Excel Cookbook @theexcelcookbook.bsky.social · 24d

This course teaches statistical concepts and techniques from the ground up and covers Excel's statistical functions and the Analysis ToolPak. Hope to see you there!

Introduction to Statistics and Data Analysis with Microsoft Excel

Excel Cookbook @theexcelcookbook.bsky.social · 24d

I'm giving my Introduction to Statistics and Data Analysis with MS Excel course for #OReilly on September 24. Find out more and register: learning.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

Learn how to use and apply Excel’s statistical functions and tools

learning.oreilly.com

1 2 3

Excel Cookbook @theexcelcookbook.bsky.social · 24d

Thank you to everyone who joined me for yesterday's class.

Excel Cookbook @theexcelcookbook.bsky.social · Sep 9

The course covers financial functions, lookup functions (such as INDEX, MATCH, XMATCH, and XLOOKUP), conditional formatting, data validation, forecasting, and more. Hope to see you there!

Financial functions, lookups, conditional formatting, and forecasts

Excel Cookbook @theexcelcookbook.bsky.social · Sep 9

I'm giving my Excel Skills for Finance course on the #OReilly learning platform on September 17. Find out more and register: learning.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

Excel Skills for Finance

learning.oreilly.com

Using ChatGPT, Copilot Pro, and AI add-ins to save time and work more efficiently

Excel Cookbook @theexcelcookbook.bsky.social · Sep 4

Thank you to everyone who joined me for yesterday's class.

Excel Cookbook @theexcelcookbook.bsky.social · Aug 27

Do you want to learn how AI tools like Copilot and ChatGPT can help you get more out of Excel? If so, I'm running my Generative AI for Excel course on the #OReilly learning platform on September 3. Hope to see you there!

www.oreilly.com/live-events/...

@oreilly.bsky.social

Generative AI for Excel

Bring AI to your formulas with the COPILOT function in Excel

1 1 1

Excel Cookbook @theexcelcookbook.bsky.social · Aug 19

#Excel is getting a new COPILOT function, letting you add GenAI prompts to cell values. It's a successor to the LABS.GENERATIVEAI function in the Excel Labs add-in.

techcommunity.microsoft.com/blog/microso...

The COPILOT function in Microsoft Excel for Windows and for Mac allows you to enter a natural language prompt in your spreadsheet, reference cell values, and...

techcommunity.microsoft.com

Mastering Microsoft Excel Charts

Excel Cookbook @theexcelcookbook.bsky.social · Aug 7

Thank you to everyone who joined me for yesterday's Mastering MS Excel Charts class and for all your great questions. For those who missed it, I'm next running the course on November 6.

Excel Cookbook @theexcelcookbook.bsky.social · Jul 30

During the course, I'll teach you when and how to use different chart types, how to modify the chart's elements, tips and tricks for working with charts, and more. Hope to see you there!

1

Excel Cookbook @theexcelcookbook.bsky.social · Jul 30

Do you want to learn how Excel's charting capabilities can help you? If so, I'm running my Mastering MS Excel Charts course on August 6 on the #OReilly learning platform. You can find out more and register here: www.oreilly.com/live-events/...

@oreilly.bsky.social

Using Excel to visually present your data

Foundations of Microsoft Excel

1 1 1

Excel Cookbook @theexcelcookbook.bsky.social · Jul 24

Thank you to everyone who participated in yesterday's Foundations of Excel class. If you missed it, I'm next running the course on October 15.

Excel Cookbook @theexcelcookbook.bsky.social · Jul 16

You'll learn how to use different Excel functions, create tables, and work with PivotTables. I'll also introduce you to Power Query and other time-saving tools and features to help you become more productive.

Hope to see you there!

1

Excel Cookbook @theexcelcookbook.bsky.social · Jul 16

Do you want to learn more about Excel's core features? If so, I'm running my Foundations of Excel course for #OReilly on July 23. You can find out more and register here: www.oreilly.com/live-events/....

@oreilly.bsky.social #Excel

Functions, tables, pivot tables, and Power Query

1 1 3

Excel Cookbook @theexcelcookbook.bsky.social · Jul 10

Thank you to everyone who joined me for yesterday's Mastering PivotTables class. I loved your enthusiasm and the great questions you asked. The class recording should be available within the next day or so. For those who missed it, I will be rerunning the course on October 8.

Excel Cookbook @theexcelcookbook.bsky.social · Jul 2

The class covers PivotTables in-depth and includes using different aggregations, grouping, and calculations. The Power Pivot section shows how to base a PivotTable on multiple related tables and includes measures and KPIs, using date tables, and working with named sets.

Mastering Microsoft Excel pivot tables

Excel Cookbook @theexcelcookbook.bsky.social · Jul 2

Do you want to learn more about using Excel PivotTables or Power Pivot? If so, join me for my Mastering Excel PivotTables course on July 9 on the #OReilly learning platform: www.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

Go beyond the basics to gain proficiency of this important skill

Introduction to Statistics and Data Analysis with Microsoft Excel

Excel Cookbook @theexcelcookbook.bsky.social · Jun 26

Thank you to everyone who took part in yesterday's Introduction to Statistics and Data Analysis class and for all your great questions. For those who missed it, I'm next running the class on September 24.

Excel Cookbook @theexcelcookbook.bsky.social · Jun 19

I'm giving my Introduction to Statistics and Data Analysis with MS Excel course for #OReilly on June 25. The course teaches statistical concepts and techniques from the ground up and covers Excel's statistical functions and the Analysis ToolPak: www.oreilly.com/live-events/...

@oreilly.bsky.social

Learn how to use and apply Excel’s statistical functions and tools