Klientu atbalsts: 27018494

Grāmatu iegāde | Jauns profils | Ienākt

Bundle: Illustrated Microsoft Office 365 & Excel 2016: Comprehensive, Loose-Leaf Version plus Lms Integrated Sam 365 & 2016 Assessments, Trainings, and Projects with 1 Mindtap Reader Printed Access Card [Multiple-component retail product]

Lynn Wermers, Elizabeth Eisner Reding

Formāts: Multiple-component retail product, weight: 939 g, Illustrations, Contains 1 Other merchandise
Izdošanas datums: 15-Jun-2016
Izdevniecība: Cengage Learning
ISBN-10: 1337348244
ISBN-13: 9781337348249

Citas grāmatas par šo tēmu:

Graphical & digital media applications - (Noliktavā: 4 punkts)

Multiple-component retail product
Cena: 237,85 €
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:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Ielikt grozā
Piegādes laiks - 4-6 nedēļas
Pievienot vēlmju sarakstam

Formāts: Multiple-component retail product, weight: 939 g, Illustrations, Contains 1 Other merchandise
Izdošanas datums: 15-Jun-2016
Izdevniecība: Cengage Learning
ISBN-10: 1337348244
ISBN-13: 9781337348249

Citas grāmatas par šo tēmu:

Graphical & digital media applications - (Noliktavā: 4 punkts)

Permanent link: https://www.kriso.lv/db/9781337348249.html

Productivity Apps

Productivity Apps for School and Work

(1)

Introduction to OneNote 2016

(4)

Introduction to Sway

(4)

Introduction to Office Mix

(4)

Introduction to Microsoft Edge

Office 2016

Module 1 Getting Started with Microsoft Office 2016

(1)

Understand the Office 2016 Suite

(2)

What is Office 365? Start an Office App

(2)

Enabling touch mode Using shortcut keys to move between Office programs Using the Office Clipboard

Identify Office 2016 Screen Elements

(2)

Using Backstage view Create and Save a File

(2)

Saving files to OneDriveOpen a File and Save It with a New Name

(2)

Exploring File Open options

Working in Compatibility Mode View and Print Your Work

(2)

Customizing the Quick Access toolbar Creating a screen capture

Get Help, Close a File, and Exit an App

(2)

Using sharing features and co-authoring capabilities Recovering a document

Practice

Excel 2016

Module 1 Getting Started with Excel 2016

(24)

Understand Spreadsheet Software

(2)

Identify Excel 2016 Window Components

(2)

Using OneDrive and Office Online Understand Formulas

(2)

Enter Labels and Values and Use the AutoSum Button

(2)

Navigating a worksheet Edit Cell Entries

(2)

Recovering unsaved changes to a workbook file Enter and Edit a Simple Formula

(2)

Understanding named ranges Switch Worksheet Views

(2)

Choose Print Options

(2)

Printing worksheet formulas Scaling to fit Practice

(7)

Module 2 Working with Formulas and Functions

(26)

Create a Complex Formula

(2)

Using Add-ins to improve worksheet functionality Reviewing the order of precedence

Insert a Function

(2)

Type a Function

(2)

Using the COUNT and COUNTA functions

Copy and Move Cell Entries

(2)

Inserting and deleting selected cells

Understand Relative and Absolute Cell References

(2)

Using a mixed reference

Copy Formulas with Relative Cell References

(2)

Using Paste Preview

Copy Formulas with Absolute Cell References

(2)

Using the fill handle for sequential text or values

Round a Value with a Function

(2)

Using Auto Fill options

Creating a new workbook using a template Practice

(9)

Module 3 Formatting a Worksheet

(28)

Format Values

(2)

Formatting as a table

Change Font and Font Size

(2)

Inserting and adjusting online pictures and other images

Change Font Styles and Alignment

(2)

Rotating and indenting cell entries

Adjust Column Width

(2)

Changing row height

Insert and Delete Rows and Columns

(2)

Hiding and unhiding columns and rows Adding and editing comments

Apply Colors, Patterns, and Borders

(2)

Working with themes and cell styles

Apply Conditional Formatting

(2)

Managing conditional formatting rules

Rename and Move a Worksheet

(2)

Copying, adding, and deleting worksheets

Check Spelling

