Advertisement · 728 × 90

Posts by Excel Cookbook

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

6 days ago 0 0 0 0
Preview
Excel Skills for Finance Financial functions, lookups, conditional formatting, and forecasts

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

@oreilly.bsky.social

6 days ago 1 1 1 0

Thank you to everyone who joined me for yesterday's class, and for all your great questions.

6 days ago 0 0 0 0

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. You can attend with a free trial if you don't already have an #OReilly subscription.

2 weeks ago 1 0 1 0
Preview
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 April 15th. Find out more and register: www.oreilly.com/live-events/....

@oreilly.bsky.social

2 weeks ago 1 1 1 0

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 next on June 10th.

3 weeks ago 0 0 0 0

The class covers PivotTables in depth, including aggregations, grouping, filtering, and custom calculations. The Power Pivot section shows how to base a PivotTable on multiple related tables, and includes measures, KPIs, date tables, and more.

Hope to see you there!

1 month ago 0 0 1 0
Advertisement
Preview
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 March 25th on the #OReilly learning platform: www.oreilly.com/live-events/...

@oreilly.bsky.social #Excel

1 month ago 2 2 1 0
Preview
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 for #OReilly on March 4. Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social

1 month ago 2 1 0 0

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

2 months ago 0 0 0 0

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!

2 months ago 0 0 1 0
Preview
Mastering Problem Analysis with Microsoft Excel How to use Microsoft Excel’s What-if Analysis to solve problems and explore scenarios

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

@oreilly.bsky.social

2 months ago 1 1 1 0

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

2 months ago 0 0 0 0

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!

2 months ago 0 0 1 0
Preview
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 February 4th. Find out more and register: www.oreilly.com/live-events/...

#Excel @oreilly.bsky.social

2 months ago 2 1 2 0

Thank you to everyone who joined me for yesterday's class. If you missed it, I'm next running the course on March 25th.

3 months ago 0 0 0 0

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

3 months ago 0 0 1 0
Advertisement
Preview
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 January 21 on the #OReilly learning platform: www.oreilly.com/live-events/...

@oreilly.bsky.social

3 months ago 1 1 1 0

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

3 months ago 0 0 0 0

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 you can join me!

3 months ago 0 0 1 0
Preview
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 January 14th. Hope to see you there: www.oreilly.com/live-events/....

@oreilly.bsky.social

3 months ago 1 1 1 0

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

3 months ago 0 0 0 0
Preview
Excel Skills for Finance Financial functions, lookups, conditional formatting, and forecasts

I'm giving my Excel Skills for Finance course on the #OReilly learning platform on January 7. The course includes financial functions, lookup functions (such as INDEX, MATCH, XMATCH, and XLOOKUP), conditional formatting, and forecasting: www.oreilly.com/live-events/...

@oreilly.bsky.social

3 months ago 1 1 1 0

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

4 months ago 0 0 0 0

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

Hope to see you there!

4 months ago 0 0 1 0
Advertisement
Preview
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 December 10 on the #OReilly learning platform: www.oreilly.com/live-events/...

@oreilly.bsky.social

4 months ago 1 1 1 0

Thank you to everyone who joined me for yesterday's class. I hope it sparked ideas for using these tools.

4 months ago 0 0 0 0
Preview
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 for #OReilly again on December 3. Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social

4 months ago 1 1 1 0

Thank you to everyone who joined me for today's class. For those who missed it, I'm running the class again on December 3.

5 months ago 1 0 0 0
Preview
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 for #OReilly on November 12. Find out more and register: www.oreilly.com/live-events/...

@oreilly.bsky.social

5 months ago 2 1 2 0