Microsoft Office 365 Excel 2021 comprehensive

Cengage Learning 2023ISBN:

9780357676974

Existencias
Imagen de cubierta	Tipo de ítem	Biblioteca actual	Biblioteca de origen	Colección	Ubicación en estantería	Signatura topográfica	Materiales especificados	Info Vol	URL	Copia número	Estado	Notas	Fecha de vencimiento	Código de barras	Reserva de ítems	Prioridad de la cola de reserva de ejemplar	Reservas para cursos
	Libro	Biblioteca Mons. Iñaki Mallona (Arecibo)								Ej.	Disponible

Total de reservas: 0

Descripciones mejoradas de Syndetics:

Helping you quickly get up to speed, THE SHELLY CASHMAN SERIES® MICROSOFT® OFFICE 365® & EXCEL® 2021 COMPREHENSIVE 1st edition, includes the latest on Microsoft 365 and Office 2021 features along with enhanced support for Mac users. Its trademark step-by-step, screen-by-screen, project-based approach enables you to expand your understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, reinforcing the critical skills needed for college and career success. Other Ways boxes reveal alternate click paths to achieve a step, while BTW call-outs offer helpful hints as you work through your projects so you can make the most of Microsoft Office tools. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.

Tabla de contenidos provista por Syndetics

