About Excel SuperHero: or from zero to Hero at work Kindle Edition:
Would you like to become more efficient at work and save time?
Do you want to impress your boss with new abilities?
Are you ready to become an Excel Superhero your company will love?
If you are currently working in an office environment and have a desire to seek promotion, then the surefire way to get it is to be as efficient as possible and cut back on time that is often wasted. Richard needs to use Excel efficiently in his new job and Adam, who is a trainer and Excel fan introduces him to the secrets of this program so that he can be better than anyone else at using it.
This book, Excel SuperHero, uses a very different approach to learning Microsoft Excel as the information appears as in a dialogue between two colleagues, making it simpler for you to understand things like:
Sorting and filtering
How operations and logical functions work
How to use advanced filters
Making the best of tables and charts
Numeric formatting and how it can make you more organized
Keyboard shortcuts that will save you time
Dealing with inevitable errors
And much more…
As with any computer program, Microsoft Excel has many hidden features that are waiting to be discovered. When you follow Richard and Adam’s story you will discover a unique and simple method of learning these for yourself.
You can download training files for each tip in the book to enhance your learning further.
Excel SuperHero can change the way you work and improve your prospects. Let Richard and Adam show you how!
Chapters:
Types of references, or cell, where are you?
Sorting, or from a to z
Filtering, or i choose you
Logical operations and functions, or to be or not to be
Summaries by criteria, or i want you, but i don’t want you
Advanced filters, or we advance by a level
Database functions, or working with the ‘database’
Formulas for data sorting and filtering or selected from a to z
Number formatting or what mask do you put on
Why it is worth using excel tables, or the advantages of putting data behind bars
Pivot tables, or how to rearrange reports
Charts in excel, or a picture worth a thousand numbers
Conditional formatting in excel, or painting the cells
Looking up in excel, or where has d hidden
Checking of data correctness, or you have to be correct
Names in excel, or a rose given a different name
Date and time functions, or from the beginning to the end of time
Text functions and operations, or a pen more powerful than a sword
Keyboard shortcuts, or let’s take the shortcut
New array functions, or sequences, uniqueness, and randomness
Printing, or paper endures all
Errors and their correction, or let’s get the bugs out
Various excel options, or what else is there in excel
