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

M.L. Humphrey

Bryan Hong

John Michaloudis

Henry E. Mejia

Scott Hartshorn

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
$3.99

Kindle Edition
$2.99

Kindle Edition
$0.99

Kindle Edition
$2.99

Kindle Edition
$0.99

Kindle Edition
$2.99

Kindle Edition
$9.99

Kindle Edition
$2.99

Kindle Edition
$3.99

Kindle Edition
$3.99

Kindle Edition
$2.99

Kindle Edition

Author Updates

Titles By Mark Moore

All Formats Kindle Edition Paperback

Mastering Excel: Excel Apps Apr 28, 2015

by Mark Moore

( 207 )

$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: Pivot Tables Apr 1, 2013

by Mark Moore

( 81 )

$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: Spreadsheet Inquire Dec 8, 2016

by Mark Moore

( 19 )

$2.99

What is Spreadsheet Inquire? Only the best Excel auditing tool you've never heard of.

Developed by Microsoft, this free tool helps you analyze relationships between workbooks, relationships between worksheets, create maps of all the worksheets in a workbook and more.

I'll show you how to get the add-in from the Microsoft website and use it. With this excellent tool, you'll never be left guessing how a workbook is built.

Other Formats: Paperback

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

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

by Mark Moore

( 808 )

$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 Macros: PowerPoint Automation (Book 7) May 13, 2015

by Mark Moore

( 8 )

$2.99

This lesson continues with the topic of object variables. In this lesson you will create an object variable that represents not a cell, not a workbook but PowerPoint. This functionality is called Automation. You will then learn to write a macro that lets you control PowerPoint from Excel. The lesson exercise includes a sample certificate built in PowerPoint. You will programmatically take information from Excel and put it in PowerPoint. This exercise can be altered to work with any other existing PowerPoint presentation.

This lesson comes with several follow along workbooks that you can use to work through the exercises as you read the lesson.

NOTE: To work through this lesson you must have PowerPoint installed on your PC.

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

Mastering Excel Formulas SUM, SUMIF Nov 17, 2012

by Mark Moore

( 16 )

$0.99

It is one of the most common of Excel functions, SUM. You think you know everything about this function? Think again! This function has been improved upon by Microsoft. There are new tricks and tips that let you sum data based on other values. Not only covering SUM, this book also covers SUMIF, SUBTOTAL and shows you how to use each in plain English with no tech talk.

Excel for normal people. You don't need to be a programmer or mathematician to use Excel!

Other Formats: Paperback

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

Mastering Excel Formula Tips and Tricks Oct 23, 2013

by Mark Moore

( 18 )

$2.99

The formula book you wish you had.

Excel is all about formulas. Think through how to do a calculation once, make sure it is correct, then copy it to other cells and use it as many times as you need to. In this lesson, you will learn some of the most popular (and few not so popular) formulas, you will review their syntax, how to use them, and you will also learn some other non-formula tricks that will make your life much easier. Let the computer do the hard work!

A few of the topics covered in this lesson are: Absolute and Relative Cell References, Function Screentips, Function Wizard, Edit Directly in Cell, Text to Columns, Formula Auditing, Evaluate Formula, Watch Window, Scroll Lock/F2 Trick, Summing Across Worksheets, Custom Number Formats, Precision As Displayed, Protecting and Hiding Formulas

Formulas: LEFT, RIGHT, SEARCH, PROPER, TRIM, CONCATENATE, TODAY, NOW, YEAR, MONTH, DAY, NETWORKDAYS, DATEDIF, CELL, INDIRECT, MIN, MAX, SMALL, COUNT, COUNTA, SUBSTITUTE, VLOOKUP, IF, COUNTIF, AVERAGE, MEDIAN, MODE, AVERAGEIF, AVERAGEIFS, IFERROR, SUTBTOTAL, OFFSET, SUMIF, SUMIFS, ROUND.

Included with the lesson is a follow along workbook for you to work through as you read the text.

Other Formats: Paperback

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

Mastering Excel: Power Apps Feb 2, 2020

by Mark Moore

( 3 )

$9.99

What if I told you that you could build a smartphone app (iOS and Android) that could read and write data from Excel...without writing code?

That is exactly what PowerApps does. Not only Excel but SQL Server, Sharepoint and a host of other platforms. For this lesson, we're sticking to Excel. You will learn how to navigate the PowerApps interface, how to design smartphone and tablet applications and get your hands dirty with the PowerApps formula language. Don't worry, if you can write an Excel formula, you can write a PowerApps formula.

You will also learn:

How to get Power Apps
How to Connect to Excel
Reading Excel Data
Writing to Excel
Using the phone GPS with Excel
Using Google Maps with Excel
Debugging

Everything in the lesson is written in a step-by-step fashion with plenty of images to guide you. PowerApps is the skill that will make you the definitive office guru.
IMPORTANT NOTE:
In order to use PowerApps, you will need a work email. Work email means an email that is not from a public company like Google, Yahoo, etc.

Other Formats: Paperback

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

Mastering Excel: User Forms Mar 9, 2015

by Mark Moore

( 18 )

$2.99

This lesson covers user interfaces. Most Excel models are content with having users type in a number or text in a cell and then the formulas use that input.

There are more user friendly way to interact with your users. In this lesson you will learn how to include option buttons, scroll bars, check boxes and other user form objects to give your users a familiar way to interact with Excel. You will also learn how to use new formulas (not covered in previous lessons) that connect the form objects with the data in the workbook.

This lesson comes with two follow along workbooks so you can practice as you read the text.

Other Formats: Paperback

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

by Mark Moore

( 6 )

$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: Building Dashboards May 12, 2015

by Mark Moore

( 30 )

$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: FileSystemObject (Book 8) Jul 24, 2015

by Mark Moore

( 7 )

$2.99

This macro lesson continues with the topic of automation. Here you are going to learn how to use the FileSystemObject (FSO) object. The FSO object is the object that Windows uses to create, delete, copy files and folders. You will learn how to use the FSO to list all the subfolders in a folder, the files in a folder, create text files, etc. There are many additional actions you can do with FSO, at the end of the lesson there is a list of some popular FSO methods.

This lesson comes with a follow along workbook that has all the completed exercises.

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

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