Categories Corporate
Professional eBook

Excel 2021: Worksheets

Workbook 2

65
Language:  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 subscription free for the first 30 days, then $6.99/mo
Access this book on our eReader, no adverts inside the book
Description
Content
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.

About the Author
Dr.

Dr. Peter J. Scharpff RI