facebook
favorite buttonAdd to Wish List
favorite buttonAdd to Wish List
member icon
Trusted teacher
from35.47GBP/ 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 -05:00) Chicago
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  
  
  
  
  
  
  
7
  
  
  
  
  
  
  
8
  Monday at 8:00
  Tuesday at 8:00
  Wednesday at 8:00
  Thursday at 8:00
  Friday at 8:00
  Saturday at 8:00
  
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
  Sunday 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
  
  
  
  
  
  
  
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from £35.48Online via webcam
from £39.34At 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 -05:00) Chicago
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  
  
  
  
  
  
  
7
  
  
  
  
  
  
  
8
  Monday at 8:00
  Tuesday at 8:00
  Wednesday at 8:00
  Thursday at 8:00
  Friday at 8:00
  Saturday at 8:00
  
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
  Sunday 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
  
  
  
  
  
  
  
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from £35.48Online via webcam
from £39.34At 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
Master Microsoft Excel, Word and PowerPoint from zero to expert!
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Rony
Master Microsoft Word, Excel and Powerpoint: Transform From a Beginner to a Pro!
Microsoft Office is the most essential toolset for students, professionals, and anyone looking to improve their productivity. This beginner-friendly course will teach you the key skills needed to confidently use Microsoft Word, Excel, and PowerPoint for personal, academic, and professional tasks. In this course, you will learn how to: ✅ Microsoft Word – Create, format, and edit professional documents with ease ✅ Microsoft Excel – Organize data, use formulas, and create charts for better analysis ✅ Microsoft PowerPoint – Design stunning presentations with animations and transitions ✅ Use shortcuts and best practices to work more efficiently ✅ Collaborate with others using sharing and review features By the end of this course, you’ll have the skills to create polished documents, manage data effectively, and deliver engaging presentations. No prior experience is needed—just a desire to learn!

James
Economics, Finance, Accounting & Math Tutoring for All Levels
This class is ideal for students and professionals who want to improve their understanding of economics, finance, accounting, and mathematics. Whether you're studying for school, university, or professional exams, I offer personalized support to help you grasp complex topics with confidence. You will learn key principles of microeconomics and macroeconomics, financial accounting, managerial accounting, corporate finance, algebra, calculus, and statistics. I also assist with homework, exam preparation, and concept clarification. My teaching approach is clear, structured, and tailored to your needs. I use real-world examples and practical exercises to make learning more engaging and relevant. Whether you are a beginner or advanced learner, I am here to help you succeed.

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.

Gaëlle
Finanzas para niños: Aprende a gestionar tu dinero
Financial literacy is an important skill for kids to learn at an early age. I know many adults who would have loved learning about it earlier. They will learn about saving money, spending money wisely, and managing their finances. First, they will learn and think about how and why saving money: - short-term and long-term goals they can save for (e.g. a toy, a trip, college education). - how to create a budget and track their spending. - Compound interest and the impact of starting to save early. How to spend money wisely: - difference between needs and wants. - how to compare prices and make informed purchasing decisions. - learn what is impulse buying and method to take the time to think before spending. How to managing money: - Keeping track of spending and creating a budget - Different types of bank accounts, type of money and currencies - learn what are credits, how they work and how it can impact their finances in the future. This class is made for kids, so it'll include use games, puzzles, and interactive activities to help them understand the concepts while having fun.

Rayah
Master Microsoft Word, Excel and Power Point with Personalized Online Private Lessons!
Master Microsoft Word, Excel and Power Point with Personalized Online Private Lessons! Boost your confidence with one-on-one Microsoft Word, Excel and Power Point classes tailored to your level and goals. Whether you're a beginner or advanced, our flexible online sessions fit your schedule and focus on what you need today from the comfort of your home!