(11)

Emailing a workbook Practice

(9)

Module 4 Working with Charts

(26)

Plan a Chart

(2)

Create a Chart

(2)

Creating sparklines

Move and Resize a Chart

(2)

Moving an embedded chart to a sheet

Change the Chart Design

(2)

Creating a combo chart Working with a 3-D chart

Change the Chart Format

(2)

Adding data labels to a chart

Format a Chart

(2)

Previewing a chart Changing alignment and angle in axis labels and titles

Annotate and Draw on a Chart

(2)

Adding SmartArt graphics

Create a Pie Chart

(2)

Using the Insert Chart dialog box to discover new chart types

Practice

(9)

Module 5 Analyzing Data Using Formulas

105

(24)

Format Data Using Text Functions

106

(2)

Working with text in other ways

Sum a Data Range Based on Conditions

108

(2)

Entering date and time functions

Consolidate Data Using a Formula

110

(2)

Linking data between workbooks

Check Formulas for Errors

112

(2)

Correcting circular references

Construct Formulas Using Named Ranges

114

(2)

Consolidating data using named ranges Managing workbook names

Build a Logical Formula with the IF Function

116

(2)

Build a Logical Formula with the AND Function

118

(2)

Using the OR and NOT logical functions

Calculate Payments with the PMT Function

120

(2)

Calculating future value with the FV function Practice

122

(7)

Module 6 Managing Workbook Data

129

(24)

View and Arrange Worksheets

130

(2)

Splitting the worksheet into multiple panes

Protect Worksheets and Workbooks

132

(2)

Freezing rows and columns

Save Custom Views of a Worksheet

134

(2)

Using Page Break Preview

Add a Worksheet Background

136

(2)

Working with screenshots in Excel

Prepare a Workbook for Distribution

138

(2)

Sharing a workbook using OneDrive

Insert Hyperlinks

140

(2)

Working with Headers and Footers Using research tools

Save a Workbook for Distribution

142

(2)

Saving a workbook in other formats

Group Worksheets

144

(2)

Practice

146

(7)

Module 7 Managing Data Using Tables

153

(24)

Plan a Table

154

(2)

Create and Format a Table

156

(2)

Changing table style options

Add Table Data

158

(2)

Selecting table elements

Find and Replace Table Data

160

(2)

Using Find and Select features

Delete Table Data

162

(2)

Sort Table Data

164

(2)

Sorting conditionally formatted data

Specifying a custom sort order Use Formulas in a Table

166

(2)

Print a Table

168

(2)

Setting a print area Practice

170

(7)

Module 8 Analyzing Table Data

177

(24)

Filter a Table

178

(2)

Create a Custom Filter

180

(2)

Using more than one rule when conditionally formatting data

Filter a Table with the Advanced Filter

182

(2)

Saving time with conditional formatting

Extract Table Data

184

(2)

Understanding the criteria range and the copy-to location

Look Up Values in a Table

186

(2)

Using other LOOKUP functions

Summarize Table Data

188

(2)

Validate Table Data

190

(2)

Restricting cell values and data length Adding input messages and error alerts

Create Subtotals

192

(2)

Practice

194

(7)

Module 9 Automating Worksheet Tasks

201

(24)

Plan a Macro

202

(2)

Using a macro to filter table data

Enable a Macro

204

(2)

Disabling macros

Record a Macro

206

(2)

Run a Macro

208

(2)

Running a macro automatically

Edit a Macro

210

(2)

Adding comments to Visual Basic code

Assign Keyboard Shortcuts to Macros

212

(2)

Using relative referencing when creating a macro

Use the Personal Macro Workbook

214

(2)

Working with the Personal Macro Workbook

Assign a Macro to a Button

216

(2)

Creating and formatting a form control

Practice

218

(7)

Module 10 Enhancing Charts

225

(24)

Customize a Data Series

226

(2)

Adding width and depth to data series

Change a Data Source and Add a Chart Style

228

(2)

Add Chart Elements

230

(2)

Formatting legends

Format Chart Axes

232

(2)

Create a Combination Chart

234

(2)

Charting data accurately

Enhance a Chart

236

(2)

Working with hierarchical, waterfall, and statistical charts

Summarize Data with Sparklines

238

(2)

