Excel
Power Excel with Mr Excel by Bill Jelen
 |
| Power Excel with Mr Excel by Bill Jelen |
Main Contents of Power Excel with Mr Excel by Bill Jelen
- Why Does Office 365 Have Better Features?
- Which Version of Office 365 Has Power Pivot?
- Why Do I Have to Sign in to Excel?
- How Can I Use Excel on Dual Monitors?
- How Can I Open The Same Workbook Twice?
- Find Icons on the Ribbon Where is File
- Where Are My Macros?
- Customizing the Ribbon
- Go Wide
- Minimize the Ribbon to Free Up a Few More Rows
- Use a Wheel Mouse to Scroll Through The Ribbon Tabs
- Why Do The Charting Ribbon Tabs Keep Disappearing?
- Use Dialog Launchers For More Choices
- Icon, Dropdowns, and Hybrids
- How to Print Page Numbers at the Bottom of Each Page
- Have Excel Talk to You
- Use Parentheses to Control the Order of Calculations
- Use White Text to Hide Data
- Very Hide a Worksheet
- Debug Using a Printed Spreadsheet
- Grouping 1 Pivot Table Groups Them All
- Calculated Fields in a Pivot Table
- Create a Pivot Table from Access Data
- Load a List of File Names into Excel
- Get Excel Data Into Power Pivot
- Replace Calculated Fields with DAX
- Share Your Dashboard to Power BI in the Cloud
- Begin Excel 2010 Formatting on Design
- Use the Border Tab in Format Cells
- Select All Cells Using the Keyboard
- Draw an Arrow to Visually Illustrate That Two Cells Are Connected
- Prevent Power BI from Adding Up Year Fields
- Combine Validation with AutoComplete
Foreword to Power Excel with Mr Excel by Bill Jelen
I am a comic book superhero. At least, I play one at work. As the mighty man of macro, I have the coolest job in town: playing MrExcel, the smartest guy in the world of spreadsheets.
Well, yes, that is a lot of hype. I am not really MrExcel. In fact, there are so many different ways to do the same thing in Excel that I am frequently shown up by one of my own students.
Of course, I then appropriate that tip and use it as my own! I have incorporated some of these discoveries in a pretty cool 3.5-hour seminar titled Power Excel Tips.
This is amazing stuff—like pivot tables, filters, and automatic subtotals. I love to be in front of a room full of accountants who use Excel 40+ hours a week and get oohs and ahhs within the first few minutes.
I have to tell you if you can make a room full of CPAs, ooh and ahh, you know that you’ve got some good karma going. At that point, I know it will be a laugh-filled session and a great morning.
One of these classes, which I was presenting at the Greater Akron Chamber, provided the Genesis moment for this book. One of the questions from the audience was about something fairly basic.
As I went through the explanation, the room was silent as everyone sat in rapt attention. People were interested in this basic tip because it was something that affected their lives every day.
It didn’t involve anything cool. It was just basic Excel stuff. But it was basic Excel stuff that a room full of pretty bright people had never figured out. Think about how most of us learned Excel.
We started a new job where they wanted us to use Excel. They showed us the basics of moving around a spreadsheet and sent us on our way. We were lucky to get 5 minutes of training on the world’s most complex piece of software! Here is the surprising part of this deal.
With only 5 minutes of training, you can use Excel 40 hours a week and be productive. Isn’t that cool? A tiny bit of training, and you can do 80% of what you need to do in Excel.
The problem, though, is that there are lots of cool things you never learned about. Microsoft and Lotus were locked in a bitter battle for market share in the mid-1990s.
In an effort to slay one another, each succeeding version of Excel or Lotus 1-2-3 offered incredibly powerful new features. This stuff is still lurking in there, but you would never know to even look for it.
My experience tells me that the average Exceller is still doing things the slow way. If you learn just a couple of these new tips, you could save 2 hours per week.
This book talks about 617 of the most common and irritating problems in Excel. You will find each of these 617 items (which you have been stumbling over ever since your “5 minutes of training”) followed by the solution or solutions you need to solve that problem.
A lot of these topics stem from questions sent my way in seminars I’ve taught. They may not be the coolest tips in the whole world, but if you master even half of these concepts, you will be smarter than 95% of the other Excellers in the world and will certainly save yourself several hours per week.