Getting to Know Microsoft Office Versions(p. OFF-1)
Using SAM Projects and Textbook Projects(p. SAM-1)
Microsoft Excel 2021
Module 1 Creating a Worksheet and a Chart
Objectives(p. EX 1-1)
Introduction(p. EX 1-1)
Project: Real Estate Budget Worksheet and Chart(p. EX 1-1)
Starting and Using Excel(p. EX 1-4)
What Is Excel?(p. EX 1-4)
To Start Excel and Create a Blank Workbook(p. EX 1-5)
The Excel Window(p. EX 1-7)
To Display a Different Tab on the Ribbon(p. EX 1-12)
Selecting a Cell(p. EX 1-12)
Entering Text(p. EX 1-12)
To Enter the Worksheet Titles(p. EX 1-13)
AutoCorrect(p. EX 1-15)
To Enter Column Titles(p. EX 1-15)
To Enter Row Titles(p. EX 1-17)
Entering Numbers(p. EX 1-18)
To Enter Numbers(p. EX 1-18)
Calculating Sums and Using Formulas(p. EX 1-20)
To Sum a Column of Numbers(p. EX 1-20)
Using the Fill Handle to Copy a Cell to Adjacent Cells(p. EX 1-21)
To Copy a Cell to Adjacent Cells in a Row(p. EX 1-22)
To Calculate Multiple Totals at the Same Time(p. EX 1-24)
Calculating Average, Maximum, and Minimum Values(p. EX 1-25)
To Enter a Formula Using the Keyboard(p. EX 1-26)
To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle(p. EX 1-27)
Saving the Project(p. EX 1-27)
To Save a Workbook(p. EX 1-28)
Formatting the Worksheet(p. EX 1-30)
Font Style, Size, and Color(p. EX 1-32)
To Change a Cell Style(p. EX 1-32)
To Change the Font(p. EX 1-34)
To Apply Bold Style to a Cell(p. EX 1-35)
To Increase the Font Size of a Cell Entry(p. EX 1-36)
To Change the Font Color of a Cell Entry(p. EX 1-37)
To Center Cell Entries across Columns by Merging Cells(p. EX 1-38)
To Format Rows Using Cell Styles(p. EX 1-39)
To Format Numbers in the Worksheet(p. EX 1-41)
To Adjust the Column Width(p. EX 1-42)
To Use the Name Box to Select a Cell(p. EX 1-44)
Other Ways to Select Cells(p. EX 1-44)
Adding a Pie Chart to the Worksheet(p. EX 1-45)
To Add a Pie Chart(p. EX 1 -46)
To Apply a Style to a Chart(p. EX 1-48)
Changing the Sheet Tab Names and Colors(p. EX 1-49)
To Move a Chart to a New Sheet(p. EX 1-49)
To Change the Sheet Tab Name and Color(p. EX 1-50)
Document Properties(p. EX 1-51)
Printing a Worksheet(p. EX 1-52)
To Preview and Print a Worksheet in Landscape Orientation(p. EX 1-53)
Viewing Automatic Calculations(p. EX 1-56)
To Use the AutoCalculate Area to Determine a Maximum(p. EX 1-56)
Correcting Errors(p. EX 1-57)
Correcting Errors while Entering Data into a Cell(p. EX 1-57)
Correcting Errors after Entering Data into a Cell(p. EX 1-57)
Undoing the Last Cell Entry(p. EX 1-59)
Clearing a Cell or Range of Cells(p. EX 1-59)
Clearing the Entire Worksheet(p. EX 1-60)
Using Excel Help(p. EX 1-60)
To Obtain Help Using the Search Text Box(p. EX 1-61)
Obtaining Help while Working in an Office App(p. EX 1-63)
To Obtain Help Using the Search Box(p. EX 1-63)
To Save a Workbook with a Different File Name(p. EX 1-64)
To Sign Out of a Microsoft Account(p. EX 1 -64)
Summary(p. EX 1-65)
Apply Your Knowledge(p. EX 1-66)
Extend Your Knowledge(p. EX 1-68)
Expand Your World(p. EX 1-69)
In the Lab(p. EX 1-69)
Module 2 Formulas, Functions, and Formatting
Objectives(p. EX 2-1)
Introduction(p. EX 2-1)
Project: Worksheet with Formulas and Functions(p. EX 2-2)
Entering the Titles and Numbers into the Worksheet(p. EX 2-4)
To Enter the Worksheet Title and Subtitle(p. EX 2-4)
To Enter the Column Titles(p. EX 2-5)
To Enter the Salary Data(p. EX 2-5)
Flash Fill(p. EX 2-6)
To Use Flash Fill(p. EX 2-7)
To Enter the Row Titles(p. EX 2-8)
To Change the Sheet Tab Name and Color(p. EX 2-8)
Entering Formulas(p. EX 2-9)
To Enter a Formula Using the Keyboard(p. EX 2-9)
Arithmetic Operations(p. EX 2-10)
Order of Operations(p. EX 2-10)
To Enter Formulas Using Point Mode(p. EX 2-11)
To Copy Formulas Using the Fill Handle(p. EX 2-13)
Option Buttons(p. EX 2-14)
To Determine Totals Using the AutoSum Button(p. EX 2-14)
To Determine the Total Tax Percentage(p. EX 2-15)
Using the AVERAGE, MAX, MIN, and Other Statistical Functions(p. EX 2-16)
To Determine the Highest Number in a Range of Numbers Using the Insert Function Dialog Box(p. EX 2-16)
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu(p. EX 2-18)
To Determine the Average of a Range of Numbers Using the Keyboard(p. EX 2-20)
To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle(p. EX 2-21)
Verifying Formulas Using Range Finder(p. EX 2-22)
To Verify a Formula Using Range Finder(p. EX 2-22)
Formatting the Worksheet(p. EX 2-23)
To Change the Workbook Theme(p. EX 2-24)
To Format the Worksheet Titles(p. EX 2-25)
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle(p. EX 2-26)
To Apply a Cell Style to the Column Headings and Format the Total Rows(p. EX 2-27)
To Format Dates and Center Data in Cells(p. EX 2-28)
To Apply an Accounting Number Format and Comma Style Format Using the Ribbon(p. EX 2-29)
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box(p. EX 2-30)
To Apply a Percent Style Format and Use the Increase Decimal Button(p. EX 2-31)
Conditional Formatting(p. EX 2-31)
To Apply Conditional Formatting(p. EX 2-32)
Conditional Formatting Operators(p. EX 2-34)
Changing Column Width and Row Height(p. EX 2-35)
To Change Column Width(p. EX 2-35)
To Change Row Height(p. EX 2-38)
Checking Spelling(p. EX 2-39)
To Check Spelling on the Worksheet(p. EX 2-40)
Additional Spelling Checker Considerations(p. EX 2-41)
Printing the Worksheet(p. EX 2-41)
To Change the Worksheet's Margins, Header, and Orientation in Page Layout View(p. EX 2-42)
To Print a Worksheet(p. EX 2-44)
To Print a Section of the Worksheet(p. EX 2-45)
Displaying and Printing the Formulas Version of the Worksheet(p. EX 2-46)
To Display the Formulas in the Worksheet and Fit the Printout on One Page(p. EX 2-47)
To Change the Print Scaling Option Back to 100%(p. EX 2-48)
Summary(p. EX 2-49)
Apply Your Knowledge(p. EX 2-50)
Extend Your Knowledge(p. EX 2-51)
Expand Your World(p. EX 2-52)
In the Lab(p. EX 2-53)
Module 3 Working with targe Worksheets, Charting, and What-If Analysis
Objectives(p. EX 3-1)
Introduction(p. EX 3-1)
Project: Financial Projection Worksheet with What-If Analysis and Chart(p. EX 3-2)
To Enter the Worksheet Titles and Apply a Theme(p. EX 3-5)
Rotating Text and Using the Fill Handle to Create a Series(p. EX 3-5)
To Rotate Text in a Cell(p. EX 3-5)
To Use the Fill Handle to Create a Series of Month Names(p. EX 3-7)
Using the Auto Fill Options Menu(p. EX 3-8)
To Increase Column Widths(p. EX 3-9)
To Enter and Indent Row Titles(p. EX 3-10)
Copying a Range of Cells to a Nonadjacent Destination Area(p. EX 3-10)
To Copy a Range of Cells to a Nonadjacent Destination Area(p. EX 3-11)
Using the Paste Options Menu(p. EX 3-12)
Using Drag and Drop to Move or Copy Cells(p. EX 3-12)
Using Cut and Paste to Move Cells(p. EX 3-13)
Inserting and Deleting Cells in a Worksheet(p. EX 3-13)
To Insert a Row(p. EX 3-14)
Inserting Columns(p. EX 3-15)
Inserting Single Cells or a Range of Cells(p. EX 3-15)
Deleting Columns and Rows(p. EX 3-16)
To Enter Numbers with Format Symbols(p. EX 3-16)
To Enter the Projected Monthly Sales(p. EX 3-17)
To Enter and Format the System Date(p. EX 3-18)
Absolute versus Relative Addressing(p. EX 3-20)
To Enter a Formula Containing Absolute Cell References(p. EX 3-22)
Making Decisions-The IF Function(p. EX 3-24)
To Enter an IF Function(p. EX 3-25)
To Enter the Remaining Formulas for January(p. EX 3-26)
To Copy Formulas with Absolute Cell References Using the Fill Handle(p. EX 3-27)
To Determine Row Totals in Nonadjacent Cells(p. EX 3-28)
Nested Forms of the IF Function(p. EX 3-29)
Adding and Formatting Sparkline Charts(p. EX 3-30)
To Add a Sparkline Chart to the Worksheet(p. EX 3-30)
To Change the Sparkline Style and Copy the Sparkline Chart(p. EX 3-31)
To Change the Sparkline Type(p. EX 3-32)
Customizing Sparkline Charts(p. EX 3-33)
Formatting the Worksheet(p. EX 3-33)
To Assign Formats to Nonadjacent Ranges(p. EX 3-34)
To Format the Worksheet Titles(p. EX 3-36)
To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell(p. EX 3-37)
To Copy a Cell's Format Using the Format Painter Button(p. EX 3-38)
To Format the What-If Assumptions Table(p. EX 3-39)
Adding a Clustered Column Chart to the Workbook(p. EX 3-39)
To Draw a Clustered Column Chart on a Separate Chart Sheet Using the Recommended Charts Feature(p. EX 3-40)
To Insert a Chart Title(p. EX 3-42)
To Add Data Labels(p. EX 3-42)
To Apply Chart Filters(p. EX 3-43)
To Add an Axis Title to the Chart(p. EX 3-44)
To Change the Chart Style(p. EX 3-45)
To Modify the Chart Axis Number Format(p. EX 3-46)
To Remove Filters and Data Labels(p. EX 3-47)
Organizing the Workbook(p. EX 3-48)
To Rename and Color Sheet Tabs(p. EX 3-48)
To Reorder the Sheet Tabs(p. EX 3-48)
To Check Spelling in Multiple Sheets(p. EX 3-49)
To Preview and Print the Worksheet(p. EX 3-49)
Changing the View of the Worksheet(p. EX 3-50)
To Shrink and Magnify the View of a Worksheet or Chart(p. EX 3-50)
To Split a Window into Panes(p. EX 3-52)
To Remove the Panes from the Window(p. EX 3-53)
To Freeze Worksheet Columns and Rows(p. EX 3-53)
To Unfreeze the Worksheet Columns and Rows(p. EX 3-55)
What-If Analysis(p. EX 3-55)
To Analyze Data in a Worksheet by Changing Values(p. EX 3-55)
Goal Seeking(p. EX 3-56)
To Goal Seek(p. EX 3-56)
Insights(p. EX 3-58)
To Use the Smart Lookup insight(p. EX 3-58)
Accessibility Features(p. EX 3-59)
Summary(p. EX 3-60)
Apply Your Knowledge(p. EX 3-61)
Extend Your Knowledge(p. EX 3-62)
Expand Your World(p. EX 3-64)
In the Lab(p. EX 3-65)
Module 4 Financial Functions, Data Tables, and Amortization Schedules
Objectives(p. EX 4-1)
Introduction(p. EX 4-1)
Project: Mortgage Payment Calculator with Data Table and Amortization Schedule(p. EX 4-2)
To Apply a Theme to the Worksheet(p. EX 4-4)
To Enter the Section and Row Titles and System Date(p. EX 4-4)
To Adjust the Column Widths and Row Heights(p. EX 4-5)
To Change the Sheet Tab Name(p. EX 4-6)
Creating Cell Names(p. EX 4-6)
To Format Cells before Entering Values(p. EX 4-6)
To Enter the Loan Data(p. EX 4-7)
To Create Names Based on Row Titles(p. EX 4-8)
To Enter the Loan Amount Formula Using Names(p. EX 4-9)
The PMT Function(p. EX 4-10)
To Enter the PMT Function(p. EX 4-11)
Other Financial Functions(p. EX 4-12)
To Determine the Total Interest and Total Cost(p. EX 4-13)
To Enter New Loan Data(p. EX 4-13)
To Enter the Original Loan Data(p. EX 4-14)
Using a Data Table to Analyze Worksheet Data(p. EX 4-15)
To Enter the Data Table Title and Column Titles(p. EX 4-16)
To Create a Percentage Series Using the Fill Handle(p. EX 4-16)
To Enter the Formulas in the Data Table(p. EX 4-18)
To Define a Range as a Data Table(p. EX 4-19)
More about Data Tables(p. EX 4-20)
Creating an Amortization Schedule(p. EX 4-20)
To Change Column Widths and Enter Titles(p. EX 4-21)
To Create a Series of Integers Using the Fill Handle(p. EX 4-22)
Formulas in the Amortization Schedule(p. EX 4-23)
To Enter the Formulas in the Amortization Schedule(p. EX 4-24)
To Copy the Formulas to Fill the Amortization Schedule(p. EX 4-26)
To Enter the Total Formulas in the Amortization Schedule(p. EX 4-27)
To Format the Numbers in the Amortization Schedule(p. EX 4-28)
Formatting the Worksheet(p. EX 4-29)
To Add Custom Borders to a Range(p. EX 4-29)
To Add Borders to the Varying Interest Rate Schedule(p. EX 4-31)
To Add Borders to the Amortization Schedule(p. EX 4-32)
To Use Borders and Fill Color to Visually Define and Group the Financial Tools(p. EX 4-33)
Highlighting Cells in the Data Table Using Conditional Formatting(p. EX 4-33)
To Add a Pointer to the Data Table Using Conditional Formatting(p. EX 4-34)
To Enter New Loan Data(p. EX 4-36)
To Enter the Original Loan Data(p. EX 4-36)
Printing Sections of the Worksheet(p. EX 4-37)
To Set Up a Worksheet to Print(p. EX 4-37)
To Set the Print Area(p. EX 4-38)
To Name and Print Sections of a Worksheet(p. EX 4-38)
Creating Formulas with Defined Names(p. EX 4-41)
Protecting and Hiding Worksheets and Workbooks(p. EX 4-41)
To Protect a Worksheet(p. EX 4-42)
More about Worksheet Protection(p. EX 4-44)
To Hide and Unhide a Worksheet(p. EX 4-44)
To Hide and Unhide a Workbook(p. EX 4-45)
Formula Checking(p. EX 4-46)
To Enable Background Formula Checking(p. EX 4-47)
More about Background Formula Checking(p. EX 4-48)
Summary(p. EX 4-49)
Apply Your Knowledge(p. EX 4-50)
Extend Your Knowledge(p. EX 4-51)
Expand Your World(p. EX 4-53)
In the Lab(p. EX 4-54)
Module 5 Working with Multiple Worksheets and Workbooks
Objectives(p. EX 5-1)
Introduction(p. EX 5-1)
Project: Consolidated Expenses Worksheet(p. EX 5-2)
Creating the Consolidated Worksheet(p. EX 5-4)
To Start Excel and Open a File(p. EX 5-4)
To Format the Worksheet(p. EX 5-5)
To Enter Column Titles(p. EX 5-6)
Fill Series(p. EX 5-6)
To Create Linear Series(p. EX 5-6)
Date, Time, and Round Functions(p. EX 5-8)
To Use the TODAY Function(p. EX 5-10)
To Enter Formulas Using the ROUND Function(p. EX 5-11)
To Format the Title and Subtitle(p. EX 5-14)
To Format the Column Titles and Total Row(p. EX 5-15)
To Format with a Floating Dollar Sign(p. EX 5-15)
Format Codes(p. EX 5-16)
To Create a Custom Format Code(p. EX 5-17)
To Format with the Comma Style(p. EX 5-19)
Creating a Cell Style(p. EX 5-19)
To Create a New Cell Style(p. EX 5-20)
To Apply a New Style(p. EX 5-22)
To Use the Spelling Checker(p. EX 5-23)
Working with Multiple Worksheets(p. EX 5-23)
To Add a Worksheet to a Workbook(p. EX 5-24)
To Copy and Paste from One Worksheet to Another(p. EX 5-24)
To Copy a Worksheet Using a Shortcut Menu(p. EX 5-25)
To Copy a Worksheet Using CTRL(p. EX 5-26)
To Drill an Entry through Worksheets(p. EX 5-27)
Selecting and Deselecting Sheets(p. EX 5-28)
Customizing the Individual Worksheets(p. EX 5-28)
To Modify the Lady Lobster Worksheet(p. EX 5-28)
To Modify the Henry Haddock Sheet(p. EX 5-29)
To Modify the Sharon Shrimp Worksheet(p. EX 5-30)
Referencing Cells Across Worksheets(p. EX 5-31)
To Modify the Consolidated Worksheet(p. EX 5-32)
To Enter a 3-D Reference(p. EX 5-32)
To Use the Paste Gallery(p. EX 5-34)
Formatting Pie Charts(p. EX 5-35)
To Insert a 3-D Pie Chart on a Worksheet(p. EX 5-36)
To Move a Chart on the Same Worksheet(p. EX 5-36)
To Resize a Chart(p. EX 5-37)
To Explode a Slice(p. EX 5-38)
To Rotate the 3-D Pie Chart(p. EX 5-39)
To Format Data Labels(p. EX 5-39)
To Add a Chart Border(p. EX 5-42)
Printing Multiple Worksheets(p. EX 5-43)
To Change Margins and Center the Printout Horizontally(p. EX 5-43)
To Add a Header(p. EX 5-44)
To Add a Footer(p. EX 5-45)
To Preview and Print All Worksheets in a Workbook(p. EX 5-46)
Creating Separate Files from Worksheets(p. EX 5-48)
To Create a Separate File from a Worksheet(p. EX 5-48)
Consolidating Data by Linking Separate Workbooks(p. EX 5-49)
Moving Linked Workbooks(p. EX 5-49)
To Open a Data File and Save It to a New Location(p. EX 5-50)
To Search for and Open Workbooks(p. EX 5-50)
To Switch to a Different Open Workbook(p. EX 5-51)
To Arrange Multiple Workbooks(p. EX 5-52)
To Hide Workbooks(p. EX 5-53)
To Consolidate Data by Linking Workbooks(p. EX 5-54)
To Close All Workbooks at One Time(p. EX 5-57)
Summary(p. EX 5-57)
Apply Your Knowledge(p. EX 5-58)
Consolidating Payroll Worksheets(p. EX 5-58)
Extend Your Knowledge(p. EX 5-60)
Creating and Editing Custom Format Codes(p. EX 5-60)
Consolidating and Charting Weather Data in a Workbook(p. EX 5-61)
In the Lab(p. EX 5-62)
Module 6 Creating, Sorting, and Querying a Table
Objectives(p. EX 6-1)
Introduction(p. EX 6-1)
Project: Rating Bank Account Managers(p. EX 6-2)
To Open and Save a File(p. EX 6-6)
Table Guidelines(p. EX 6-7)
Creating a Table(p. EX 6-7)
To Format a Range as a Table(p. EX 6-8)
To Wrap Text(p. EX 6-9)
To Name the Table(p. EX 6-10)
To Remove Duplicates(p. EX 6-10)
To Enter New Rows and Records into a Table(p. EX 6-11)
To Add New Columns to the Table(p. EX 6-12)
To Center Across Selection(p. EX 6-13)
Using a Lookup Table(p. EX 6-14)
To Create an Area for Lookup and Return Arrays(p. EX 6-15)
To Use the XLOOKUP Function(p. EX 6-16)
Adding Calculated Fields to the Table(p. EX 6-17)
To Create Calculated Fields(p. EX 6-17)
Conditional Formatting(p. EX 6-19)
To Add a Conditional Formatting Rule with an Icon Set(p. EX 6-20)
Finding Duplicates with Conditional Formatting(p. EX 6-22)
Data Bars(p. EX 6-22)
Working with Tables in Excel(p. EX 6-22)
To Insert a Total Row(p. EX 6-22)
To Print the Table(p. EX 6-24)
Sorting a Table(p. EX 6-25)
To Sort Ascending(p. EX 6-26)
To Sort Descending(p. EX 6-27)
To Custom Sort a Table(p. EX 6-27)
Querying a Table Using AutoFilter(p. EX 6-30)
To Sort a Table Using AutoFilter(p. EX 6-30)
To Query a Table Using AutoFilter(p. EX 6-31)
To Remove Filters(p. EX 6-32)
To Search a Table Using AutoFilter(p. EX 6-33)
To Enter Custom Criteria Using AutoFilter(p. EX 6-34)
More about AutoFilters(p. EX 6-36)
To Turn Off AutoFilter(p. EX 6-36)
Using Criteria and Extract Ranges(p. EX 6-37)
To Create a Criteria Range(p. EX 6-37)
To Query Using a Criteria Range(p. EX 6-38)
To Create an Extract Range(p. EX 6-39)
To Extract Records(p. EX 6-40)
More about the Criteria Range(p. EX 6-41)
Using Database Functions(p. EX 6-41)
To Create an Output Area(p. EX 6-42)
To Use the DAVE RAGE and DCOUNT Database Functions(p. EX 6-43)
Using the SUMIF, COUNTIF, MATCH, and INDEX Functions(p. EX 6-44)
To Use the SUMIF Function(p. EX 6-44)
To Use the COUNTIF Functions(p. EX 6-45)
To Use the MATCH and INDEX Functions(p. EX 6-46)
Other Functions(p. EX 6-47)
Summarizing Data(p. EX 6-47)
To Sort the Data(p. EX 6-48)
To Convert a Table to a Range(p. EX 6-48)
To Display Subtotals(p. EX 6-48)
To Use the Outline Feature(p. EX 6-49)
Auto Outline(p. EX 6-50)
To Remove Automatic Subtotals(p. EX 6-50)
Treemap Charts(p. EX 6-51)
To Create a Treemap Chart(p. EX 6-51)
To Move the Chart and Edit Fonts(p. EX 6-52)
To Edit Treemap Settings(p. EX 6-53)
More about Data Series(p. EX 6-55)
Summary(p. EX 6-55)
Apply Your Knowledge(p. EX 6-56)
Extend Your Knowledge(p. EX 6-58)
Expand Your World(p. EX 6-59)
In the Lab(p. EX 6-60)
Module 7 Creating Templates, Importing Data, and Working with Smart Art, Images, and Screenshots
Objectives(p. EX 7-1)
Introduction(p. EX 7-1)
Project: Meyor Insurance(p. EX 7-2)
Creating Templates(p. EX 7-5)
To Open a Blank Workbook and Format the Rows and Columns(p. EX 7-5)
To Enter Titles in the Template(p. EX 7-6)
To Enter Column Titles in the Template(p. EX 7-7)
To Enter Sample Data in the Template(p. EX 7-7)
To Enter Formulas and Functions in the Template(p. EX 7-8)
To Save the Template(p. EX 7-9)
To Open a Template-Based File and Save It as a Workbook(p. EX 7-11)
Importing Data(p. EX 7-12)
Text Files(p. EX 7-14)
To Import Data from a Text File(p. EX 7-14)
To Format the CSV Data(p. EX 7-16)
Text Formatting(p. EX 7-17)
To Use the Trim Function(p. EX 7-18)
To Paste Values Only(p. EX 7-19)
Access Files(p. EX 7-20)
To Import Data from an Access Table(p. EX 7-20)
To Delete a Column Using Power Query(p. EX 7-22)
To Format the Access Data(p. EX 7-24)
Web Data(p. EX 7-24)
To Import Data from a Webpage(p. EX 7-24)
Using Word Data(p. EX 7-27)
To Copy from Word and Paste to Excel(p. EX 7-28)
To Transpose Columns and Rows(p. EX 7-28)
To Delete, Cut, and Paste Data(p. EX 7-29)
To Convert Text to Columns(p. EX 7-30)
To Replicate Formulas(p. EX 7-31)
Using the Quick Analysis Gallery(p. EX 7-33)
To Format Using the Quick Analysis Gallery(p. EX 7-33)
To Total Data(p. EX 7-34)
Using the Find and Replace Commands(p. EX 7-35)
To Find Data(p. EX 7-35)
Working with the Find and Replace Dialog Box(p. EX 7-37)
To Find and Replace(p. EX 7-37)
To Format Styles and Borders(p. EX 7-38)
Inserting a Bar Chart(p. EX 7-39)
To Insert a Chart Using the Quick Analysis Gallery(p. EX 7-40)
To Format the Chart(p. EX 7-41)
To Format Axis Options(p. EX 7-44)
To Add Data Labels(p. EX 7-45)
To Display a Data Table(p. EX 7-46)
To Format the Chart Title(p. EX 7-46)
Working with SmartArt Graphics(p. EX 7-47)
To Create a New Sheet(p. EX 7-48)
To Insert a SmartArt Graphic(p. EX 7-49)
To Color and Resize the SmartArt Graphic(p. EX 7-50)
To Add a Shape to a SmartArt Graphic(p. EX 7-51)
To Add Text to a SmartArt Graphic(p. EX 7-51)
To Add a Style to a SmartArt Graphic(p. EX 7-52)
Pictures and Icons(p. EX 7-53)
To Add a Picture to a SmartArt Graphic(p. EX 7-54)
To Apply Picture Effects(p. EX 7-56)
To Insert Icons(p. EX 7-58)
To Format Text Using WordArt Styles(p. EX 7-60)
Text Boxes(p. EX 7-61)
To Draw a Text Box(p. EX 7-61)
Alternative Text(p. EX 7-62)
To Add ALT Text(p. EX 7-62)
Object Linking and Embedding(p. EX 7-63)
Copy and Paste(p. EX 7-64)
Embedded Objects(p. EX 7-64)
Linked Objects(p. EX 7-64)
Using Screenshots on a Worksheet(p. EX 7-66)
To Create Another New Sheet(p. EX 7-66)
To Insert a Screenshot on a Worksheet(p. EX 7-67)
To Move an Object(p. EX 7-69)
To Add a Picture Border(p. EX 7-69)
Shapes(p. EX 7-71)
To Create a Shape and Copy It(p. EX 7-71)
To Add a Shape Style and Shape Effect(p. EX 7-72)
Using the Format Painter with Objects(p. EX 7-74)
To Align Shapes(p. EX 7-75)
Summary(p. EX 7-76)
Apply Your Knowledge(p. EX 7-77)
Extend Your Knowledge(p. EX 7-79)
Expand Your World(p. EX 7-81)
In the Lab(p. EX 7-82)
Module 8 Working with Trendlines, PivotTables, PivotCharts, and Slicers
Objectives(p. EX 8-1)
Introduction(p. EX 8-1)
Project: Bell & Rodgers Accounting(p. EX 8-1)
To Start Excel and Open a Workbook(p. EX 8-4)
Line Charts and Trendlines(p. EX 8-4)
To Create a 2-D Line Chart(p. EX 8-5)
To Format a 2-D Line Chart(p. EX 8-7)
To Add a Trendline to a Chart(p. EX 8-8)
To Change the Theme(p. EX 8-10)
More about Trendlines(p. EX 8-11)
To Change the Format of a Data Point(p. EX 8-11)
Creating and Formatting PivotTable Reports(p. EX 8-13)
To Create a Blank PivotTable(p. EX 8-14)
To Add Data to the PivotTable(p. EX 8-15)
To Change the Layout of a PivotTable(p. EX 8-16)
To Change the View of a PivotTable Report(p. EX 8-18)
To Filter a PivotTable Report Using a Report Filter(p. EX 8-18)
To Filter a PivotTable Report Using Multiple Selection Criteria(p. EX 8-19)
To Remove a Report Filter from a PivotTable Report(p. EX 8-21)
To Remove and Add Data to the PivotTable Report(p. EX 8-21)
To Filter a PivotTable Report Using the Row Label Filter(p. EX 8-21)
To Clear the Filter(p. EX 8-22)
Formatting PivotTable Reports(p. EX 8-23)
To Format a PivotTable Report(p. EX 8-24)
Summary Functions(p. EX 8-26)
To Switch Summary Functions(p. EX 8-26)
To Insert a New Summary Function(p. EX 8-28)
To Customize the Field Headers and Field List(p. EX 8-29)
To Expand and Collapse Categories(p. EX 8-31)
To Create a Title(p. EX 8-32)
To Update a PivotTable(p. EX 8-33)
To Drill Down into PivotTable(p. EX 8-34)
Creating and Formatting PivotChart Reports(p. EX 8-35)
To Create a PivotChart Report from an Existing PivotTable Report(p. EX 8-35)
To Move the PivotChart Report(p. EX 8-36)
To Remove Fields(p. EX 8-35)
To Change the PivotChart Type and Reset Chart Elements(p. EX 8-37)
To Change the View of a PivotChart Report(p. EX 8-40)
To Create a PivotChart and PivotTable Directly from Data(p. EX 8-42)
To Create a Calculated Field to a PivotTable Report(p. EX 8-44)
To Format the PivotTable(p. EX 8-45)
To Format the PivotChart(p. EX 8-46)
More About PivotCharts(p. EX 8-47)
Working with Slicers(p. EX 8-47)
To Copy a PivotTable and PivotChart(p. EX 8-48)
To Add Slicers to the Worksheet(p. EX 8-49)
To Format Slicers(p. EX 8-49)
To Use the Slicers(p. EX 8-51)
To Use Slicers to Review Data Not in a PivotTable(p. EX 8-52)
Other Excel Charts(p. EX 8-53)
Funnel Charts(p. EX 8-53)
Sunburst Charts(p. EX 8-54)
Waterfall Charts(p. EX 8-55)
Map Charts(p. EX 8-55)
Scatter Charts(p. EX 8-56)
Histogram Chart(p. EX 8-57)
Combo Charts(p. EX 8-58)
Box and Whisker Charts(p. EX 8-58)
To Create a Box and Whisker Chart(p. EX 8-59)
To Format a Box and Whisker Chart(p. EX 8-60)
Summary(p. EX 8-63)
Apply Your Knowledge(p. EX 8-64)
Extend Your Knowledge(p. EX 8-65)
Expand Your World(p. EX 8-67)
In the Lab(p. EX 8-69)
Module 9 Formula Auditing, Data Validation, and Complex Problem Solving
Objectives(p. EX 9-1)
Introduction(p. EX 9-1)
Project: Instrument Logistics Analysis(p. EX 9-2)
To Start Excel and Open a Workbook(p. EX 9-5)
About the Weekly Shipment Worksheet(p. EX 9-6)
To View Named Cells(p. EX 9-7)
Formula Auditing(p. EX 9-7)
To Trace Precedents(p. EX 9-8)
To Remove the Precedent Arrows(p. EX 9-9)
To Trace Dependents(p. EX 9-10)
To Remove the Dependent Arrows(p. EX 9-12)
To Use the Trace Error Button(p. EX 9-12)
To Use Error Checking to Correct Errors(p. EX 9-13)
More about the Formula Auditing Group(p. EX 9-18)
Using the Watch Window(p. EX 9-18)
Data Validation(p. EX 9-19)
To Add Data Validation to Cells(p. EX 9-20)
To Test the Validation(p. EX 9-23)
Solving Complex Problems(p. EX 9-24)
To Use Trial and Error to Attempt to Solve a Complex Problem(p. EX 9-25)
To Use Goal Seek to Attempt to Solve a Complex Problem(p. EX 9-26)
To Circle Invalid Data(p. EX 9-28)
To Clear Validation Circles(p. EX 9-29)
Customizing Excel Add-Ins(p. EX 9-30)
The Solver Add-In(p. EX 9-30)
To Enable the Solver Add-In(p. EX 9-30)
Solver Requirements(p. EX 9-33)
To Enter Constraints with Solver(p. EX 9-34)
To Enter Constraints with Named Cells(p. EX 9-36)
To Set Solver Options(p. EX 9-37)
To Find the Optimal Solution(p. EX 9-40)
To View the Solver Answer Report(p. EX 9-41)
More about Solver Options(p. EX 9-42)
Using Scenarios and Scenario Manager to Analyze Data(p. EX 9-42)
To Save the Current Data as a Scenario(p. EX 9-43)
Creating a New Scenario(p. EX 9-45)
To Add the Data for a New Scenario(p. EX 9-45)
To Use Solver to Find a New Solution(p. EX 9-46)
To View the Solver Answer Report for the Shipment 2 Solution(p. EX 9-47)
To Save the Second Solver Solution as a Scenario(p. EX 9-48)
To Show a Saved Scenario(p. EX 9-49)
Summarizing Scenarios(p. EX 9-50)
To Create a Scenario Summary Worksheet(p. EX 9-50)
Working with an Outlined Worksheet(p. EX 9-52)
To Create a Scenario PivotTable Worksheet(p. EX 9-52)
Ink Annotations(p. EX 9-54)
To Draw with a Pen(p. EX 9-54)
To Use the 'Ink to Shape' Tool(p. EX 9-55)
To Highlight with Ink(p. EX 9-57)
Summary(p. EX 9-57)
Apply Your Knowledge(p. EX 9-59)
Extend Your Knowledge(p. EX 9-61)
Expand Your World(p. EX 9-62)
In the Lab(p. EX 9-63)
Module 10 Data Analysis with Power Tools and Creating Macros
Objectives(p. EX 10-1)
Introduction(p. EX 10-1)
Project: Business Decisions Demographics(p. EX 10-2)
Workflow(p. EX 10-5)
To Create a Workbook(p. EX 10-5)
To Copy Data Files(p. EX 10-6)
To Enable Data Analysis(p. EX 10-6)
To Add in Power Map(p. EX 10-7)
Customizing the Ribbon(p. EX 10-8)
To Customize the Ribbon(p. EX 10-8)
Get & Transform(p. EX 10-10)
To Get Data(p. EX 10-10)
To Edit Data Using the Power Query Editor(p. EX 10-12)
To Get Another Data Source(p. EX 10-16)
To Edit Data Using the Query Tab(p. EX 10-16)
Power Pivot(p. EX 10-18)
Data Models(p. EX 10-18)
To Add a Query to a Data Model(p. EX 10-19)
To Add Another Query to the Data Model(p. EX 10-20)
To Build a PivotTable Using Power Pivot(p. EX 10-21)
To Create a Relationship(p. EX 10-23)
To Manage Table Relationships(p. EX 10-25)
To Create a Measure(p. EX 10-26)
To Finish Formatting the PivotTable(p. EX 10-27)
Cube Functions(p. EX 10-28)
To View Cube Functions(p. EX 10-30)
The GETPIVOTDATA function(p. EX 10-30)
Using Power BI(p. EX 10-31)
What is Power BI?(p. EX 10-31)
Downloading and installing the Power BI Desktop App(p. EX 10-32)
To Start the Power BI Desktop App(p. EX 10-33)
To Create a Power BI Report(p. EX 10-33)
To Switch Visualizations(p. EX 10-35)
To Create Multiple Visualizations(p. EX 10-38)
To Format the Power BI Report(p. EX 10-40)
To Use the Visualizations(p. EX 10-46)
To Add a Filter in Power BI(p. EX 10-47)
3D Maps(p. EX 10-49)
To Open the 3D Maps Window(p. EX 10-49)
To Create Scenes(p. EX 10-51)
To Format Scene Options(p. EX 10-56)
To Finish the Animation Steps(p. EX 10-57)
To Capture a Screen(p. EX 10-57)
Formatting a Home Page with Hyperlinks and Symbols(p. EX 10-59)
To Format the Home Page(p. EX 10-59)
To Insert a Hyperlink(p. EX 10-59)
To Customize a Hyperlink's ScreenTip(p. EX 10-63)
To Insert a Symbol(p. EX 10-64)
Macros(p. EX 10-67)
To Enable Macros(p. EX 10-67)
Recording Macros(p. EX 10-68)
To Record a Macro(p. EX 10-68)
To Run a Macro(p. EX 10-70)
To Save a Workbook as a Macro-Enabled Workbook(p. EX 10-72)
To Reset the Ribbon(p. EX 10-73)
Summary(p. EX 10-74)
Apply Your Knowledge(p. EX 10-75)
Extend Your Knowledge(p. EX 10-76)
Expand Your World(p. EX 10-77)
In the Lab(p. EX 10-79)
Module 11 User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features
Objectives(p. EX 11-1)
Introduction(p. EX 11-1)
Project: National Injection Molding Sales Analysis(p. EX 11-2)
To Start Excel and Open a Workbook(p. EX 11 -5)
Creating a Custom Theme(p. EX 11-6)
To Create a New Color Scheme(p. EX 11 -6)
To Create a Custom Font Scheme(p. EX 11-7)
To Save a Custom Theme(p. EX 11-8)
Designing the User Interface(p. EX 11-9)
Planning Controls in the Form Design(p. EX 11-9)
To Display the Developer Tab(p. EX 11-11)
To Add Option Buttons to a Worksheet(p. EX 11-12)
To Add Check Boxes to a Worksheet(p. EX 11-13)
To Group Option Buttons Using a Group Box(p. EX 11-13)
Labels and Text Boxes(p. EX 11-14)
To Add a Label Control to the Worksheet(p. EX 11-15)
To Add Command Buttons, to the Worksheet(p. EX 11-15)
Setting Form Control Properties(p. EX 11-16)
To Format the Option Buttons(p. EX 11-16)
To Align and Distribute(p. EX 11-18)
To Format the Option Buttons in the Group Box(p. EX 11-19)
To Format the Check Box Controls(p. EX 11 -20)
Setting ActiveX Control Properties(p. EX 11-21)
To Set Command Button Properties(p. EX 11-21)
To Set Label Properties(p. EX 17-23)
To Align and Distribute Controls(p. EX 11-24)
Storing User Input(p. EX 11-24)
To Create from Selection(p. EX 11-25)
To Assign Other Range Names(p. EX 11-26)
To Enter Cell References(p. EX 11-26)
Evaluating Option Buttons(p. EX 11-26)
To Evaluate Option Button Selection(p. EX 11-27)
To Evaluate Check Box Control Selection(p. EX 11-29)
Writing Code for a Command Button(p. EX 11-29)
The Enter Prospect Button Procedure(p. EX 11-30)
The Submit Button Procedure(p. EX 11-31)
To Enter the Command Button Procedures(p. EX 11-32)
To Remove the Outline from the Group Box Control(p. EX 11-34)
Preparing, Protecting, and Testing Worksheets(p. EX 11-35)
To Prepare Worksheet for Distribution(p. EX 11-35)
To Password Protect the Worksheet(p. EX 11-36)
To Test the Controls in the Worksheet(p. EX 11-37)
Sharing and Collaborating(p. EX 11-39)
To Save a Copy of a Worksheet(p. EX 11 -39)
To Distribute via OneDrive(p. EX 11 -39)
To Co-Author a Workbook(p. EX 11-41)
To Unprotecta Password-Protected Worksheet(p. EX 11-41)
Using Comments to Annotate a Worksheet(p. EX 11-42)
To Add Comments to a Worksheet(p. EX 11 -42)
To Display and Move among Comments(p. EX 11-44)
To Edit Comments on a Worksheet(p. EX 11-45)
Comparing Workbooks(p. EX 11-46)
To Compare Workbooks Side by Side(p. EX 11-47)
To Turn Off Workbook Sharing(p. EX 11-48)
Digital Signatures(p. EX 11-48)
Finalizing a Workbook(p. EX 11-50)
To Add a Watermark to a Worksheet(p. EX 11-50)
To Format a Worksheet Background(p. EX 11-52)
To Add a Legend to a Chart(p. EX 11-54)
To Add a Shadow to a Chart Element(p. EX 11-55)
To Add Sparklines Using the Quick Analysis Gallery(p. EX 11-56)
Saving Custom Views(p. EX 11-57)
To Save a Custom View of a Workbook(p. EX 11-57)
To Test the Custom View(p. EX 11-59)
Setting Internationalization Features(p. EX 11-60)
Displaying International Symbols(p. EX 11-60)
Displaying Data in Multiple International Formats(p. EX 11-61)
Collaborating with Users Who Do Not Use the Same Version of Excel(p. EX 11-61)
To Save a Workbook in an Earlier Version of Excel(p. EX 11-61)
To Mark a Workbook as Final(p. EX 11-63)
Information Rights Management(p. EX 11-64)
To Inspect a Document for Hidden and Personal Information(p. EX 11-64)
To Delete Customization(p. EX 11-66)
Summary(p. EX 11-66)
Apply Your Knowledge(p. EX 11-67)
Extend Your Knowledge(p. EX 11-70)
Expand Your World(p. EX 11-71)
In the Lab(p. EX 11-72)
Index(p. IND-1)

Imprimir
Citar
Agregar a su carrito (remover)
Guardar registro
BIBTEX Dublin Core ISBD MARC (no-Unicode/MARC-8) MARC (Unicode/UTF-8) MARC (Unicode/UTF-8, Estándar) MARCXML MODS (XML) RIS
Más búsquedas

Buscar este título en:
HORIZON