Mark Moore

Follow to get new release updates and improved recommendations

About Mark Moore

I like Excel. I'm pretty good at Excel. I've been working in corporate finance for a looong time (over 25 years). I studied Finance in college and I also went to graduate school (I say this for the people who are really concerned about my 'qualifications').

I want to make you an Excel rock star. It doesn't matter what industry you are in, you need to get better at Excel. Excel is THE killer application used in business. Don't cower in the corner when someone mentions Excel! You're better than that! Stand proud, laugh derisively and yell, 'I can do that, and more, in Excel!" You may want to wave your arms around melodramatically for added effect.

Before you do that though, buy my lessons. If you don't, you're kind of putting the cart before the horse. FIRST buy and read my lessons, THEN do the laughing thing.

The lessons are short. That is by design. One lesson = one topic. No fluff. I don't like fluff in my Excel. Fluff on kittens and ferrets, ok that's acceptable. In an Excel book? Nope. You're just going to get the info you need on one topic. Learn it and use it when you are done. No muss, no fuss.

Ohh yeah, each lesson comes with a few Excel workbooks so you can work through the exercises. Practice makes perfect!

Finally, you can also email me with any questions you have. I've helped many readers with their Excel problems. Don't be shy. Ask away.

OK, enough about me. Well not really, this is MY author page isn't it? It's ALL ABOUT ME!

*This author page is not to be considered a reflection of the content of Mark Moore's Excel lessons. Mark tones down his 'personality' while writing his lessons. However, a few jokes have been known to sneak past the editors and into the lessons.

The lessons are good. Seriously. Look at the reviews.

Author tidbit: I never learned how to type. After years of bad typing, my fingers are now habituated to typing 'teh' instead of 'the'. I HATE it.

Does anyone really read these author bio's?

HEIN SMITH

Michael Alexander

M.L. Humphrey

Daneyal Anis

Scott Hartshorn

Roger F. Silva

Are you an author?

Help us improve our Author Pages by updating your bibliography and submitting a new or current image and biography.

Learn more at Author Central

1 11 1

$0.00

Kindle Edition
$2.99

Kindle Edition
$0.99

Kindle Edition
$5.99

Kindle Edition
$5.99

Kindle Edition
$2.99

Kindle Edition
$3.99

Kindle Edition
$3.99

Kindle Edition
$2.99

Kindle Edition
$2.99

Kindle Edition
$3.99

Kindle Edition
$2.99

Kindle Edition

Author Updates

Books By Mark Moore

All Formats Kindle Edition Paperback

Mastering Excel: Excel Apps Apr 28, 2015

by Mark Moore

( 76 )

$0.00

This lesson only applies to Excel 2013 or Office 365!

This short lesson covers Excel applications (apps). Apps are almost like the apps you find on your smartphone. In the Excel world, an app is a small, programmed interface that interacts with Excel data to extend your spreadsheet's functionality.

Excel come with two apps built by Microsoft. You will learn how to use these apps to add dynamic charts to your worksheets. There is no programming involved with these apps. They do all the work for you.

As with all my other lessons, this one comes with two follow along workbooks. One you can use to work through the exercises and the other one has the completed exercises.

Once again, if you do not have Excel 2013 or Office 365 for Windows, you will not be able to use this lesson!

Mastering Excel: Sharing Workbooks Jun 8, 2014

by Mark Moore

( 3 )

$2.99

If you want to learn how to use Excel without intimidating technical jargon and learn at your own pace. The Mastering Excel series is for you; the series is targeted to beginning Excel users that want to increase their Excel knowledge in a stress-free environment.

This lesson focuses on Shared Workbooks. This is a feature in Excel where a workbook can be set up so that multiple users can have it open at the same time and make changes to it. When a workbook is shared, Excel also begins to track all changes made to any cell or formula. We will cover how to track changes, make advanced adjustments to change tracking and how to save changes permanently.

We will also review how to set up protection for specific workbook cells so that only users with the password can change those specified cells.

Like the previous lessons, a follow along workbook is available (the link is inside the book) where you can follow step by step with the lesson.

The lesson and follow along workbook are for Excel 2013 for Windows.

Mastering Excel Macros: Introduction (Book 1) Sep 30, 2014

by Mark Moore

( 596 )

$0.99

