After I published the Affinity Publisher video courses to Teachable, I decided I might as well add the Excel for Beginners, Intermediate Excel, and Easy ExcelEssentials video courses there as well.
These were courses that I originally published on Udemy in 2018, but I didn’t do much with them and eventually Udemy asked for tax information but in such a way that I couldn’t figure out how to give them an EIN for a sole proprietor so I just unpublished them rather than deal with it.
Me being me, once I put those courses up on Teachable I realized that I should also complete the circle and put together a video course on Excel formulas and functions to correspond to 50 Useful Excel Functions and 50 More Excel Functions, so there is now also a video course available on Teachable that covers the content of those two books, Excel Formulas and Functions.
(It’s a long one and if I never have to talk about another Excel formula or function again I will be a very happy person. Of course, I say that but then I’ll get all excited about some new formula or function and want to do so anyway.)
I’ll probably put more content up later but I’m writing a novel for NaNoWriMo this year, so those are the only ones for now. But for anyone looking to learn Excel who learns better by seeing, you do now have those courses available as an option.
Use code MLH50 to get 50% off on most of the courses. (Not on the individual Easy Excel titles like Formatting, IF Functions, etc. because those are priced cheap already, but it should work on the longer courses.)
I had no intention of announcing the release of seven new books at one time, but, well, I forgot to announce the Word 2019 releases and then it happened that the Easy Excel 2019 proofs arrived at the same time as the Excel 2019 Formulas and Functions Study Guide was finished and here we are.
So, if you have an interest in Microsoft Word or Microsoft Excel 2019, read on. If not, you can skip this.
First up, the Microsoft Word 2019 versions of Word for Beginners and Intermediate Word are now out. Once more, if you bought the originals, no need to buy these ones, too. I don’t think there’s anything so drastically different between them that you’d need the new ones. I think I may have moved one item from the intermediate level to the beginner level but that’s about it.
You can click on the images below to be taken to the store of your choice.
Okay. Next up. The Easy Excel Essentials 2019 books are now out. These are intermediate-level titles that focus on one specific topic: PivotTables, Charts, Conditional Formatting, and The IF Functions.
In this case, I’d say there are substantial differences in the IF Functions title because Excel 2019 includes IFS, MAXIFS, and MINIFS which didn’t exist before. So if you’re looking forward and don’t need to worry about backwards compatibility, this is the book you want. If you work with a lot of different Excel users and so can’t risk using the latest and greatest, then stick with the old version. Excel 2019 Charts also covers histograms which was not covered in the original title and Excel 2019 Conditional Formatting is expanded a bit.
Also, the print versions of these books have very different formatting. I decided this time around to go with the standard computer book size formatting for the print versions so these are all 7.5″ x 9.25″. They also have larger text than the original series so may be better for those who struggle with small type.
The astute observer may also notice that the 2019 books do not include Formatting or Printing which were part of the original series. Mostly that’s because even though I meant the titles in this series to be bought as one-offs a lot of people buy the entire series at once so I wanted to focus in more this time around. Really, if you need formatting and printing, just buy Excel 2019 Beginner. It will cost you less and you will learn more.
Okay. Final release to announce, Excel 2019 Formulas and Functions Study Guide. This is the equivalent to the quiz books for the Excel Essentials series. Basically, it takes the content of Excel 2019 Formulas and Functions and walks through that content in a question and answer format. There are also ten bonus exercises at the end to test putting the functions to use in real-world scenarios.
Once more, if you already bought and worked with the original 50 Useful Excel Functions and 50 More Excel Functions and their associated quiz books, probably no need to buy this one. It does cover some new functions like TEXTJOIN and IFS but you can probably fill in the gaps from within Excel itself without needing to buy a new book for it.
(Not that I object to making money, so buy it if you want. Just saying you don’t have to.)
It took me over a year to write it because I truly do not like SmartArt and that had to be covered in an intermediate-level guide to PowerPoint (I find people misuse it atrociously), but it’s finally done.
So if you wanted an intermediate-level guide to PowerPoint that covers charts, shapes, WordArt, SmartArt, headers and footers, and a lot more, here you go. (And the paperback and hardback versions on currently almost 20% off on Barnes & Noble for those of you who like print.) Click on the image below for the universal link.