PC Webinars

As you go thru the great deals on Amazon today, I invite you to check out my book on Excel Pivot Tables. It is very step-by-step, and it has lots of screen prints, and the sample files are included.

http://www.thepivottablebook.com

Thank you!

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot (Tech Today) Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot (Tech Today)

I am so proud to have the #1 Best selling new release in Excel on Amazon, #3 Overall for Microsoft New Releases.

I don't know how long it is going to be true, but it true right now!

Please check out the book at :

https://www.amazon.com/Getting-Results-Tables-PowerQuery-PowerPivot-ebook/dp/B0D127Z2MC/

Learn PowerAutomate from a Microsoft Certified Trainer
5/15/24 2:00 PM EST
https://auroratrainingadvantage.com/webinars/intro-powerautomate/?promo=tomf
Learn:
What PowerAutomate is
Flows
How to create a form
How to create a flow that will automatically update a spreadsheet whenever a form is filled out.

Introduction to PowerAutomate - Aurora Training Advantage Introduction to PowerAutomate live webinar training.

Hi Everybody.
The Kindle version of my book on Excel Pivot Tables is now available.

https://www.amazon.com/Getting-Results-Tables-PowerQuery-PowerPivot/dp/1394243057/ref=sr_1_1?crid=O0BF9S9V1T6V&dib=eyJ2IjoiMSJ9.6tNJU70V4DQDCZYAiptrlLL-viKVak3cCXyQ_CVpOntCoj7915f0XvFSyHpgfAsfk-t7AhZwdQoOS1dDRIRspri4gWA_WcmafMVSOP7lah1RwZhVJsI6cuprP8lRZfrp7rz8CVmwwdqWmb2cSNsVy1uDGFoG5yxypAlh-2-z5YvSY8DMgsvzcNotJuBMCewlzk_fo90iEH2avarjXMtcoeeeN5Xau9eWunSURJnxnQg.rJISYVbEaj8sH6fbvtZ1E1KfrcrWL72AHnYT7cVzkjs&dib_tag=se&keywords=wiley+pivot+table&qid=1713225172&sprefix=wilwypivot+table%2Caps%2C470&sr=8-1

I tried to make it very step-by-step with lots of screen prints.

A pivot table can take a huge amount of data and summarize it many ways.

Please check it out! :)

Thank you.

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot (Tech Today) Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot (Tech Today)

My new book on Excel Pivot Tables will be shipping at the end of the month. It is published by Wiley and you can pre-order it at http://www.ThePivotTableBook.com

So what is a pivot table anyway. A pivot table allows you to summarize a huge list of data anyway you want. With a pivot table you can subtotal your data, sort it , filter it, chart it, break it down by day, month, quarter , year and summarize it just about any way you want.

I tried to make the book as easy to follow as possible. There are many screen prints, step-by-step directions, and the sample files that I use in the examples come with the book.

Please check it out!
http://www.ThePivotTableBook.com

www.thepivottablebook.com

BIG NEWS!
Hi Everybody. I hope all is well. I have a book coming out on Excel Pivot Tables, and the book is being published by Wiley Publishing. It is available for Pre-Order now, and will ship at the end of April.

http://tinyurl.com/mypivottablebook

A Pivot Table can take a huge amount of data and summarize it many ways. The book will show you how to use pivot tables, and it will have many step-by-step examples and screen prints. It will also contain the sample files mentioned in the book. I tried to make it as user-friendly as possible.
Please check it out , and pre-order it if you think it can help you or someone you know. I would greatly appreciate it.
Thank you, Tom Fragale

http://tinyurl.com/mypivottablebook

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

BIG NEWS!
Hi Everybody. I hope all is well. I have a book coming out on Excel Pivot Tables, and the book is being published by Wiley Publishing. It is available for Pre-Order now, and will ship at the end of April.

http://tinyurl.com/mypivottablebook

A Pivot Table can take a huge amount of data and summarize it many ways. The book will show you how to use pivot tables, and it will have many step-by-step examples and screen prints. It will also contain the sample files mentioned in the book. I tried to make it as user-friendly as possible.

Please check it out , and pre-order it if you think it can help you or someone you know. I would greatly appreciate it.

Thank you, Tom Fragale

http://tinyurl.com/mypivottablebook

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

My most popular course is 20% off for this week only!
25 Must Know Formulas and Functions in Excel

https://learnformula.com/course/25-must-know-formulas-and-functions-in-excel

Description:
In today's world, it's an absolute must that you know Microsoft Excel for most office jobs. There's some formulas and functions that will make your use of Excel more productive . This course shows you how to use 25 "Must-Know" formulas and functions.

Topics:

Autosum
Relative
Absolute
Linking sheets
If
And
Or
Nested if
Countif
Sumif
Averageif
Sumifs
Countifs
Averageifs
iferror
Vlookup
Hlookup
Xlookup
Match
Index
Subtracting dates
Networkdays
Adding days to a date
Workday
Weekday/Weeknum

The course also includes the Excel file that is used in the video. It has the file before the changes, and then another copy of the file with all of the formulas and functions.

It also includes the presentation used in PDF format.

https://learnformula.com/course/25-must-know-formulas-and-functions-in-excel

25 Must-Know Formulas and Functions in Excel | The Marketplace by learnformula

How to combine 2 tables into 1 using the Append Query - Excel PowerQuery


https://youtu.be/-dIrE3KMRFo

Free Live Excel training featuring a Microsoft Certified Trainer w/Q&A
Wednesday 3/15/2023 10:00 AM EST
Stay tuned for details

Free Live Excel Training from a Microsoft Certified Trainer with Q&A.
Wed 3/15/23 10:00 AM EST

http://www.pcwebinars.com

Free Full Course - 25 Must-Know Formulas and Functions in Excel
Hi all. I hope all is well. For a limited time, I am offering this course for free.

Excel Formulas and Functions Tips 1 - 5 To support this channel, please clock the Thanks icon below the video.Please subscribe to my channelhttp://www.youtube.com/user/TomFragale?sub_confirmation=1...

Free Live Webinar today - Managing your Inbox in Outlook

Check out the live webinar today conducted by a Microsoft Certified Trainer with over 35 years of experience. It will feature Q&A.

Click here to register:
http://www.pcwebinars.com

Free Live Outlook Webinar - 12/15/2021 3:00 PM EST
Tips for Managing your Inbox in Outlook
Register here:
http://www.pcwebinars.com

Taught by a Microsoft Certified Trainer with over 35 years of experience, and it feature Q&A

Free Live Webinar Today - Using Vlookup, Hlookup, and Xlookup in Excel - 12/9/2021 3:00 PM EST

Register here:
http://www.pcwebinars.com

It will be taught by a Microsoft Certified Trainer w/ Q&A
Each student will also get the sample file.

Free Excel Training Video - Using a Nested If formula in Excel
https://www.youtube.com/watch?v=fVa9Gq_tbP0

Free Live Webinar with Q&A Next week:

Using Vlookup, Hlookup and Xlookup

12/9/2021 3:00 PM EST

Taught by a Microsoft Certified Trainer.

With Q&A, & will include the Excel sample file.

http://www.pcwebinars.com

Free Video - How to add drop lines and hi-low lines in Excel charts
https://www.youtube.com/watch?v=C-LrbfpnvwE

Free video - How to create a Quick Measure in Microsoft PowerBI
https://www.youtube.com/watch?v=hwjG6AOGAl0