الفئات الشركات
كتب Professional الإلكترونية

Excel 2021: Worksheets

Workbook 2

65
اللغة:  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 ‏‎‎مجاني‎‎ لأول ‎30‎ ‏يوم‎‎ ثم ‏ $6.99 شهريًا بعد ذلك
الوصول إلى هذا العنوان على منصة bookboon
الوصف
المحتوى
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.

نبذة عن المؤلف
Dr.

Dr. Peter J. Scharpff RI