facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from67.94CAD/ 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 ⊞+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) 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$67.94Online via webcam
from C$75.33At 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) 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$67.94Online via webcam
from C$75.33At 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


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.

Zainab
Business Basics: Introduction to Business
📚✨ GCSE Business Tutoring: Master the Essentials of Business! 💼 Ready to ace your GCSE Business Studies? Whether you're aiming for top grades or just want to build a solid understanding of business concepts, this tutoring course will help you succeed! 🎯💡 What You'll Learn: Business Basics 🏢: Get a clear understanding of how businesses operate, from small start-ups to large corporations. Marketing 📣: Learn about marketing strategies, customer needs, and how businesses promote their products. Finance 💰: Understand how businesses manage money, including costs, profits, and cash flow. Operations ⚙️: Explore how businesses produce goods and services, manage supply chains, and keep things running smoothly. Human Resources 👥: Discover how businesses manage employees, from recruitment to motivation and performance. Why Choose Our Tutoring?: Tailored to You: Lessons designed to match the GCSE syllabus and help you tackle all key topics. Interactive Learning: Engaging sessions that make learning business both fun and easy to understand. Exam Preparation 📅: Focus on exam strategies, key terms, and practice questions to help you perform your best. Build Confidence 💪: Understand the subject deeply so you can feel confident in class and in your exams. Ready to Get Started? 🎉 Let’s boost your business knowledge and help you achieve those GCSE goals! Whether you need extra help with a specific topic or want to revise for your exams, we’re here to guide you every step of the way! 🙌📖

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.

Professeur
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE-
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE- Je donne des Cours d'Excel à distance pour tous les niveaux. J'offre des séances en Excel à distance pour tous les niveaux. J'assure un soutien approfondi et bien supporté par des outils d'apprentissage les plus efficaces. Pour plus d'informations, contactez moi

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.

Said
Microsoft office : Excel / Word for everyone, Online session
Yes, I know you want to learn Microsoft office like Excel, word and PowerPoint, so you can find everything you need about Microsoft office. I will teach you how draw tables in Excel and how to calculate using different formulas. I will teach you how to write a text using Word. I will teach you how present your projects using power point. Contact me.

Anass
Computer and office training Word Excel and PowerPoint
Hello, You want to learn the basics of computers or how to use software such as Word, Excel or Powerpoint. I will give you the skills you need to better understand the features of this software to write, for example, a document. I will also give you advice on how to make the most of the internet, protect and back up your data, or on the day-to-day use of your computer. Contact me.

Amine
Microsoft Excel (Formules et création des tableaux et calculs)
Une formation selon votre besoin et le niveau sur les fonctionnalités et formules Excel. Je divise la session sur 2 phases: Phase 1: Formules Avancées (formules de calculs, formules de logiques, formules mathématiques etc) Phase 2 : Cas pratique et création des tableaux Vous serez capable de manipuler les formules avancées Vous serez capable de les pratiquer dans la création de vos tableaux.

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.

Dani
Clases particulares de Inteligencia Artificial profesor especializado
Hola, Soy profesor con 12 años de experiencia y quiero ofrecer a tu hijo la oportunidad de aprender algo que va a marcar su futuro: la inteligencia artificial (IA). No es solo un tema del futuro lejano; la IA ya está aquí, y conocerla puede darle una ventaja enorme en su educación y, más adelante, en su carrera. Llevo años trabajando con la IA en mis propias empresas y me he formado a fondo, con cursos especializados y un máster en este campo. Mi objetivo es que los chicos y chicas de secundaria, a partir de los 12 años, entiendan cómo funciona la IA y, lo más importante, cómo pueden sacarle partido. No se trata de memorizar conceptos complicados, sino de aprender a utilizar herramientas que ya están cambiando el mundo. En las clases particulares que ofrezco, tu hijo aprenderá a manejar aplicaciones como ChatGPT, Copilot, Runway y muchas más. Veremos cómo automatizar tareas, crear contenido en video, fotos y audio, y mejorar la productividad. Todo esto de manera práctica y divertida, para que cada clase sea una experiencia que realmente disfruten y les motive a seguir explorando. Además, cada clase está completamente adaptada y personalizada según las necesidades de cada alumno. Me aseguro de que el contenido sea accesible y relevante para cada estudiante, para que puedan avanzar a su propio ritmo y sacar el máximo provecho de lo que aprenden. Si estás buscando clases particulares que realmente marquen la diferencia, estaré encantado de guiar a tu hijo en este apasionante viaje al futuro...¡hoy!. ¡Hablemos y organicemos las clases!

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.

Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!
I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations... Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc. Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows... I am waiting for your message.

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.

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.