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
Zielgruppe
Maße
Höhe: 273 mm
Breite: 216 mm
Dicke: 9 mm
Gewicht
ISBN-13
978-1-58076-303-5 (9781580763035)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Project 1: Designing On-Screen Forms with Excel.
Lesson 1: Adding a Check Box to a Worksheet. Lesson 2: Adding an Option Button to a Worksheet. Lesson 3: Adding a Combo Box and Link to a List. Lesson 4: Adding a Spinner to a Worksheet. Lesson 5: Enhancing a Form. Lesson 6: Protecting a Form. Lesson 7: Saving a Form as a Template. Lesson 8: Using a Template Form.
Project 2: Automating Tasks with Macros.
Lesson 1: Preparing to Record a Macro. Lesson 2: Recording a Macro. Lesson 3: Playing a Macro. Lesson 4: Recording to Personal Macro Workbook. Lesson 5: Playing from Personal Macro Workbook. Lesson 6: Unhiding / Editing Pers. Macro Workbook Lesson 7: Creating a Macro Button in a Workbook. Lesson 8: Adding a Macro Button to a Toolbar.
Project 3: Using Advanced Functions.
Lesson 1: Using the Formula Palette. Lesson 2: Using the Future Value Function. Lesson 3: Using the PV and ROUND Functions. Lesson 4: Examining a User-Defined Function. Lesson 5: Concatenating String Text Together. Lesson 6: Inserting Symbols and Characters. Lesson 7: Extracting Text with the MID Function. Lesson 8: Using the TEXT Function.
Project 4: Creating Statistical Simulations.
Lesson 1: Using RAND to Create Random Numbers. Lesson 2: Creating a Recalculation Macro. Lesson 3: Generating Two Random Values. Lesson 4: Simulating Expected Values. Lesson 5: Generating a Distribution of Values. Lesson 6: Interpreting Simulation Results (Example). Lesson 7: Performing a Chi-square Goodness of Fit. Lesson 8: Using Descriptive Statistics in Simulation.
Project 5: Using the Analysis Toolpak.
Lesson 1: Generating Random Numbers. Lesson 2: Selecting a Random Sample. Lesson 3: Smoothing Data with a Moving Average. Lesson 4: Performing t-Test: 2 Independent Groups. Lesson 5: Performing t-Test: Two Paired Groups. Lesson 6: Comparing Multiple Groups - ANOVA. Lesson 7: Performing Regression Analysis. Lesson 8: Plotting a Regression Line and Predicting.
Project 6: Goal Seek, Scenarios, Solver, Audit Tools.
Lesson 1: Audit Tools: Interpreting Error Messages. Lesson 2: Audit Tools: Checking Formulas. Lesson 3: Audit Tools: Reverse Engineer Worksheet. Lesson 4: Using Goal Seek to Forecast Revenues. Lesson 5: Doing What-if Analysis with Data Tables. Lesson 6: Using Scenarios for What-if Analysis. Lesson 7: Using Solver to Maximize Profits. Lesson 8: Using Solver to Minimize Costs.
Project 7: Integrating Applications eith OLE.
Lesson 1: Linking Excel Data to a Word Document. Lesson 2: Editing Linked Data. Lesson 3: Examining and Editing a Link. Lesson 4: Embedding Excel Data in a Word File. Lesson 5: Editing Embedded Data. Lesson 6: Inserting Excel File in a Word Document. Lesson 7: Linking Excel Data to a PowerPoint Slide. Lesson 8: Linking Excel Chart to a PowerPoint Slide.
Project 8: Collaborative Tools and Hyperlinks.
Lesson 1: Tracking Changes in a Workbook. Lesson 2: Accepting or Rejecting Changes. Lesson 3: Sharing a Workbook. Lesson 4: Using Hyperlinks within a Workbook Lesson 5: Setting Hyperlink: in Word to Excel Data. Lesson 6: Setting Hyperlink: in PowerPoint to Excel. Lesson 7: Converting a Workbook into a Web Page. Lesson 8: Viewing / Editing Excel Web Document. Lesson 9: E-mailing an Excel Workbook.
Glossary.
Task Guide.
Index.
