Kimberly Hudson

Hacker's Guide To Microsoft Excel (How To Use Excel, Shortcuts, Modeling, Macros, and more)

Notify me when the book’s added
To read this book, upload an EPUB or FB2 file to Bookmate. How do I upload a book?
ABOUT THE BOOK

Microsoft Excel is a user-friendly spreadsheet program that lets you organize data, create charts, program time-saving shortcuts, and make reports. It is part of the Microsoft Office Suite. There are multiple versions of Microsoft Excel out there, the latest being part of the Microsoft Office 2010 Suite. Although you may be baffled by Excel now, don’t give up! Once you read what Excel can do, you will quickly use simple functions to answer questions, create charts, and increase productivity.

MEET THE AUTHOR

Kimberly Hudson is a professional writer who lives and works in Massachusetts. Graduated from American University in Washington, D.C. with a B.A., magna cum laude, in International Studies. She spent a semester traveling China. After college she was a research assistant, fundraiser, and has won two national awards for online newsletters.

Facebook: http://www.facebook.com/profile.php?id=7403026

Twitter: @KimberlyNHudson

Blog: www.thewestwaswritten.wordpress.com

EXCERPT FROM THE BOOK

Like all software products, Excel has gone through multiple versions with varying degrees of usefulness. Below are two of the largest issues that can quickly wreck your Excel experience. The takeaway is that if you are doing high function math with Excel, only use the 2010 version.

1. Vanishing Macro Coding

From our earlier discussion of macros, we learned that it is possible to write out sets of instructions that are repeated often so you only have to push one button. Excel has had issues with making this time-saving tool work, especially in the 2007 version. According to NotebookReview.com, “The macro recording errors that plagued Excel 2007 have been repaired…(In the old version, including shapes or charts in your macro recording would leave the final file with huge function gaps or worse, leave a blank recording altogether.)” Definitely use Excel 2010 for a macro-heavy Excel use.

Buy a copy to keep reading!
This book is currently unavailable
27 printed pages
Publication year
2012
Have you already read it? How did you like it?
👍👎

Quotes

  • Владимирhas quoted9 years ago
    For an in-depth discussion of how to construct formulas, please refer to the Lehman College Information Technology Division’s thorough and easy-to-use Excel Formulas & Functions: Tips & Techniques.
  • Владимирhas quoted9 years ago
    According to Microsoft, “About Macros in Excel,”
  • Владимирhas quoted9 years ago
    Tip: Take the PivotTable tutorial on the Microsoft website before attempting one of your own.

On the bookshelves

fb2epub
Drag & drop your files (not more than 5 at once)