en
Kimberly Hudson

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

Avise-me quando o livro for adicionado
Para ler este livro carregue o arquivo EPUB ou FB2 no Bookmate. Como carrego um livro?
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!
Este livro está indisponível
27 páginas impressas
Ano da publicação
2012
Já leu? O que achou?
👍👎

Citações

  • Владимирfez uma citaçãohá 9 anos
    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.
  • Владимирfez uma citaçãohá 9 anos
    According to Microsoft, “About Macros in Excel,”
  • Владимирfez uma citaçãohá 9 anos
    Tip: Take the PivotTable tutorial on the Microsoft website before attempting one of your own.

Nas estantes

fb2epub
Arraste e solte seus arquivos (não mais do que 5 por vez)