facebook
favorite buttonAdd to Wish List
favorite buttonAdd to Wish List
member icon
Trusted teacher
from65.11CAD/ h

Excel functions for both the classroom and business

The class involves my demonstrating how to execute many Excel special functions. Such as linking information from one spreadsheet tab to another tab; creating V-Look ups, H-Look ups, Pivot Tables, Pivot Charts, Nested If's, Sumif's, "If/Then", “If/And” scenarios among many others. Included in the lesson is an interactive spreadsheet which contains actual working formulas with step-by-step instructions for easy implementation. You will see working, functioning examples of all the Excel functions I teach & explain during the lecture.

Excel is one of my specialties. As an experienced CPA who has had both individual and corporate clients, I have constructed both simple to very complex spreadsheets – plus I was always ready to explain how they functioned to my employer, my co-workers, my tax clients, and even auditors!

Extra information

I will present the material during a live on-line presentation using Excel 365.

Location

Online via webcam
At student's location: Around Bixby, OK, United States

|
Use ctrl + wheel to zoom!
+

General info

Age:
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level:
Intermediate
Advanced
Duration:
60 minutes
The class is taught in:English

About Me

I enjoy instilling enthusiasm, explaining accounting theory, as well as answering your questions. If applicable, I will demonstrate how I calculate my answers using an Excel spreadsheet & screen sharing my work via an on-line platform. You can witness first-hand how a practicing CPA approaches a problem. Afterwards I’ll email you the spreadsheet.

Tutoring subjects include: bookkeeping, accounting, intermediate accounting; financial accounting. I do NOT tutor in cost, managerial, or governmental. Practically speaking, I have been a CPA with public accounting experience, as well as, being a Controller for regionally privately held companies for years. Accordingly, I decline tutoring in areas I have not practiced accounting.

Education

St. Ambrose University, Accounting degree with business minor.
CPA license from Texas State Board of Public Accountancy - current.
I maintain the 40 hour annual / 120 hour tri-annual CPE (Continuing Professional Education) requirement

Experience / Qualifications

Corporate Controller for two different regional building material supplies and lumberyards;
Senior Accountant / Assistant Treasurer for global banking organization in their financial trust department;
I have prepared a multi-lesson package for new accounting students discussing & unraveling the importance & relevance of accounting, as well as removing the mystery from accounting. I developed this multi-lesson series for a parent who wanted their student to become intimately familiar with accounting before university classes began. I have revised it to become both a necessary and handy primer for the non-accounting major. It is my perennial favorite to teach both first-year accounting students & non-accounting majors – at the request of both the student or parent!
I appreciate you considering me as an accounting mentor to contribute toward your academic success. I have served both in industry & in public practice of accounting. As a licensed CPA, I enjoy tutoring both accounting & non-accounting undergraduate students and those seeking advanced degrees, such as the MBA. I have dedicated myself to the learning process by helping others. My method of tutoring is to approach each student and inquire which method may best facilitate their style of learning? Do you want to first attempt the accounting question, then allow me to suggest the next logical step? Or perhaps you prefer me to demonstrate how I calculate my answers using an Excel spreadsheet & screen-share my work? Perhaps your method only needs fine tuning with occasional insight; on the other hand, you may want to witness first-hand how a seasoned accounting professional approaches it. During our time together, I’ll attach my spreadsheet with all my notes for your downloading & review. Let’s plan to approach each topic in a manner which best accomplishes your goals, answering all your questions, instilling confidence & enthusiasm in a dry subject, and explaining accounting theory when it's not so obvious. John

Ask a question

Send a message explaining your needs and John will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  
  
  
  
  
  
  
7
  
  
  
  
  
  
  
8
  
  
  
  
  
  
  
9
  Monday at 9:00
  Tuesday at 9:00
  Wednesday at 9:00
  Thursday at 9:00
  Friday at 9:00
  Saturday at 9:00
  
10
  Monday at 10:00
  Tuesday at 10:00
  Wednesday at 10:00
  Thursday at 10:00
  Friday at 10:00
  Saturday at 10:00
  
11
  Monday at 11:00
  Tuesday at 11:00
  Wednesday at 11:00
  Thursday at 11:00
  Friday at 11:00
  Saturday at 11:00
  
