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

ABOUT THE BOOKMicrosoft 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 [...]
Visa längre beskrivning

ABOUT THE BOOKMicrosoft 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 AUTHORKimberly 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=7403026Twitter: @KimberlyNHudsonBlog: www.thewestwaswritten.wordpress.comEXCERPT FROM THE BOOKLike 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 CodingFrom 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, "e;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.)"e; Definitely use Excel 2010 for a macro-heavy Excel use.Buy a copy to keep reading!