Excel Cookbook

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.

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!

Mastering Microsoft Excel Charts Using Excel to visually present your data

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

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.

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!

Foundations of Microsoft Excel Functions, tables, pivot tables, and Power Query

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

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.

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 Go beyond the basics to gain proficiency of this important skill

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

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.

Introduction to Statistics and Data Analysis with Microsoft Excel Learn how to use and apply Excel’s statistical functions and tools

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

Thank you to everyone who joined me for today's Generative AI for Excel class. I loved your enthusiasm, and I hope the class sparked ideas for how to use these tools. For those who missed it, I will be running the class again on September 3.

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

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 platform on June 18. Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

Thank you to everyone who joined me for yesterday's Mastering MS Excel Problem Analysis class and for all your great questions. It was great to see so many people there, and I hope the class sparked ideas. If you missed it, I'm next running the course on October 22.

The course covers Excel's What-If Analysis tools—Data Tables, Scenarios, and Goal Seek—and shows how to solve optimization, sequencing, workforce scheduling, and task allocation problems using Solver. Hope to see you there!

Mastering Problem Analysis with Microsoft Excel How to use Microsoft Excel’s What-if Analysis to solve problems and explore scenarios

I'm giving my Mastering Problem Analysis with MS Excel course on the #OReilly learning platform on Wednesday, June 11th. Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social

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

Excel Skills for Finance Financial functions, lookups, conditional formatting, and forecasts

I'm running my Excel Skills for Finance class on June 4 for #OReilly. I'll cover lookup functions (such as INDEX, XMATCH, and XLOOKUP), conditional formatting, data validation, financial functions and more

Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social

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

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! #Excel

Mastering Microsoft Excel Charts Using Excel to visually present your data

I'm running my Microsoft Excel Charts course on the #OReilly learning platform on May 21. Find out more and register: www.oreilly.com/live-events/...

#Excel @oreilly.bsky.social

Thank you to everyone who took part in yesterday's Mastering Power Query with MS Excel class. I loved your questions and enthusiasm, and I hope the class sparked ideas for how Power Query can help you.

Mastering Power Query with Microsoft Excel Transform data, automate repetitive tasks, and open the door to Power BI

The course gives you hands-on practical experience in using Power Query. Hope to see you there! learning.oreilly.com/live-events/...

Power Query is one of Excel's most powerful and flexible tools, and it can make seemingly complex tasks a breeze. Instead of wrangling with cell formulas, Power Query helps you automate data cleaning, transformation, and consolidation with just a few clicks, saving you hours of manual work.

Mastering Power Query with Microsoft Excel Transform data, automate repetitive tasks, and open the door to Power BI

I'm giving my Mastering Power Query with MS #Excel course on the #OReilly learning platform on May 13: learning.oreilly.com/live-events/...

@oreilly.bsky.social

Thank you to everyone who joined me for yesterday's Mastering PivotTables class. I loved your enthusiasm and great questions, and I hope you found the course helpful. For those who missed it, I'm next running the course on July 9.

Previous attendees told me the class helped them overcome their dread of PivotTables and made them feel confident creating them at work.

Hope to see you there!

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 covers measures and KPIs, date tables, and working with named sets.

Mastering Microsoft Excel pivot tables Go beyond the basics to gain proficiency of this important skill

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

@oreilly.bsky.social #Excel

Excel Skills for Finance Financial functions, lookups, conditional formatting, and forecasts

Thank you to everyone who participated in yesterday's Excel Skills for Finance class. For those who missed it, I'll be running the class again on June 4: www.oreilly.com/live-events/...