12
  Monday at 12:00
  Tuesday at 12:00
  Wednesday at 12:00
  Thursday at 12:00
  Friday at 12:00
  Saturday at 12:00
  
13
  Monday at 13:00
  Tuesday at 13:00
  Wednesday at 13:00
  Thursday at 13:00
  Friday at 13:00
  Saturday at 13:00
  
14
  Monday at 14:00
  Tuesday at 14:00
  Wednesday at 14:00
  Thursday at 14:00
  Friday at 14:00
  Saturday at 14:00
  
15
  Monday at 15:00
  Tuesday at 15:00
  Wednesday at 15:00
  Thursday at 15:00
  Friday at 15:00
  Saturday at 15:00
  Sunday at 15:00
16
  Monday at 16:00
  Tuesday at 16:00
  Wednesday at 16:00
  Thursday at 16:00
  Friday at 16:00
  Saturday at 16:00
  Sunday at 16:00
17
  Monday at 17:00
  Tuesday at 17:00
  Wednesday at 17:00
  Thursday at 17:00
  Friday at 17:00
  Saturday at 17:00
  Sunday at 17:00
18
  Monday at 18:00
  Tuesday at 18:00
  Wednesday at 18:00
  Thursday at 18:00
  Friday at 18:00
  Saturday at 18:00
  Sunday at 18:00
19
  Monday at 19:00
  Tuesday at 19:00
  Wednesday at 19:00
  Thursday at 19:00
  Friday at 19:00
  Saturday at 19:00
  Sunday at 19:00
20
  Monday at 20:00
  Tuesday at 20:00
  Wednesday at 20:00
  Thursday at 20:00
  Friday at 20:00
  Saturday at 20:00
  Sunday at 20:00
21
  Monday at 21:00
  Tuesday at 21:00
  Wednesday at 21:00
  Thursday at 21:00
  Friday at 21:00
  Saturday at 21:00
  Sunday at 21:00
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from C$65.11Online via webcam
from C$72.18At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Online reputation

  • Instructor since January 2019
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  
  
  
  
  
  
  
7
  
  
  
  
  
  
  
8
  
  
  
  
  
  
  
9
  Monday at 9:00
  Tuesday at 9:00
  Wednesday at 9:00
  Thursday at 9:00
  Friday at 9:00
  Saturday at 9:00
  
10
  Monday at 10:00
  Tuesday at 10:00
  Wednesday at 10:00
  Thursday at 10:00
  Friday at 10:00
  Saturday at 10:00
  
11
  Monday at 11:00
  Tuesday at 11:00
  Wednesday at 11:00
  Thursday at 11:00
  Friday at 11:00
  Saturday at 11:00
  
12
  Monday at 12:00
  Tuesday at 12:00
  Wednesday at 12:00
  Thursday at 12:00
  Friday at 12:00
  Saturday at 12:00
  
13
  Monday at 13:00
  Tuesday at 13:00
  Wednesday at 13:00
  Thursday at 13:00
  Friday at 13:00
  Saturday at 13:00
  
14
  Monday at 14:00
  Tuesday at 14:00
  Wednesday at 14:00
  Thursday at 14:00
  Friday at 14:00
  Saturday at 14:00
  
15
  Monday at 15:00
  Tuesday at 15:00
  Wednesday at 15:00
  Thursday at 15:00
  Friday at 15:00
  Saturday at 15:00
  Sunday at 15:00
16
  Monday at 16:00
  Tuesday at 16:00
  Wednesday at 16:00
  Thursday at 16:00
  Friday at 16:00
  Saturday at 16:00
  Sunday at 16:00
17
  Monday at 17:00
  Tuesday at 17:00
  Wednesday at 17:00
  Thursday at 17:00
  Friday at 17:00
  Saturday at 17:00
  Sunday at 17:00
18
  Monday at 18:00
  Tuesday at 18:00
  Wednesday at 18:00
  Thursday at 18:00
  Friday at 18:00
  Saturday at 18:00
  Sunday at 18:00
19
  Monday at 19:00
  Tuesday at 19:00
  Wednesday at 19:00
  Thursday at 19:00
  Friday at 19:00
  Saturday at 19:00
  Sunday at 19:00
