Cargando…
Excel 2013 Simplified.
A friendly, visual approach to learning the basics of Excel 2013 As the world's leading spreadsheet program, Excel is a spreadsheet and data analysis tool that is part of the Microsoft Office suite. The new Excel 2013 includes new features and functionalities that require users of older version...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
Wiley,
2013.
|
| Colección: | Simplified.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Microsoft® Excel® 2013 Simplified®; Credits; About the Author; Author's Acknowledgments; How to Use This Book; Table of Contents; CHAPTER 1: Working with Excel; Getting to Know Excel; Start Excel; Tour the Excel Window; Work with the Excel Ribbon; Work with the Excel Galleries; Customize the Quick Access Toolbar; Customize the Ribbon; Change the View; Configure Excel Options; Add Excel to the Windows Taskbar; Quit Excel; CHAPTER 2: Entering Data; Learning the Layout of a Worksheet; Understanding the Types of Data You Can Use; Enter Text into a Cell; Enter a Number into a Cell.
- Enter a Date or Time into a Cell; Insert a Symbol; Edit Cell Data; Delete Data from a Cell; CHAPTER 3: Working with Ranges; Select a Range; Fill a Range with the Same Data; Fill a Range with a Series of Values; Flash Fill a Range; Move or Copy a Range; Insert a Row or Column; Insert a Cell or Range; Delete Data from a Range; Delete a Range; Hide a Row or Column; Freeze Rows or Columns; Merge Two or More Cells; Transpose Rows and Columns; CHAPTER 4: Working with Range Names; Understanding the Benefits of Using Range Names; Define a Range Name; Use Worksheet Text to Define a Range Name.
- Navigate a Workbook Using Range Names; Change a Range Name; Delete a Range Name; CHAPTER 5: Formatting Excel Ranges; Change the Font and Font Size; Apply Font Effects; Change the Font Color; Align Text Within a Cell; Center Text Across Multiple Columns; Rotate Text Within a Cell; Add a Background Color to a Range; Apply a Number Format; Change the Number of Decimal Places Displayed; Apply an Auto Format to a Range; Apply a Conditional Format to a Range; Apply a Style to a Range; Change the Column Width; Change the Row Height; Wrap Text Within a Cell; Add Borders to a Range.
- CHAPTER 6: Building Formulas; Understanding Excel Formulas; Build a Formula; Understanding Excel Functions; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; CHAPTER 7: Manipulating Worksheets; Navigate a Worksheet; Rename a Worksheet; Create a New Worksheet; Move a Worksheet; Copy a Worksheet; Delete a Worksheet; Change the Gridline Color; Toggle Worksheet Gridlines On and Off; Toggle Worksheet Headings On and Off; CHAPTER 8: Dealing with Workbooks.
- Create a New Blank Workbook; Create a New Workbook from a Template; Save a Workbook; Open a Workbook; Arrange Workbook Windows; Find Text in a Workbook; Replace Text in a Workbook; CHAPTER 9: Formatting Workbooks; Modify the Workbook Colors; Set the Workbook Fonts; Choose Workbook Effects; Apply a Workbook Theme; Add a Workbook Header; Add a Workbook Footer; CHAPTER 10: Working with Tables; Understanding Tables; Get to Know Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal.