For courses in Microsoft Office Professional for Windows and Excel for Windows.
Essentials courseware is anchored in the practical and professional needs of all types of students. The series has been completely revamped as the result of extensive usability testing conducted by students with multiple levels of computer knowledge.
The Essentials series is conceived as a "learning system" that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps.
Additional features, tips, pitfalls, and other related information are provided at exactly the right place. They are easily recognizable elements that stand out from the main flow of the tutorial. Icons are designed to match the Microsoft Office theme.
The end-of-chapter exercises have been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod students into extending what they've learned into areas beyond the explicit scope of the lessons proper.
Sprache
Verlagsort
Verlagsgruppe
Pearson Education Limited
Zielgruppe
Maße
Höhe: 275 mm
Breite: 220 mm
Dicke: 15 mm
Gewicht
ISBN-13
978-1-58076-304-2 (9781580763042)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
PROJECT 1: CREATING SPECIAL EFFECTS IN A WORKSHEET.
Lesson 1: Creating WordArt.
Lesson 2: Inserting and Rotating an AutoShape.
Lesson 3: Creating a Text Box.
Lesson 4: Grouping Objects.
Lesson 5: Adding Emphasis with Lines and Arrows.
Lesson 6: Add Emphasis with Callouts.
Lesson 7: Inserting a Graphics File.
Lesson 8: Embedding Sound.
PROJECT 2: DOCUMENTING AND PROTECTING WORKSHEETS AND WORKBOOKS.
Lesson 1: Creating and Using Range Names.
Lesson 2: Attaching Comments to a Cell.
Lesson 3: Getting Help on Security Features.
Lesson 4: Protecting Worksheet Contents and Objects.
Lesson 5: Unlocking Cells.
Lesson 6: Unlock Objects.
Lesson 7: Viewing and Setting File Properties.
Lesson 8: Requiring a Password.
PROJECT 3: GUIDING CELL ENTRY WITH DATA VALIDATION.
Lesson 1: Attaching an Input Message to a Cell.
Lesson 2: Restricting Cell Entries to Data in a List.
Lesson 3: Restricting Cell Entries to Whole Numbers Within Specified Limits.
Lesson 4: Creating a User-Specified Error Alert Message.
Lesson 5: Copying Data Restrictions and Messages to Other Cells.
Lesson 6: Using Audit Tools to Find Invalid Data.
Lesson 7: Editing Errors in Validation Settings.
Lesson 8: Finding Cells with Data Restrictions or Messages.
PROJECT 4: USING FUNCTIONS TO CREATE, CONVERT, AND INTERPRET DATA.
Lesson 1: Using VLOOKUP to Convert Data.
Lesson 2: Using VLOOKUP with Multiple Values.
Lesson 3: Summarizing Data with FREQUENCY.
Lesson 4: Charting a Frequency Distribution.
Lesson 5: Interpreting Data with COUNTIF.
Lesson 6: Interpreting Data with SUMIF.
Lesson 7: Nesting an IF Function in Another IF.
PROJECT 5: USING DATABASE FUNCTIONS AND ADVANCED FILTER.
Lesson 1: Using DSUM to Analyze Data.
Lesson 2: Using AND Search Criteria in a DSUM Function.
Lesson 3: Using DAVERAGE to Analyze Data.
Lesson 4: Using OR Criteria in a DMAX Function.
Lesson 5: Analyzing Data with DCOUNT and DCOUNTA Functions.
Lesson 6: Using DGET to Find a Specific Record.
Lesson 7: Using Advanced Filter to Display Records.
Lesson 8: Copying a List Using Advanced Filter.
PROJECT 6: CREATING PIVOTTABLE AND PIVOTCHART REPORTS.
Lesson 1: Displaying Help on Pivot Tables and Related Charts.
Lesson 2: Creating a Pivot Table.
Lesson 3: Expanding a Pivot Table.
Lesson 4: Removing, Hiding and Showing Data.
Lesson 5: Refreshing a Pivot Table.
Lesson 6: Creating a Chart from Pivot Table Data.
Lesson 7: Applying a Predefined Format to a Pivot Table.
PROJECT 7: EXPANDING CHARTING SKILLS.
Lesson 1: Adding, Reordering, and Deleting a Data Series.
Lesson 2: Creating a Stock Chart.
Lesson 3: Creating an XY Scatter Chart.
Lesson 4: Fitting a Trendline.
Lesson 5: Creating an Area Chart with Attached Data Table.
Lesson 6: Using a Picture in a Chart.
Lesson 7: Creating a Map in a Worksheet.
PROJECT 8: CREATING CONSOLIDATED DATA, OUTLINES, VIEWS, AND REPORTS.
Lesson 1: Consolidating Data in Multiple Worksheets.
Lesson 2: Consolidating Multiple Workbooks.
Lesson 3: Creating an Auto Outline.
Lesson 4: Creating a Manual Outline.
Lesson 5: Creating and Using Custom Views.
Lesson 6: Creating Reports Using Report Manager.
Lesson 7: Editing and Printing Reports Using Report Manager.
Task Guide.
Glossary.
Index.