20
  Monday at 20:00
  Tuesday at 20:00
  Wednesday at 20:00
  Thursday at 20:00
  Friday at 20:00
  Saturday at 20:00
  Sunday at 20:00
21
  Monday at 21:00
  Tuesday at 21:00
  Wednesday at 21:00
  Thursday at 21:00
  Friday at 21:00
  Saturday at 21:00
  Sunday at 21:00
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from C$65.11Online via webcam
from C$72.18At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Share


Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf Region
Do you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office. Why Choose Microsoft Office? Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking. Save Time with Automation: Excel simplifies complex tasks with its smart formulas, pivot tables and many other innovative features. Accessible Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is available on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.

Robert
Accounting, finance and economics courses + help for your business plan
Experienced Franco-Belgian teacher offers private lessons in the fields of political economy, accounting and finance for secondary and higher levels. I also offer assistance for the development of your business plan / business plan. I also travel to your home in the Brussels region as well as in Walloon and Flemish Brabant, with a minimum course duration of 2 hours. With extensive experience, I offer numerous exercises to reinforce knowledge. Distance learning courses are also available. Please note that, for students in France, courses take place exclusively remotely. Do not hesitate to contact me to organize your lessons according to your needs and availability. I am here to help you develop your skills in these areas in an efficient and personalized way. With my support, you will be able to master the concepts of accounting, finance and economics, while receiving valuable assistance in creating your business plan.

Patricia
Spanish Language & Business Coach – Everyday Spanish + Accounting & Business Tutoring
Hello! I’m a bilingual Spanish-English educator and cultural coach. I help students communicate confidently in Spanish whether for everyday life, business, or academic subjects like accounting and auditing. I also offer cultural coaching for professionals working with Latin America. I help you understand not only the words, but also the values, communication styles and work culture. With a background in business and finance, I teach technical subjects like Basic Accounting, Cost Accounting and Auditing in both Spanish and English. These classes are perfect for students and professionals who need clear and friendly explanations. I adapt to every student’s needs and level, and my goal is to make you feel confident and empowered in every lesson.

Alassa
Private lessons in Accounting, French and German
Private lessons & academic support – Accounting, French, German, Dissertation 🔹 Are you a worker, a BTS, Bachelor's, or Master's student? Are you preparing for an exam or writing your dissertation in French or German? I offer private lessons and personalized support in the following areas: 📚 Courses offered: Accounting: introduction, in-depth study, review of basics, practical cases French & German: grammar, written and oral expression, exam preparation Dissertation writing assistance (French): structure, reformulation, correction and specialized translation 👨‍🏫 About me: Franco-German chartered accountant, head of a Franco-German accounting firm (France & Luxembourg) Sworn translator in Luxembourg (French – German – English) Master's in Translation and Conference Interpreting Experience in teaching, academic support and professional translation 📍Face-to-face courses in Luxembourg or online according to your preferences 📆 Flexible hours – including evenings and weekends 💬 Possibility to work in French, German or English 💡 Do not hesitate to contact me to discuss your needs.

Sami
Master Microsoft Office from Anywhere! Microsoft Word, Excel, and PowerPoint
Are you looking to boost your productivity and enhance your professional skills? Unlock the full potential of Microsoft Word, Excel, and PowerPoint with personalized, one-on-one online classes tailored to your needs! Flexible Scheduling: Learn at your own pace, on your own schedule, from the comfort of your home or office.

Mounir
Private Online Excel & Word Classes / Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes
Unlock Your Potential: Private Online Excel & Word Classes Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes are designed to help you gain confidence and proficiency. Whether you're a beginner needing basics, a student tackling projects, or a professional aiming to boost productivity, we tailor lessons to your specific goals. Flexible Scheduling Customized Curriculum Experienced Instructor Boost Your Skills, Boost Your Career!

Anwar
🎓 Excel Training for Beginners 📊 Learn step by step to master the basics of Excel
🎓 Excel Training for Beginners 📊 Are you new to Excel? This training is for you! Learn step by step to master the basics of Excel: ✔️ Creation of simple tables ✔️ Essential formulas and functions ✔️ Formatting and graphics ✔️ Time-saving tips 👩‍🏫 Clear, practical training accessible to all, even without any prior experience. 📅 Join us and boost your digital skills!

