Kategorien Unternehmen
home.book.professional_ebook

Excel 2021: Worksheets

Workbook 2

65
Sprache:  English
In this ebook we discuss a lot of options for worksheets in Excel 2021, like formatting of text and numbers, and copying formulas. Also the display and printing of sheets is discussed.
Professional Plus Mitgliedschaft 30 Tage gratis, danach $6.99/Monat
Zugriff auf das Buch in unserem eReader; keine Werbung im Buch
Beschreibung
Inhalt
book.tabs.learning objectives

This workbook focuses on the worksheets you create in the workbooks (files) of Excel 2021. In particular, formatting, both of the text and numbers in your cells, and of the worksheet itself, is discussed. Also, you’ll see how to quickly build models by copying formulas. The special views you can use to look at your worksheets, and the most important issues about printing are discussed in this user guide as well.

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. Editing worksheets
    1. Introduction
    2. Column widths
    3. Copying
    4. Inserting and deleting
  3. Cell formatting
    1. Introduction
    2. Number format
    3. Text formatting
    4. Borders
    5. Conditional formatting
    6. Exercise
  4. Sheets and windows
    1. Introduction
    2. Worksheets
    3. Windows
  5. Printing
    1. Introduction
    2. Scope
    3. Printing large sheets
    4. Options
    5. Headers and footers
    6. Printing
  • That’s it
  • Appendix

Understand how to copy and edit worksheets effectively. Know how to create and manage multiple sheets and windows within an Excel workbook. Discover how to prepare an Excel worksheet for printing, including setting print ranges and scaling options. Gain skills in applying headers, footers, and conditional formatting to improve worksheet presentation.

Über den Autor/die Autorin
Dr.

Dr. Peter J. Scharpff RI