


Trusted teacher
from46.00USD/ 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!
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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
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 $46Online via webcam
from $51At student's home
100% Satisfaction Guarantee
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
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
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 $46Online via webcam
from $51At 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
You are here
Similar classes
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.
Robert
Accounting, finance and economics courses + help for your business planExperienced 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.
Yoseph
English tutor and e-commerce specialist. Let me help you achieve your goalsNative English speaker. I want to help anyone interested in learning English. I have taught in a formal classroom setting in the USA many years ago but primarily focused on one on one classes. Please feel free to contact me with any questions.
Mazuba
Business Studies for the business world.Economics for effective decision making both in personal and international level.The field of economics, business accounting and business management is a powerful field. This is based on the fact that it will give you, on the job training through the construction of knowledge, skills and experience.
In this field you will learn about how successful people manage large organisations that have attained greater success. For instance, you will learn about motivation how it helps employees to work in an effective and efficient manner, and many more.
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!
Teresa García
I teach all branches of Law and EconomicsAvailable online or in person. I have participated in public speaking and graduated from the Double Degree in Business Administration and Management + Law, so my training in both subjects is quite extensive. I work for the government in the financial sector. Classes range from very basic to advanced. 100% personalized classes. Exam preparation and highlights of key points. Contact us for more information.
Cam
Finance, Accounting and Economic lesson for University studentsHi student,
Are you a university student who are struggling in Finance, Accounting and Economics - related courses and needs further help?
Are you looking for a tutor who can help you pass the exams and inspire you to develop the love for Finance?
Then don't hesitate to join my class!
About Me:
I graduated with Cum Laude distinction in Masters Business Administration (MSc BA) - Finance major from University of Twente, Netherlands. I also hold a Bachelor Business Administration degree (BSc BA) in from Erasmus University Rotterdam (top 70th Global rank), GPA 4.0/4.0. I have completed a variety of Finance, Accounting, and Economics-related courses, from the most basic to the more advanced, so I can tailor my tutoring approach based on your level and learning goals.
Besides, I have experience working as university teaching assistant for over 3 courses and tutoring many university students.
Course Highlights:
- Comprehensive Coverage: Dive deep into the core concepts of Finance, Accounting and Economics based on the materials you provided. Examples of topics: Time value of money; Risk and return; Portfolio theory; Financial Statements; Cost accounting; Microeconomics vs. Macroeconomics.
- Problem-Solving Skills: Develop analytical and problem-solving skills that are required to solve financial problems/exercises. Learn to effectively use formulas.
- Real-World Applications: Explore how these concepts are applied in the outside world and understand why it matters to you.
- Flexible Schedule: Choose from flexible schedules to accommodate your university workload and personal commitments. Please propose a few preferences and I will try my best.
Note:
- Please send me the booking request and your materials at least 48 hours before the class.
Mafi
Business (Accounting, Finance, Economics, Entrepreneurship, Logistic)I can help you to understand and practice business in your real life, and also help you to improve your grades.
Accounting, Finance, Economics, Logistic, and Management.
I have been teaching since 2011 and I have completed two masters (MBA and MSc).
You will be able to enhance your grades, and also improve your business. Prepare yourself to be the best employee at your workplace as a accountant, finance officer, economist, or as a logistics manager.
I have education degree and teaching knowledge in mathematics, statistics, and business, and I can teach you by blending mathematics, statistics, and business together. It will be easy for you to understand and learn quickly, and also use your subjects in the real world.
Muhammed
Mastering Engineering Software: Revit, SAP2000, ETABS, and AutoCAD"A Civil Engineer from Zagazig University, I have hands-on experience in using advanced engineering software such as Revit and Navisworks for Building Information Modeling (BIM), structural analysis and design tools like SAP2000, ETABS, and Robot, as well as AutoCAD for drafting and design. I am also proficient in Excel for data analysis and project management. With the ability to apply these tools in real-world projects, I can provide practical examples to help students better understand engineering applications. I aim to deliver an exceptional learning experience in engineering software to help students develop their technical skills."
Eleanor
English (ESL) General English, Business English, SQA exam level Spanish, FrenchHello! I'm Eleanor and I'm excited to help you in your language learning journey!
I'm a fully qualified teacher with over 8 years of experience teaching online and in person to teenagers and adults. Over the past year, I have been teaching English Power Speaking classes and Business English, focusing on specific vocabulary and grammar which have greatly helped my students with situations faced in the world of work.
I'm also a first class graduate in French and Spanish from the University of Glasgow and I would love to help any school student who is preparing for their Nat 5/ Higher or Advanced Higher exams in French or Spanish (also possibility to teach GCSE and A level)
Do you want to :
Improve your communication skills in English?
Know your grammar but don't know how to incorporate it into spoken English?
Learn how to speak in public/ present with topics that interest you?
Gain valuable business vocabulary and communication tips for situations such as meetings, interviews, negotiations or writing emails/ phone calls?
Develop your CV or practise for an interview?
Improve in each skill area such as reading, listening, writing, speaking and grammar in English, French or Spanish?
Then my class is for you! :)
Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBAAre 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.
Zamuxolo
Unlock your potential. Learn English and business English.A tutor with 5 years experience in teaching. English is an international language, that is utilized for massive communication.
Therefore, if you are looking to learn English, improve you're English speaking skills or you want to learn Business English. Look no further! We will focus on grammar, reading, and writing and most importantly communication. Let's start this journey together.
Amin
Microsoft Office tools for beginners, intermediates and advancedLooking 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.
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.
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.