Atjauninât sîkdatòu piekriðanu

Illustrated Series® Collection, Microsoft® Office 365® & Excel® 2021 Comprehensive 2nd edition [Mîkstie vâki]

5.00/5 (2 ratings by Goodreads)
(NA)
  • Formâts: Paperback / softback, 304 pages, height x width x depth: 17x213x276 mm, weight: 589 g
  • Izdoðanas datums: 27-Sep-2022
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 035767510X
  • ISBN-13: 9780357675106
Citas grâmatas par ðo tçmu:
  • Mîkstie vâki
  • Cena: 78,09 €*
  • * ði ir gala cena, t.i., netiek piemçrotas nekâdas papildus atlaides
  • Standarta cena: 97,62 €
  • Ietaupiet 20%
  • Grâmatu piegâdes laiks ir 3-4 nedçïas, ja grâmata ir uz vietas izdevniecîbas noliktavâ. Ja izdevçjam nepiecieðams publicçt jaunu tirâþu, grâmatas piegâde var aizkavçties.
  • Daudzums:
  • Ielikt grozā
  • Piegâdes laiks - 4-6 nedçïas
  • Pievienot vçlmju sarakstam
Illustrated Series® Collection, Microsoft® Office 365® & Excel® 2021 Comprehensive 2nd editionPalielinât
  • Formâts: Paperback / softback, 304 pages, height x width x depth: 17x213x276 mm, weight: 589 g
  • Izdoðanas datums: 27-Sep-2022
  • Izdevniecîba: Course Technology Inc
  • ISBN-10: 035767510X
  • ISBN-13: 9780357675106
