Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more
Skip to content
Newer Version Available
Cover of How to Use Microsoft® Excel®: The Careers in Practice Series v1.0
Published: 
January 2012
Page Count: 
282
ISBN (Digital): 
978-1-4533-3021-0

How to Use Microsoft® Excel®: The Careers in Practice Series

Version 1.0
By Joseph M. Manzo

Included Supplements

Key Features

Teaching a course on How to Use Microsoft® Excel®? Adopt this college textbook as is or personalize it online at Flat World. Change chapter titles, move content with ease, and delight in how much less your students pay. We publish peer-reviewed textbooks by expert authors. You make them perfect for your course.
How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel. However, the approach is not at the expense of relevance.

How to Use Microsoft® Excel® The Careers in Practice Series approaches Excel from the perspective of making personal and professional quantitative decisions. Personal decisions include big purchases such as homes and automobiles, savings for retirement, and personal budgets. Professional decisions include budgets for managing expenses, merchandise items to markdown or discontinue, and inventory management.

Students are given clear, easy to follow instructions for each skill presented. They are also provided with opportunities to learn additional skills related to the personal or professional objectives presented. For example, students will learn the key terms with respect to home mortgages and understand the impact interest rates have on monthly mortgage payments.

This text also places an emphasis on “what if” scenarios so students gain an appreciation for the computational power of Excel.

Each chapter in How to Use Microsoft® Excel® The Careers in Practice Series has a theme for a specific career or field. An example, or objective, is developed within the theme for each chapter. The objectives are designed to answer key questions or provide insights for decisions that were presented in the theme. Students are instructed to open a follow along file at the beginning of each section and will learn how multiple skills are used together to accomplish an objective.

To help students retain what they learn in your course, and refresh their memory about what they don't, lesson videos are provided to walk the student through each skill in the chapter. The lesson videos are broken down by skill so students can target their viewing to material where they need additional help. This feature will be available for courses starting in Fall of 2012.

Within each objective, students learn to execute specific skills. Breaking the objectives down by skills allows students to focus on each skill and instructors to identify where students are having difficulty. This also makes it possible for students and instructors to go back and research specific skills they need to review or reference at a future point in time.

Refresher boxes are available to students after each objective and contain an abbreviated list of steps presented for each skill.

Additionally, for courses starting in Fall of 2012, each refresher box will have a link to a short demonstration video (this is in addition to the lesson videos), providing students with the option to see a quick demonstration of a skill.

The following describes some key features of this text: Step-by-Step Approach:

Students learn each skill in contained step-by-step modules. These modules are set in the context of either a personal or professional objective. The objective is explained first, and then students are given step-by-step instructions to complete a sample file for the application they are learning.

Custom Screen Graphics:

Detailed annotated pictures show students exactly what they need to do to execute the steps for each skill.

Video Lessons:

All skills presented in the material are demonstrated by the author on professionally-produced videos using chromo key technology (green screen).

Refreshers:

Each skill covered in the material is presented in a “Refresher Box” which contains a list of abbreviated steps. Coordinated with each “Refresher Box” is a “Refresher Video”. These videos are demonstrations of each skill lasting 60 seconds.

“Why” Tip Boxes:

Included in the delivery of skills are tip boxes that explain why it is important for students to master specific skills or execute skills in a certain way.

Integrity Check: Tip boxes show students how the integrity of certain skills or objectives can be compromised. For example, forgetting the negative sign in the PMT argument of the Future Value will produce a negative value.

Mouseless Commands:

Tip boxes that show students how to execute skills without a mouse. This feature includes key board short cuts that utilize control keys or key tip commands on the Ribbon. This feature is presented for most skills presented in the text

Assessment:

The product will offer four levels of assessment for instructors. For each assessment level, students will be provided with clear instructions explaining what is required to successfully complete the assignment.

The four assessment levels are as follows:

LEVEL 1 Skills Review: These are exercises that allow students to practice the skills they learned for a variety of different applications. These exercises provide the same step-by-step instructions that are used when a skill is first learned. LEVEL 2 Skill Competency Exams: This is an exam that requires the student to recognize the skill and execute it without the detailed step-by-step instructions. LEVEL 3 Integrity Analysis: These exercises require students to analyze work that has already been completed, identify problems or errors, and make the necessary corrections. LEVEL 4 Skill Application Exams and Projects: These exercises pose a specific objective to the student. The student must accomplish the objective by deciding which skills are applicable to complete the assignment.

The practical focus of How to Use Microsoft® Excel® The Careers in Practice Series along with the supporting videos, features, and economical choices for your students makes this book destined to be a favorite among students (and teachers) everywhere. Order your free desk copy today.

Instructor’s Manual

Instructor’s Manual

The Instructor’s Manual guides you through the main concepts of each chapter and important elements such as learning objectives, key terms, and key takeaways. Can include answers to chapter exercises, group activity suggestions, and discussion questions.

Instructor’s Manual

PowerPoint Lecture Notes

PowerPoint Lecture Notes

A PowerPoint presentation highlighting key learning objectives and the main concepts for each chapter are available for you to use in your classroom. You can either cut and paste sections or use the presentation as a whole.

PowerPoint Lecture Notes

Test Generator

Test Generator

Prefer printable tests? Download our test generator and start creating printable tests today! We offer a test generator for both PC and Mac users.

Test Bank Files for Import to Learning Management Systems

Test Bank Files for Import to Learning Management Systems

For your convenience, we've packaged our test items for easy import into Learning Management Systems like Blackboard, Brightspace/D2L, Canvas, Moodle, or Respondus.

Solutions Manual

Solutions Manual

For exercises that need a little more explanation, our Solutions Manual will take you step by step through solving the problem and offer explanations on the answer.

Solutions Manual

Test Item File

Test Item File

Need assistance in supplementing your quizzes and tests? Our test-item files (in Word format) contain many multiple-choice, fill-in-the-blank, and short-answer questions.

At FlatWorld, we take pride in providing a range of high-quality supplements alongside our titles, to help instructors teach effectively. Supplements are available for instructors who have registered their adoption with us. If you need to review or preview something specific, please contact us.


Sign up for FlatWorld

Already registered? Sign in here

Joseph M. Manzo Lehigh University

Joseph M. Manzo (CMA and MBA Lehigh University) is Professor of Practice in Accounting at Lehigh University’s College of Business. He started teaching at Lehigh in fall 2002 where he developed and oversaw the Microsoft Excel Competency program for all first year business students. He went on to teach several courses in both the undergraduate and graduate programs in the College of Business and since 2010 has taught Introduction to Financial Accounting and Introduction to Managerial Accounting.  In addition to teaching, he is a former director of the Rauch Center for Business Communications and also former acting Associate Dean and Director of Undergraduate Programs for the College of Business. Prior to Lehigh, Professor Manzo worked in apparel manufacturing, retail, and wealth management industries. His industry practice had a heavy emphasis on data analytics and corporate strategic planning. He has written several textbooks addressing practical applications for Microsoft Office that teach students how to use such applications for professional and personal needs. 

Back to top