Identify Data Trends

240

(2)

Choosing the right trendline options for your chart

Practice

242

(7)

Module 11 Performing What-if Analysis

249

(24)

Define What-if Analysis

250

(2)

Track What-if Analysis with Scenario Manager

252

(2)

Merging scenarios

Generate a Scenario Summary

254

(2)

Project Figures Using a Data Table

256

(2)

Creating a two-input data table

Use Goal Seek

258

(2)

Using Excel's Data Analysis tools

Set up a Complex What-if Analysis with Solver

260

(2)

Run Solver and Summarize Results

262

(2)

Understanding Answer Reports

Analyze Data Using the Analysis ToolPak

264

(2)

Predicting data trends with Forecast Sheet

Practice

266

(7)

Module 12 Analyzing Data with PivotTables

273

(24)

Plan and Design a PivotTable Report

274

(2)

Create a PivotTable Report

276

(2)

Changing the PivotTable layout

Change a PivotTable's Summary Function and Design

278

(2)

Using the Show buttons

Filter and Sort PivotTable Data

280

(2)

Filtering PivotTables using multiple values

Update a PivotTable Report

282

(2)

Grouping PivotTable data

Adding a calculated field to a PivotTable

Explore PivotTable Data Relationships

284

(2)

Creating relationships with Power Pivot

Create a PivotChart Report

286

(2)

Use the GETPIVOTDATA Function

288

(2)

Practice

290

(7)

Module 13 Exchanging Data with Other Programs

297

(24)

Plan a Data Exchange

298

(2)

Import a Text File

300

(2)

Importing text files using other methods

Import a Database Table

302

(2)

Insert a Graphic File in a Worksheet

304

(2)

Formatting SmartArt graphics

Embed a Workbook in a Word Document

306

(2)

Link a Workbook to a Word Document

308

(2)

Managing links

Link an Excel Chart to a PowerPoint Slide

310

(2)

Import a Table into Access

312

(2)

Practice

314

(7)

Module 14 Sharing Excel Files and Incorporating Web Information

321

(24)

Share Excel Files

322

(2)

Set Up a Shared Workbook for Multiple Users

324

(2)

Working with Office add-ins Merging workbooks

Track Revisions in a Shared Workbook

326

(2)

Apply and Modify Passwords

328

(2)

Creating strong passwords for Excel workbooks

Work with XML Schemas

330

(2)

Learning more about XML

Import and Export XML Data

332

(2)

Importing XML data without a schema

Share Web Links

334

(2)

Creating your own web queries

Import and Export HTML Data

336

(2)

Adding web hyperlinks to a worksheet

Practice

338

(7)

Module 15 Customizing Excel and Advanced Worksheet Management

345

(24)

Audit a Worksheet

346

(2)

Watching and evaluating formulas

Control Worksheet Calculations

348

(2)

Group Worksheet Data

350

(2)

Applying and viewing advanced workbook properties

Work with Cell Comments

352

(2)

Working with Excel files

Create a Custom AutoFill List

354

(2)

Create and Apply a Template

356

(2)

Customize an Excel Workbook

358

(2)

Customize the Excel Screen

360

(2)

Customizing the Quick Access Toolbar

Practice

362

(7)

Module 16 Programming with Excel

369

(1)

View VBA Code

370

(2)

Understanding the Visual Basic Editor

Analyze VBA Code

372

(2)

Write VBA Code

374

(2)

Entering code using AutoComplete

Add a Conditional Statement

376

(2)

Prompt the User for Data

378

(2)

Naming variables

Debug a Macro

380

(2)

Adding security to your macro projects

Create a Main Procedure

382

(2)

Copying a macro to another workbook Writing and documenting VBA code

Run a Main Procedure

384

(2)

Running a macro using a button

Practice

386

Glossary

(8)

Index

Bundle: Illustrated Microsoft Office 365 & Excel 2016: Comprehensive, Loose-Leaf Version plus Lms Integrated Sam 365 & 2016 Assessments, Trainings, and Projects with 1 Mindtap Reader Printed Access Card [Multiple-component retail product]

Konts un iestatījumi

Meklēšana

Meklēt datubāzē

Refine By

Tēmas Grāmatas angļu valodā

Izvēlieties iepirkumu grozu