Chudamani
Business/Economics for PYP, MYP, DP, GCSE, AS/A Level, and European School Students taught by International Baccalaureate® Certified Teacher
Unlock the world of Business/Accounting/Economics with expert guidance from a highly experienced International Baccalaureate® (IB) certified teacher. Whether you're tackling the foundational concepts in Primary Years Program (PYP), building a solid business/accounting/economics base in the Middle Years Program (MYP), or preparing for the rigor of the Diploma Program (DP), IGCSE, AS Level, or A Level exams, this class is designed to cater to your individual needs and academic goals. This class offers personalized support to students of all levels—helping you understand core Business/Economics principles, solve complex problems, and develop the critical thinking skills needed for success in exams and beyond. With an approach that encourages curiosity, conceptual understanding, and practical application, each lesson is designed to make math engaging, accessible, and applicable to real-life scenarios. Key Highlights: Expert Teaching: Learn from a certified IB teacher with a proven track record of success across various international curricula. Tailored Learning: Whether you're in PYP, MYP, DP, IGCSE, AS, A Level, or attending a European School, lessons are customized to match your syllabus, learning style, and pace. Comprehensive Coverage: All areas of business/accounting/economics are covered. Exam Success: Focus on both understanding the concepts and mastering exam techniques to achieve top results. Interactive & Engaging: Active problem-solving, real-world applications, and fun math challenges ensure that learning stays dynamic and effective. Students are empowered with the tools to approach business/accounting/economics confidently, and with an emphasis on developing strong reasoning and analytical skills, you're prepared for academic excellence and beyond. Whether you're aiming for a higher grade or simply seeking to strengthen your math foundation, this class will equip you with the knowledge and confidence you need to succeed. I specialize in Business/Accounting/Economics lessons tailored to students of all levels, including: 1. Master’s and Bachelor’s Students 2. Pre-university students: 3. IB (Math SL and Math HL) students 4. AS/A-level students 5. European S6 and S7 students 6. GCSE and IGCSE students 7. Primary school students I currently teach a diverse group of students from various international schools in Portugal and around the world. Here are some of the schools my students come from: A. Schools in Portugal: The British School of Lisbon - British Curriculum (IGCSE, A-Levels) PaRK International School | Praça de Espanha - International Baccalaureate (IB) United Lisbon International School - International Baccalaureate (IB) & American Curriculum The Lisboan International School - International Baccalaureate (IB) or British-based curriculum Oeiras International School - International Baccalaureate (IB) Carlucci American International School of Lisbon - American Curriculum & International Baccalaureate (IB) Colégio Europeu Astoria - European-based Curriculum Redbridge International School - British Curriculum (IGCSE) & International Baccalaureate (IB) B. Schools around the world: International School of Paris, France (IB Curriculum) International School of Brussels, Belgium (IB Curriculum) Merchiston Castle School, Edinburgh, Scotland (Edexcel, Cambridge Curriculum) International School of The Hague, Netherlands (IB Curriculum) The British School of Brussels, Belgium (IGCSE, A-Level) International School of Geneva, Switzerland (IB Curriculum) American International School of Vienna, Austria (American and IB Curriculum) American School of Barcelona, Spain (IB Curriculum) International School of Madrid, Spain (IGCSE and A-Level) While some of my students follow curriculums in various languages (Portuguese, French, German, or Spanish), the primary language of instruction in my class is English. Join now to elevate your math skills, gain clarity in complex topics, and become a confident problem-solver!

Amine
Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office Automation
I offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.

Amine
Moroccan Darija Distance Course: ONLINE!
I give online Moroccan colloquial language lessons for all levels. Questions and answers are scheduled. The colors are not intended to be put in line. Ask your questions. Contact me for more information.

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations. Why choose Microsoft Office? Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation. Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily. Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters. Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management. Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master. Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Fatih
Economics, Finance, and Business Accounting Tutor.
Experienced economics, finance, and accounting tutor. I have a PhD in economics from Georgetown University and I have a BA in economics from Bogazici University. Over the past 10 years I have worked as an Associate Professor of Economics and Finance in various universities and I tutored university students in various economics, finance, and accounting courses. I have students from various universities in US and UK including American University, George Washington University, Nottingham University, King's College London, University of Bath, Northwestern University, University of Royal Holloway etc. Please contact me if you need help in any of your economics, finance, and accounting course.

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools? This course covers the three most popular Microsoft Office products: Word, PowerPoint, and Excel. Designed primarily for beginners, the course also offers support for those already familiar with the basics, helping you achieve proficiency with these tools. The course can be tailored for individual or group learning. With our assistance, you'll be mastering Microsoft Office in no time. If you have any questions, please do not hesitate to contact us.

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.

Pauline
English for Adults / Teenagers / Children (English as a Subject, Business English, Every day English)
My goal is to provide enjoyable learning experiences to my students. I strive to provide an environment which cultivates a culture of confidence, mutual respect, promotion of diversity and equal opportunities. I believe that every student learns in a different way. Therefore I practise a learner-centred approach where my students are strongly encouraged to participate actively in their own learning process.

Chami
Accounting, Business Management and Economics for secondary, high school students and undergraduates
Hi! My goal is to make learning easy for you, not just to pass exams but to develop life skills. If you have the passion to learn any of the above and feel like you could use some effective help - I am the tutor for you! Lessons are structured in a manner to apply the concepts learned in the real world which makes 'understanding' breezy! Class rules; -No rushing. You book me to learn, I accept to teach. I will always give you extra time to learn and understand the lesson. -You let me know in advance, what topic/areas you want to cover. I always lesson-prep, I read any material, questions you send me before the lesson, search for more material/questions to make the class as effective and efficient as possible. -We take it easy. Learning can be fun, so let's keep it that way :)