Excel macros. Everybody wants to learn them. You're not a programmer though. How is a non technical user going to learn how to program? You do want to use macros to make your work easier but are you really going to sit down with a huge programming textbook and work your way through every. single. boring. page? Like most people, you'll start with great enthusiasm and vigor but after a few chapters, the novelty wears off. It gets boring.

I'm going to try and change that and make learning macro programming entertaining and accessible to non-techies. First of all, programming Excel macros is a huge topic. Let's eat the elephant one bite at a time. Instead of sitting down with a dry, heavy text, you will read very focused, to the point topics. You can then immediately use what you learned in the real world.

This is the first lesson in the series. You will learn what macros are, how to access them, a tiny bit of programming theory (just so you have a clue as to what's going on) and how to record macros. As with all my other lessons, this one has a follow along workbook that you can use to work through the exercises.

Mastering Excel: Power Pack Bundle Jun 9, 2016

by Mark Moore

( 11 )

$5.99

Learn how to use all the new Power BI Tools

If you want to perform heavy duty analysis on large data sets, as in well over 1,000,000 rows, this bundle is for you. These new features let Excel crunch through data extremely efficiently.
Even if you don't have massive data sets, you can still use Power View and Power Map to create seriously impressive presentations.

This is a huge lesson, tipping the scales at 212 pages. Lots of great stuff in here!

Note: Microsoft has moved Power Map and Power View to Power BI desktop. Power BI desktop is free to download from Microsoft. Power Map and Power View material still applies for these tools.

This bundle contains the following lessons:

Mastering Excel: Power Query (Get data form external sources)
Mastering Excel: Power Pivot (Create a data model with tables and relationships)
Mastering Excel: Power View (Create a new type of Excel presentation)
Mastering Excel: Power Map (Show data in animated maps)

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel: Dashboard Bundle Jun 5, 2015

by Mark Moore

( 8 )

$5.99

Building elegant, informative and eye-catching dashboards in Excel is an indispensable skill. Learn how to build them in one afternoon.

There are many small, simple skills that you need to know to build amazing dashboards. Most Excel users may know the skills but they do not know how to combine them correctly. This comprehensive lesson will take you from zero to dashboard master. You will learn all the basic skills and then how and why, you should combine them.

Note, there is no programming involved here, simply some very clever tricks and tips to make Excel perform magic. This is not a dry, boring, technical Excel book. This is a real-life Excel lesson loaded with images and ample explanations in plain English. The material is written for every level of Excel user, from basic to advanced.

The lesson includes a link to my website where you can download sample workbooks to follow along with the material. I am always available to answer any questions.

This bundle contains the following lessons:

Mastering Excel Formulas: SUM, SUMIF
Mastering Excel Formulas: VLOOKUP
Mastering Excel: Pivot Tables
Mastering Excel:Mastering Excel: Named Ranges, OFFSET and Dynamic Charts
Mastering Excel: Conditional Formatting
Mastering Excel: User Forms
Mastering Excel: Building Dashboards

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel Formulas VLOOKUP Nov 13, 2013

by Mark Moore

( 37 )

$2.99

You've heard the rumors, you've seen other people at the office work magic with it...

Can you be one of the select few?

VLOOKUP, the formula that strikes terror into the minds of Excel users. It's intimidating, it even sounds weird. What's it all about?

In this Excel lesson, everything will be revealed. You want to find the highest grossing salesperson from your data set? Maybe you need to build a dashboard that shows the best selling products.

VLOOKUP can handle all these scenarios, and more. I'll explain exactly how it works, when you should use it and most importantly, how to fix it when it breaks.

But wait...

VLOOKUP is powerful but it can't do everything. It has limitations and you'll also learn how to supercharge your Excel powers with the INDEX function. It does what VLOOKUP wishes it could do.

Waait...there's more...

Microsoft recently released a new function called XLOOKUP.

XLOOKUP is what VLOOKUP wants to be when it grows up. This brand new function throws VLOOKUP and INDEX into the trash heap and never looks back. You can search starting at the top, from the bottom, you can go left, go right, the options are amazing.

This lesson comes with workbooks that you can use to follow along and practice what you read. By the time you are finished, you will be ready to use all these formulas in your files and save yourself hours of work.

Get it now.

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel: Pivot Tables Apr 1, 2013

by Mark Moore

( 73 )

$3.99

Learn the tips and tricks to crunch thousands of rows of data with pivot tables.

Pivot tables are the indispensable skill you need to know to master Excel. They are the workhorses of Excel. You have 100,000 rows of data by invoice, product, salesperson and you are getting bombarded with questions. Who’s the highest earner? Which product sold the most in the last seven days.

After this lesson, you’ll be able to answer those questions in seconds.

This lesson is laser focused on this incredibly power tool.

I walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and much more.

As always, I explain all the steps in plain English. The lessons are geared towards the average Excel user that just wants to improve their skill set without having to suffer through hours of technical, confusing instruction.

Included in the book is a link to download a free workbook so you can follow along with the exercises at your own pace.

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel Macros: Charts (Book 12) Jun 7, 2017

by Mark Moore

( 3 )

$3.99

This macro lesson focuses on manipulating charts in Excel. You will learn how to:

* Update a charts data series
* Set up a worksheet where users can change the chart type
* Build a worksheet where charts update automatically based on the cell a user selects
* and more!

There is a link in the lesson where you can download the follow along workbooks to practice the exercises in the book to get hands-on experience.

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel Macros: VBA Forms and Events - Book 9 Nov 20, 2015

by Mark Moore

( 4 )

$2.99

This lesson continues the path towards macro mastery, one topic at a time. You will learn all about VBA forms. These forms are very different than the regular Form Objects you place directly on a worksheet. VBA Forms are completely customizable and contain their own macros inside them. You will learn when it is appropriate to use regular Form Objects vs. VBA Forms, using the Data Form, leveraging Excel's built-in dialogs and coding your own VBA Form with several different control types.

This lesson comes with two follow along workbooks. One that you use to work through the lesson and a second one with all the answers.

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel: Conditional Formatting May 8, 2014

by Mark Moore

( 12 )

$2.99

In this lesson we cover all the options for applying conditional formats to a workbook. Conditional formats are formatting rules that we can apply so when a cell's number changes, the format will change automatically.

This is an excellent feature to use to draw a user's attention to outlying numbers, problem areas or to give a quick visual summaries of the data. We will cover:
* Highlight Cell Rules
* Top/Bottom Rules
* Data Bars
* Color Scales
* Icon Sets
* Using Formulas
In all the above, we will also go into how to customize all the options to make any report automatically update itself according to the criteria we set.

Like the other lessons, this lesson contains a link where you can download a follow along workbook and practice what is covered.

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel: Building Dashboards May 12, 2015

by Mark Moore

( 22 )

$3.99

This lesson of the Mastering Excel series teaches you how to build a complete dashboard in Excel. You will learn how to structure your Excel model correctly with the three layers: Data, Business Logic & Presentation. You will build several dynamic, interactive charts that will respond to a user's selection.

All this is done with no macro programming. This lesson teaches you how to use standard Excel features and link them together in creative ways to make very impressive dashboards.

IMPORTANT NOTE: This course has pre-requisites, you must know the following topics to successfully complete the exercises:

- Pivot Tables
- Dynamic Charts
- SUM, SUMIF
- VLOOKUP
- OFFSET
- User Forms

You will be using all of these to build interactive dashboards.

Other Formats: Paperback

This title and over 1 million more available with Kindle Unlimited.

Mastering Excel Macros: Arrays (Book 10) Feb 6, 2016

by Mark Moore

( 3 )

$2.99

This lesson covers the VBA topics: Arrays, Collections and Dictionaries. Each one of these items help you use macros to manage, calculate and process large amounts of information. Why are these needed? Because performing calculations in macro is exponential faster than performing calculations in a worksheet. Seriously faster. This lesson has a sample workbook where you can test and see the performance improvements.

If you are new to my lessons (by lesson 10 you shouldn't be...but who knows!), you will see a link in the lesson where you can download follow along workbooks so you can practice what you read.

I also don't abandon you after you buy the lesson, if you have any questions, you can email me and I will help you out.

This title and over 1 million more available with Kindle Unlimited.

←Previous Page
1
2
3
4
Next Page→

More Information

Are you an author? Visit Author Central to change your photo, edit your biography, and more

See Author Pages Frequently Asked Questions

Anything else? Provide feedback about this page

Similar authors to follow

About Mark Moore

Customers Also Bought Items By

Are you an author?

Author Updates

More Information