Fazer login Experimenta grátis

Follow us

Bem-vindo à Bookboon

De modo a conseguirmos garantir os nossos serviços, precisamos de alguns cookies essenciais para aceder às nossas funcionalidades.

See Cookies Details
categorias empresarial
páginaprincipal.livro.e-book_profissional

Excel 2021: Advanced Options

Workbook 4

páginaprincipal.livro.por Dr. Peter J. Scharpff RI
69
páginaprincipal.livro.idioma:  English
This workbook covers advanced options and techniques in Excel 2021 when designing and using your models, such as creating series, comments, schedules, references, and security.
Subscrição Profissional Plus grátis durante os primeiros 30 dias, após esse período $6.99/mês
Sem anúncios dentro do livro
Descrição
Conteúdos
book.tabs.learning objectives

There are quite a few tools in Excel 2021 that you can use when designing your models, checking your formulas, coming up with solutions or scenarios, and so on. In this workbook we discuss various options and techniques for the advanced user. You’ll learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, matters such as (external) reference, security, and (saving in a certain) format of your workbooks are discussed.

About the Author

Peter Scharpff originates from the scientific computer-linguistic field focussing on the interaction between man and machine, especially on speech and language engineering. After that he started to develop training material for office automation. In the last few decades he has also produced many publications on topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, drawing, audio, video and photo editing and the like.

  • About the author
  1. Introduction
    1. Design
    2. Notation
    3. Software
  2. Checking formulas
    1. Introduction
    2. Simple numbers
    3. Auditing
    4. Evaluating
    5. Exercise
  3. Filling cells
    1. Introduction
    2. Series
    3. Lists
    4. Exercise
  4. References
    1. Introduction
    2. Copying and linking
    3. External link
    4. Hyperlinks
    5. Exercise
  5. Protection
    1. Introduction
    2. Protecting a Workbook
    3. Protecting a Sheet
  6. Comments
    1. Introduction
    2. Shapes
    3. Notes and Comments
  7. Planning
    1. Introduction
    2. Schedule
    3. Conditional Formatting
    4. Exercise
  8. Solutions
    1. Introduction
    2. Goal Seeking
    3. Solver
  9. Error checking
    1. Introduction
    2. IntelliSense
    3. Actions
  10. Saving workbooks
    1. Introduction
    2. Location
    3. File type
  • That’s it
  • Appendix

Understand different methods for planning and scheduling tasks using Excel. Learn to utilize Excel’s What-If Analysis tools like Goal Seek and Solver for solution finding. Become familiar with the error checking features and how to resolve potential errors. Learn how to save Excel workbooks in different locations and file types for compatibility and sharing.

Escrever uma opinião
páginaprincipal.livro.sobre_autor
Dr.

Dr. Peter J. Scharpff RI

páginaprincipal.livro.descobrir_autor
páginaprincipal.livro.conteúdo_relacionado