Computing with Excel and VBA

Computing with Excel and VBA

by Krishan
Released October 2010
Publisher(s): Jones & Bartlett Learning
ISBN: 9781449612856

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Ideal for use in non-majors, introductory-level CS or CIS courses, Computing with Excel and VBA provides students with a clear emphasis on problem solving using the popular tools Excel and VBA. Numerous examples are presented throughout the text to illustrate key concepts, and several additional examples and exercises are provided as learning tools at the end of each chapter. All examples were developed to relate to practical situations that students will likely encounter in their work or studies. By using Excel to demonstrate how computers can be used to solve problems, students will gain a solid skill set in this popular resource. The coverage of VBA provides exposition to programming with simple examples to show how Excel applications can be customized. Computing with Excel and VBA provides students with a concise and complete understanding of computer systems and problem solving techniques that will pave the way for future study!

Table of contents

  1. Title
  2. Copyright
  3. Preface
  4. Table of Contents
  5. 1 Getting Started
    1. Computing History in Brief
    2. Computer System Components
    3. System and Application Software
    4. Information Representation in Computers
    5. Computer Networks
    6. The Internet and the Web
    7. What Follows Next
  6. 2 Excel Basics
    1. Excel Interface
    2. The Ribbon
    3. The Workspace
    4. Moving Around in a Worksheet
    5. Selecting a Group of Cells
    6. Excel Data Types
    7. Formatting
      1. Example 2.1 Creating a Worksheet
    8. Printing Your Worksheet
    9. Worksheet Templates
    10. Excel File Formats
    11. Customizing Excel Settings
    12. Seeking Help
    13. Tips for Good Worksheets
    14. Summary
  7. 3 More Excel
    1. Cell Referencing
    2. Moving and Copying Formulas
      1. Example 3.1 Tabulating Triangle Areas
    3. Cell Referencing by Name
    4. Worksheet Functions
    5. Function Categories
    6. Common Function Examples
      1. Example 3.2 Calculating Distances
      2. Example 3.3 Returning Exact Change
    7. Dealing with Errors
    8. Summary
  8. 4 Working with Conditions
    1. Functions for Conditional Calculations
      1. Example 4.1 Checking Divisibility
      2. Example 4.2 Analyzing Housing Sales Data
      3. Example 4.3 Housing Sales Data Revisited
    2. Logic Functions
    3. Functions with Built-in Conditions
    4. Conditional Formatting (1/2)
    5. Conditional Formatting (2/2)
      1. Example 4.4 Seven-Segment Display
    6. Data Validation
    7. Summary
  9. 5 Computing as Problem Solving
    1. Problem Solving
    2. Five Steps to Problem Solving
    3. Algorithm and Flowchart
    4. Problem Solving Examples
      1. Example 5.1 Salary Calculation with Overtime
      2. Example 5.2 Lucky Number Calculation
      3. Example 5.3 Finding Equivalent Decimal Numbers (1/2)
      4. Example 5.3 Finding Equivalent Decimal Numbers (2/2)
      5. Example 5.4 Finding Square Root with a Cheap Calculator
    5. Summary
  10. 6 Working with Text, Dates, and Times
    1. Text in Excel
      1. Example 6.1 Number Conversion Revisited
      2. Example 6.2 Organizing a Book List
      3. Example 6.3 Finding the Writing Style of a Writer
    2. Dates and Time
      1. Example 6.4 Days Left for a Birthday
      2. Example 6.5 Time Sheet Calculations
    3. Summary
  11. 7 Working with Tables
    1. Excel Tables
    2. Using Forms to Navigate Tables
    3. Sorting
    4. Filtering
    5. Data Summarization with Subtotals
    6. Importing Text Files
    7. Pivot Tables (1/2)
    8. Pivot Tables (2/2)
    9. Lookup Tables
      1. Example 7.1 Hexadecimal to Binary Conversion
    10. Summary
  12. 8 Charting in Excel
    1. Chart Types and Terminology
    2. Creating a Chart
    3. Modifying an Existing Chart
    4. XY Charts
    5. Pivot Charts
    6. Summary
  13. 9 Data Analysis and Simulation
    1. Excel Functions for Descriptive Statistics
    2. Random Number Generation
    3. Data Tables
      1. Example 9.1 Chuck-a-Luck Dice Game
      2. Example 9.2 Stock Return Simulation
    4. Goal Seeking
    5. Scenario Manager
    6. Summary
  14. 10 Macros
    1. Macros
    2. Creating a Macro through Recording
    3. Running a Macro
    4. Developer Tab
    5. Macro Security
    6. Assigning a Macro to a Graphic Object
    7. Visual Basic Editor
    8. Summary
  15. 11 VBA Programming
    1. VBA Basics
    2. Writing a Macro
    3. Variables, Data Types, and Constants
    4. Assignment Expressions
    5. Using VBA’s and Excel’s Built-In Functions
      1. Example 11.1 Interactive Coin Toss Worksheet
    6. Using Message Boxes
      1. Example 11.2 Temperature Conversion
    7. Variable Scope
    8. Public versus Private Procedures
    9. Writing Custom Functions
      1. Example 11.3 Function BMI
    10. Dealing with Errors
    11. Summary
  16. 12 More VBA Programming
    1. Calling Procedures
      1. Example 12.1 VBA Code for Function Calling
      2. Example 12.2 VBA Code for Sub Procedure Calling
    2. Controlling the Execution Flow
    3. Program Looping
      1. Example 12.3 Lucky Number Calculation
    4. Putting it All Together
      1. Example 12.4 Decimal to Hex Conversion
      2. Example 12.5 Seven-Segment Display Macro
    5. Summary
  17. Index (1/3)
  18. Index (2/3)
  19. Index (3/3)

Product information

  • Title: Computing with Excel and VBA
  • Author(s): Krishan
  • Release date: October 2010
  • Publisher(s): Jones & Bartlett Learning
  • ISBN: 9781449612856