Citas grâmatas par ðo tçmu:
Permanent link: https://www.kriso.lv/db/9780357675106.html
Keywords:
Including the latest Microsoft 365 features and enhanced support for Mac users, Cengage's Illustrated Series® Collection, Microsoft® Office 365® & Excel® 2021 Comprehensive, 1st edition, helps you quickly master the nuances of Microsoft® Office. Its concise, student-friendly approach uses a proven two-page layout that allows you to work through an entire task without turning the page. Each module begins with a brief overview of the principles covered while large, full-color screen images illustrate what you see on your computer. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, and module scenarios are based on Burning Glass market insights data -- helping you sharpen the critical skills you need for real-world success. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.
Getting to Know Microsoft Office Versions 1(1)
Using SAM Projects and Textbook Projects 1(1)
Excel 2021
Module 1 Getting Started with Excel
1(1)
Explore Excel
2(2)
Navigating a worksheet
Enter Data
4(2)
Inserting and deleting selected cells Using Auto Fill and Flash Fill
Edit Data
6(2)
Recovering unsaved changes to a workbook file
Copy and Move Cell Data
8(2)
Using Paste Options and Paste Preview
Enter Formulas and Use AutoSum
10(2)
Copy Formulas with Relative Cell References
12(2)
Inserting functions into formulas Copy Formulas with Absolute Cell References
14(2)
Using a mixed reference
Enter a Formula with Multiple Operators
16(2)
Insert a Function
18(2)
Switch Worksheet Views
20(2)
Choose Print Options
22(2)
Setting a print area Scaling to fit Practice
24
Module 2 Formatting a Worksheet
1(1)
Format Values
2(2)
Working with online pictures, other images, and symbols Change Font and Font Size
4(2)
Working with cell styles
Change Font Styles and Alignment
6(2)
Rotating and indenting cell entries
Adjust Column Width
8(2)
Changing row height
Insert and Delete Rows and Columns
10(2)
Hiding and unhiding columns and rows
Create and apply a template Apply Colors, Borders, and Documentatioa
12(2)
Checking worksheet accessibility Apply Conditional Formatting
14(2)
Formatting data with icon sets
Managing conditional formatting rules Rename and Move a Worksheet
16(2)
Copying, adding, and deleting worksheets Check Spelling
18(2)
Translating text
Using Find & Select features Practice
20
Module 3 Analyzing Data Using Formulas
1(1)
Enter a Formula Using the Quick Analysis Tool
2(2)
Build a Logical Formula with the IF Functioa
4(2)
Nesting IF functions
Build a Logical Formula with the AND Functioa
6(2)
Using the OR and NOT logical functions Round a Value with a Functioa
8(2)
Using Excel rounding functions
Build a Statistical Formula with the COUNTA Functioa
10(2)
Enter a Date Functioa
12(2)
Work with Equation Tools
14(2)
Using Draw tools
Control Worksheet Calculations
16(2)
Showing and printing worksheet formulas Practice
18
Module 4 Working with Charts
1(1)
Plan a Chart
2(2)
Create a Chart
4(2)
Move and Resize a Chart
6(2)
Change the Chart Desiga
8(2)
Creating a combo chart
Change the Chart Layout
10(2)
Working with chart axes
Format a Chart
12(2)
Working with WordArt Aligning charts
Create a Pie Chart
14(2)
Working with other chart types
Summarize Data with Sparklines
16(2)
Identify Data Trends
18(2)
Choosing the right trendline options for your chart Practice
20
Module 5 Working with Tables
1(1)
Create and Format a Table
2(2)
Changing table style options Add and Delete Table Data
4(2)
Selecting table elements
Sort Table Data
6(2)
Sorting conditional formatted data
Specifying a custom sort order
Use Formulas in a Table
8(2)
Filter a Table
10(2)
Using an advanced filter Look Up Values in a Table
12(2)
Using other LOOKUP functions
Summarize Table Data
14(2)
Validate Table Data
16(2)
Restricting cell values and data length
Adding input messages and error alerts Practice
18
Module 6 Managing Workbook Data
1(1)
View and Arrange Worksheets
2(2)
Splitting the worksheet into multiple panes Protect Worksheets and Workbooks
4(2)
Creating edit ranges
Freezing rows and columns Save Custom Views of a Worksheet
6(2)
Using Page Break Preview Prepare a Workbook for Distribution
8(2)
Adding a worksheet background
Insert Hyperlinks
10(2)
Save a Workbook for Distribution
12(2)
Exporting a workbook to other file types Work with Grouped Data
14(2)
Creating Subtotals
Work with Grouped Worksheets
16(2)
Practice
18
Module 7 Working with Images and Integrating with Other Programs
1(1)
Plan a Data Exchange
2(2)
Import a Text File
4(2)
Importing text files using the Text Import Wizard Import Data from Another Workbook
6(2)
Converting text to columns
Import a Database Table
8(2)
Link Worksheet Data to a Word Document
10(2)
Managing and breaking links
Link an Excel Chart to a PowerPoint Slide
12(2)
Import Excel Data into Access
14(2)
Adding SmartArt graphics Insert a Graphic File in a Worksheet
16(2)
Working with SmartArt graphics Practice
18
Module 8 Analyzing Data with PivotTables
1(1)
Plan and Design a PivotTable Report
2(2)
Create a PivotTable Report
4(2)
Changing a PivotTable layout Change a PivotTable's Summary Function and Design
6(2)
Using the Show buttons
Filter PivotTable Data
8(2)
Filtering PivotTables using multiple values Explore PivotTable Data Relationships
10(2)
Grouping PivotTable data
Create a PivotChart Report
12(2)
Update a PivotTable Report
14(2)
Adding a calculated field to a PivotTable and a PivotChart Use the GETPIVOTDATA Function
16(2)
Practice
18
Module 9 Automating Worksheet Tasks
1(1)
Plan a Macro
2(2)
Enable a Macro
4(2)
Adding security to your macro projects Disabling macros Record a Macro
6(2)
Run a Macro
8(2)
Running a macro automatically
Creating a main procedure Edit a Macro
10(2)
Using relative referencing when creating a macro Assign a Macro to a Button
12(2)
Copying a macro to another workbook Assign a Macro to a Command Button
14(2)
Working with ActiveX text boxes Assign a Macro to a Form Control
16(2)
Working with option buttons Practice
18
Module 10 Advanced Worksheet Management
1(1)
Create and Apply a Template
2(2)
Creating a new workbook using a template Import HTML Data
4(2)
Importing XML data
Importing HTML files directly into Excel
Create a Custom AutoFill List
6(2)
Work with Themes
8(2)
Work with Cell Comments
10(2)
Sharing Excel workbooks Customize an Excel Workbook
12(2)
Tracking changes in a workbook Encrypt a Workbook with a Password
14(2)
Working with a previous version of an Excel workbook Work with the Analyze Data Feature
16(2)
Working with Funnel charts Practice
18
Module 11 Advanced Formulas and Functions
1(1)
Separate Data Using Flash Fill
2(2)
Working with Excel series Format Data Using Text Functions
4(2)
Working with other text functions
Sum a Data Range Based on Conditions
6(2)
Find Values Based on Conditions
8(2)
Working with logical functions Construct Formulas Using Named Ranges
10(2)
Using formulas to conditionally format data Consolidate Worksheet Data
12(2)
Audit a Worksheet
14(2)
Watching formulas
Circling invalid data
Calculate Payments with the PMT Function
16(2)
Working with other financial functions Practice
18
Module 12 Performing What-lf Analysis
1(1)
Define What-lf Analysis
2(2)
Track What-lf Analysis with Scenario Manager
4(2)
Merging scenarios
Generate a Scenario Summary
6(2)
Project Figures Using a Data Table
8(2)
Creating a two-input data table
Use Goal Seek
10(2)
Predicting data trends with Forecast Sheet Find Solutions Using Solver
12(2)
Analyzing data using the Analysis ToolPak
Creating an Answer Report
Manage Data Using a Data Model
14(2)
Analyze Data Using Power Pivot
16(2)
Using the Excel 3D Maps tool Practice
18
Index 1
Lynn Wermers is a professor in the computer science department at North Shore Community College in Massachusetts, where she teaches IT, data management, data analysis and web development courses. She also teaches part time in the math department for the College of Professional Studies at Northeastern University. Wermers has authored numerous leading books focusing on Excel for Cengage.