Agatha W
Business Basics: Skills for High School & College Success
This course is designed to introduce high school and college students to the core principles of business. You’ll explore topics like marketing, finance, entrepreneurship, and management through real-world examples and hands-on activities. Whether you’re interested in starting your own business or just want to understand how companies operate, this class will give you practical skills and knowledge to succeed in today’s business world.

Vincent
IGCSE , A LEVELS FOR ACCOUNTS, BUSINESS STUDIES, MARKETING and ECONOMICS
I specialize in tutoring Accounting and Business for school. My goal is to keep students challenged, but not overwhelmed. I assign homework after every lesson and provide periodic progress reports. AM A PASSIONATE AND PROFESSIONAL TEACHER OF ACCOUNTS, BUSINESS AND ECONOMICS. ALWAYS AVAILABLE AND READY TO MAKE A DIFFERENCE IN THE STUDENTS . I HAVE BEEN TEACHING IGCSE AND A LEVELS . AM SO MUCH FAMILAR WITH THE IGCSE SYLABUS AND A LEVELS. I have full Outstanding knowledge of accounts formulas and concepts. In-depth knowledge of using various teaching and learning aids. Ability to pay extra attention to the slow learning students. Exceptional verbal and written communication skills.

Youness
Office Automation Training: Excel, Word, Remote Power Point / Online
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me.

Professeur
- Distance Excel courses For all levels: ONLINE-
- Distance Excel courses For all levels: ONLINE- I give Excel lessons remotely for all levels. I offer remote Excel sessions for all levels. I provide extensive support and well supported by the most effective learning tools. For more information, contact me

Said
Master Word, Excel, & PowerPoint with personalized, one-on-one online classes. Boost your skills for work, school, or personal projects.
Master Word, Excel, & PowerPoint with personalized, one-on-one online classes. Boost your skills for work, school, or personal projects. Flexible scheduling & expert instruction. Start learning today! Enhance your digital literacy and professional capabilities through customized one-on-one online sessions. Develop proficiency in essential Microsoft Office applications: Microsoft Word: Document creation, advanced formatting, mail merge, and more. Microsoft Excel: Data entry and manipulation, formula creation, charting, pivot tables, and data analysis. Microsoft PowerPoint: Effective presentation design, animation, transitions, and delivery techniques.

Marissa
Exploring Business Fundamentals, Strategy, and Real-World Applications
This class equips high school and college/university students with a comprehensive understanding of core business concepts, including management, marketing, finance, entrepreneurship, and organizational behavior. Students will learn how businesses operate in local and global markets, analyze case studies, and apply strategic thinking to solve real-world business challenges. The course also emphasizes critical skills such as communication, decision-making, and ethical reasoning—preparing students for academic excellence, competitive exams, and future careers in business and related fields.

Khalid
online private classes in Microsoft Word, Excel, and PowerPoint
Transform your proficiency in the essential Microsoft Office suite with our exclusive online private classes. Whether you're a student, professional, or simply looking to enhance your digital literacy, we offer customized instruction in: Microsoft Word: Master document creation, formatting, mail merge, and advanced features. Microsoft Excel: Conquer formulas, data analysis, pivot tables, charts, and more. Microsoft PowerPoint: Design impactful presentations, utilize multimedia, and deliver with confidence. Our experienced instructors provide focused, one-on-one sessions tailored to your specific learning goals and current skill level. Enjoy the convenience of learning from your own home, with flexible scheduling to fit your busy life. Ready to boost your productivity and career prospects?

Samir
Struggling with Word, Excel, or PowerPoint? Get Expert Help!
Master Word, Excel, & PowerPoint with personalized 1-on-1 instruction. Learn at your own pace, from anywhere. Boost your skills, enhance your productivity, and achieve your goals. Book your first session today! Our private online classes offer tailored instruction to help you conquer any challenge. From basic formatting in Word to advanced data analysis in Excel and impactful presentations in PowerPoint – learn exactly what you need. Flexible scheduling and experienced tutors make learning easy and effective. Elevate your digital literacy now!