Advanced Excel for Business

Information Systems

Microsoft Office

ISBN:

978-1-959142-26-3

Advanced Excel for Business

Tom Meservy, PhD

Spreadsheets have incredible power, but most of that power goes unused. This resource is aimed at students who already have a basic knowledge of Excel and provides an in-depth look at the many tools and features that Excel offers to create complex and powerful spreadsheets—all with practice opportunities completed in the live Excel environment. Students will come away with the knowledge and skills to become a master at Excel and set themselves apart from the competition in the workplace.

Preview a Chapter

Request Access

Free instructor demo access to full resource

Plug-and-play solution for instant adoption

Lifetime access for students

Introduction Lesson 1: Names Lesson 2: Debugging Lesson 3: Dates and Times Lesson 4: Charts Lesson 5: Conditional Formatting and Data Validation Lesson 6: External Data Acquisition Lesson 7: Data Tables and Lists Lesson 8: Arrays Lesson 9: Circular References, Goal Seek, and Solver Lesson 10: PivotTables Lesson 11: Financial Formulas: Part 1 Lesson 12: Financial Formulas: Part 2 Lesson 13: Counting and Summing Lesson 14: Lookups Lesson 15: Text Lesson 16: Megaformulas Lesson 17: Importing and Cleaning Data Lesson 18: VBA: Basics Lesson 19: VBA: Control Flow Lesson 20: VBA: Debugging, Errors, and Help Lesson 21: VBA: Creating Functions Practice Lesson 22: Miscellaneous Calculations Lesson 23: Monte Carlo Simulations Lesson 24: Power Pivot

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.