en
Kimberly Hudson

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

Kitap eklendiğinde bana bildir
Bu kitabı okumak için Bookmate’e EPUB ya da FB2 dosyası yükleyin. Bir kitabı nasıl yüklerim?
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!
Bu kitap şu anda mevcut değil
27 yazdırılmış sayfalar
Yayınlanma yılı
2012
Bunu zaten okudunuz mu? Bunun hakkında ne düşünüyorsunuz?
👍👎

Alıntılar

  • Владимирalıntı yaptı9 yıl önce
    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.
  • Владимирalıntı yaptı9 yıl önce
    According to Microsoft, “About Macros in Excel,”
  • Владимирalıntı yaptı9 yıl önce
    Tip: Take the PivotTable tutorial on the Microsoft website before attempting one of your own.

Kitap raflarında

fb2epub
Dosyalarınızı sürükleyin ve bırakın (bir kerede en fazla 5 tane)