en
Kimberly Hudson

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

Сообщить о появлении
Загрузите файл EPUB или FB2 на Букмейт — и начинайте читать книгу бесплатно. Как загрузить книгу?
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!
Эта книга сейчас недоступна
27 бумажных страниц
Год выхода издания
2012
Уже прочитали? Что скажете?
👍👎

Цитаты

  • Владимирцитирует9 лет назад
    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.
  • Владимирцитирует9 лет назад
    According to Microsoft, “About Macros in Excel,”
  • Владимирцитирует9 лет назад
    Tip: Take the PivotTable tutorial on the Microsoft website before attempting one of your own.

На полках

fb2epub
Перетащите файлы сюда, не более 5 за один раз