The course includes financial functions, lookup functions (such as INDEX, MATCH, XMATCH, and XLOOKUP), conditional formatting, and forecasting. Hope to see you there!
Posts by Excel Cookbook
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
Thank you to everyone who joined me for yesterday's class, and for all your great questions.
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.
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
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.
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!
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
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
Thank you to everyone who joined me for yesterday's class.
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!
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
Thank you to everyone who joined me for yesterday's class.
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!
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
Thank you to everyone who joined me for yesterday's class. If you missed it, I'm next running the course on March 25th.
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.
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
Thank you to everyone who joined me for yesterday's class.
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!
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
Thank you to everyone who joined me for yesterday's class.
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
Thank you to everyone who joined me for yesterday's class.
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!
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
Thank you to everyone who joined me for yesterday's class. I hope it sparked ideas for using these tools.
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
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.
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