New Version!

Excel and SQL Educator Online with AI

Information Systems

ISBN #978-1-967084-50-0

Excel and SQL Educator Online with AI

Nick Ball, PhD
Gove Allen, PhD

Built for Excel Online, this resource takes students from foundational skills through advanced topics including charting, PivotTables, and business modeling. Our dual-bot AI framework takes learning even further. Lisa tutors students in real time while Alex assesses their conceptual understanding as part of the grade. Database and SQL content rounds out the experience for application-focused learning. Each lesson includes instructional readings, lecture videos, practice problems, and assignments to assess student learning. Students finish with a verified certificate they can add to their LinkedIn profile and resume and share with employers.

Preview a Chapter

Request Access

Free instructor demo access to full resource!

Plug-and-play solution for instant adoption

Lifetime access for students

Introduction: Introduction and Device Setup

Lesson 1: Excel Basics

Lesson 2: Formulas and Functions

Lesson 3: Boolean Logic and IF Functions

Lesson 4: Conditional and Reference Functions

Lesson 5: Date, Time, and Text Functions

Lesson 6: Charting

Lesson 7: Working with Tables

Lesson 8: Conditional Formatting

Lesson 9: Modeling

Lesson 10: Statistics

Lesson 11: Analyzing Data with PivotTables

Lesson 12: Designing and Building a Database

Lesson 13: Introduction to SQL

Lesson 14: Writing Queries with Restrictions

Lesson 15: Joining Multiple Tables in the Same Query

Appendix A: Formatting Worksheet for Printing

Appendix B: Formula Auditing

Appendix C: Chart Data Series

Appendix D: What-If Analysis

Appendix E: Named Ranges

Appendix F: Circular References

Appendix G: Optimization Analysis

Appendix H: Shortcuts

Meet the Author!

Request Access

Request free instructor access to any resource. Simply let us know who you are, what school you teach at, which resources you would like access to, and we’ll do the rest!

Not sure which resource fits best for you?

View Catalog

Made by professors, 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.

FAQs

MyEducator was founded by university professors who were frustrated with traditional publishers. Fed up with the high cost for students, outdated content, and ineffective use of technology, they set out to create interactive smart textbooks that could be customized for each course. They knew there had to be a better way.

We understand the need for change–not just in the content students use but in how they apply their knowledge in the real world. Join our mission to make learning more accessible and relevant for every student, in every class, everywhere.

We are proud to offer some of the lowest prices in the industry. Many of our modules and supplements are even more affordable. You can choose from ready-made courseware bundles, or customize your own for additional savings for students! Contact us to learn more about pricing options for your classroom.

Students have access for life. They can even access updates and new versions of their resource at any time for no additional cost.

Yes! You can custom-tailor any resource with your own materials, add/remove and rearrange content, and you even have access to our authors to assist in creating the perfect resource for your specific needs.

Lightning fast–once you choose to adopt, our team is ready to assist with setup and provide continuous support.

We integrate with all major LMS platforms: Canvas, Brightspace, Moodle, Blackboard, and even your own LMS. Integration is secure and stable.

We have collaborated closely with our authors to make your adoption process as turn-key as possible! While offerings vary by resource, we generally provide a full range of materials, including syllabi, instructor guides, lesson outlines, robust auto-graded assessments, videos, current event articles, case studies, simulations, games, an AI Virtual Assistant, and more. We’re constantly adding resources to support your teaching needs!

Related Courseware

Database Management and Design

Essentials Plus of SQL: Extracting and Updating Data

Introduction to Programming with Python

Ready to get started?

Contact us today