Muutke küpsiste eelistusi

Teach Yourself VISUALLY Excel 365 [Pehme köide]

4.00/5 (9 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 234x185x20 mm, kaal: 635 g
  • Sari: Teach Yourself VISUALLY (Tech)
  • Ilmumisaeg: 13-Oct-2022
  • Kirjastus: Visual
  • ISBN-10: 1119933625
  • ISBN-13: 9781119933625
Teised raamatud teemal:
  • Pehme köide
  • Hind: 28,76 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 33,84 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Teach Yourself VISUALLY Excel 365Suurem pilt
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 234x185x20 mm, kaal: 635 g
  • Sari: Teach Yourself VISUALLY (Tech)
  • Ilmumisaeg: 13-Oct-2022
  • Kirjastus: Visual
  • ISBN-10: 1119933625
  • ISBN-13: 9781119933625
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781119933625.html
Märksõnad:
Accompanied by straightforward and easy-to-follow tutorials, this practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app shows users how to present, analyze, visualize and organize data and so much more. Original.

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series

In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to:

  • Create and fill spreadsheets, charts, tables, and PivotTables
  • Filter and sort your data, use and create formulas, and organize your information
  • Visualize your data with a variety of effective charts, graphs, and more

A can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel.

Chapter 1 Getting Started with Excel
Getting to Know Excel
4(2)
Start Excel on the Desktop
6(1)
Navigate to Excel for the Web
7(1)
Tour the Excel Window
8(1)
Work with the Excel Ribbon
9(3)
Chapter 2 Entering Data
Learning the Layout of a Worksheet
12(1)
Understanding the Types of Data You Can Use
13(1)
Enter Text into a Cell
14(2)
Enter a Number into a Cell
16(2)
Enter a Date or Time into a Cell
18(2)
Edit Cell Data
20(2)
Delete Data from a Cell
22(4)
Chapter 3 Working with Ranges
Select a Range
26(2)
Fill a Range with the Same Data
28(2)
Fill a Range with a Series of Values
30(2)
Flash Fill a Range
32(2)
Move or Copy a Range
34(2)
Insert a Row or Column
36(2)
Insert a Cell or Range
38(2)
Delete Data from a Range
40(2)
Delete a Range
42(2)
Hide a Row or Column
44(2)
Freeze Rows or Columns
46(2)
Merge Two or More Cells
48(4)
Chapter 4 Working with Range Names
Understanding the Benefits of Using Range Names
52(2)
Define a Range Name
54(2)
Using Worksheet Text to Define a Range Name
56(2)
Navigate a Workbook Using Range Names
58(2)
Change a Range Name
60(2)
Delete a Range Name
62(4)
Chapter 5 Formatting Excel Ranges
Change the Font and Font Size
66(2)
Apply Font Effects
68(2)
Change the Font Color
70(2)
Align Text Within a Cell
72(2)
Center Text Across Multiple Columns
74(2)
Rotate Text Within a Cell
76(2)
Add a Background Color to a Range
78(2)
Apply a Number Format
80(2)
Change the Number of Decimal Places Displayed
82(2)
Apply a Conditional Format to a Range
84(2)
Apply a Style to a Range
86(2)
Change the Column Width
88(2)
Change the Row Height
90(2)
Wrap Text Within a Cell
92(2)
Add Borders to a Range
94(2)
Copy Formatting from One Cell to Another
96(4)
Chapter 6 Building Formulas
Understanding Excel Formulas
100(2)
Build a Formula
102(2)
Understanding Excel Functions
104(2)
Add a Function to a Formula
106(2)
Add a Range of Numbers
108(2)
Build an AutoSum Formula
110(2)
Add a Range Name to a Formula
112(2)
Reference Another Worksheet Range in a Formula
114(2)
Move or Copy a Formula
116(2)
Switch to Absolute Cell References
118(2)
Troubleshoot Formula Errors
120(4)
Chapter 7 Manipulating Worksheets
Navigate a Worksheet
124(1)
Rename a Worksheet
125(1)
Create a New Worksheet
126(2)
Move a Worksheet
128(2)
Copy a Worksheet
130(2)
Delete a Worksheet
132(2)
Zoom In on or Out of a Worksheet
134(2)
Split a Worksheet into Two Panes
136(2)
Hide and Unhide a Worksheet
138(4)
Chapter 8 Dealing with Workbooks
Create a New Blank Workbook
142(2)
Create a New Workbook from a Template
144(2)
Save a Workbook
146(1)
Open a Workbook
147(1)
Find Text in a Workbook
148(2)
Replace Text in a Workbook
150(4)
Chapter 9 Formatting Workbooks
Modify the Workbook Colors
154(2)
Set the Workbook Fonts
156(2)
Choose Workbook Effects
158(2)
Apply a Workbook Theme
160(2)
Add a Workbook Header
162(2)
Add a Workbook Footer
164(4)
Chapter 10 Importing Data into Excel
Understanding External Data
168(2)
Import Data from an Access Table
170(2)
Import Data from a Word Table
172(2)
Import Data from a Text File
174(2)
Import Data from a Web Page
176(2)
Import Data from an XML File
178(2)
Refresh Imported Data
180(2)
Separate Cell Text into Columns
182(4)
Chapter 11 Working with Tables
Understanding Tables
186(1)
Get to Know Table Features
187(1)
Convert a Range to a Table
188(2)
Select Table Data
190(2)
Insert a Table Row
192(1)
Insert a Table Column
193(1)
Delete a Table Row
194(1)
Delete a Table Column
195(1)
Add a Column Subtotal
196(2)
Convert a Table to a Range
198(1)
Apply a Table Style
199(3)
Chapter 12 Analyzing with PivotTables
Understanding PivotTables
202(1)
Explore PivotTable Features
203(1)
Build a PivotTable from an Excel Range or Table
204(2)
Refresh PivotTable Data
206(2)
Add Multiple Fields to the Row or Column Area
208(2)
Add Multiple Fields to the Data Area
210(2)
Move a Field to a Different Area
212(2)
Group PivotTable Values
214(2)
Apply a PivotTable Filter
216(4)
Chapter 13 Analyzing Data
Sort a Range or Table
220(2)
Filter a Range or Table
222(2)
Set Data Validation Rules
224(2)
Create a Data Table
226(2)
Summarize Data with Subtotals
228(2)
Group Related Data
230(2)
Analyze Data with Goal Seek
232(2)
Highlight Cells That Meet Some Criteria
234(2)
Highlight the Top or Bottom Values in a Range
236(2)
Analyze Cell Values with Data Bars
238(2)
Analyze Cell Values with Color Scales
240(2)
Analyze Cell Values with Icon Sets
242(4)
Chapter 14 Visualizing Data with Charts
Examine Chart Elements
246(1)
Understanding Chart Types
247(1)
Create a Chart
248(2)
Create a Recommended Chart
250(2)
Add Chart Titles
252(1)
Add Data Labels
253(1)
Position the Chart Legend
254(1)
Display Chart Gridlines
255(1)
Display a Data Table
256(1)
Change the Chart Layout and Style
257(1)
Select a Different Chart Type
258(2)
Change the Chart Source Data
260(2)
Move or Resize a Chart
262(4)
Chapter 15 Adding Worksheet Graphics
Draw a Shape
266(2)
Insert an Online Image
268(2)
Insert a Photo from Your PC
270(2)
Insert a SmartArt Graphic
272(2)
Move or Resize a Graphic
274(2)
Format a Picture
276(4)
Chapter 16 Collaborating with Others
Add a Comment to a Cell
280(2)
Protect a Worksheet's Data
282(2)
Protect a Workbook's Structure
284(2)
Save a Workbook to Your OneDrive
286(2)
Send a Workbook as an Email Attachment
288(2)
Save Excel Data as a Web Page
290(2)
Make a Workbook Compatible with Earlier Versions of Excel
292(2)
Mark Up a Worksheet with Digital Ink
294(2)
Collaborate on a Workbook Online
296(2)
Index 298
Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991, and he has more than 100 books to his credit. Paul's books have sold more than four million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Windows 11, Second Edition, Teach Yourself VISUALLY Microsoft 365, Second Edition, Google Workspace For Dummies, and HTML, CSS, and JavaScript for Dummies. Paul invites you to drop by his personal website at https://paulmcfedries.com and to follow him on X @paulmcf and on Facebook at https://facebook.com/PaulMcFedries.