facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from42.86CHF/ 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 -06: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 42.86FrOnline via webcam
from 47.52FrAt 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 -06: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 42.86FrOnline via webcam
from 47.52FrAt 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


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.

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.

Gregory
Private 1on1(or small group) Business English/General English lessons in Paris
I am a Danish-American with a bachelors in International Business and Masters in Economics, offering 1on1 English tutoring in Paris. I have limited time and can only take on a small amount of students. I was born in the United States and speak English as my mother tongue, both colloquially as well as professionally. I offer lessons personalized towards your life and career objectives, ranging from accent training to the usage and comprehension of Business English. Whatever your goal, I am confident we can craft a realistic plan for success. In terms of experience, I have been teaching English on the side here in Paris for 6 years and in Copenhagen before that. I have experience with a wide range of goals, from University students preparing for exams, professionals angling for promotions, to Professors of Dentistry chipping away their accent for a seminar. If this is in line with what you are looking for, give me a call, email or text and we can figure out how best to achieve your English related ambitions. Pricing and availability open to negotiation, I will do my best to both be fair and suit your schedule. I specialize with adults, but can make exceptions for well mannered children.

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.

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.

Miral
Accounting for IGCSE and Undergraduate level financial, intermediate 1 & 2, cost accounting and Managerial accounting
My name is Miral, and I’m an AUC graduate with a major in Accounting. I’m offering tutoring services for university-level and IGCSE students in the following courses: Financial Accounting Managerial Accounting Cost Accounting Intermediate Accounting I & II With years of experience in tutoring, I am committed to helping students excel in their academic journeys. (Online and face to face)

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.

Anas
Private lessons in math - physics - chemistry - engineering science
Hello dear students and participants, As a former teacher, I had the privilege of supporting more than 40 students over the past year in their academic progress. I teach the following subjects: mathematics, physics, chemistry, engineering sciences and Excel. Thanks to my personalized and structured approach, I help my students develop their skills, their self-confidence and their autonomy. By working with me you will learn: *Effective resolution methods, *Intensive practice of exercises, *Educational coaching adapted to your needs, *The development of summary revision sheets, *Career guidance to inform your future choices, *Practical practical work in engineering sciences, to anchor concepts in reality. At the same time, as an information technology consulting engineer, I have in-depth expertise in the technical field, with the ability to design and implement innovative solutions in complex environments. Passionate about aeronautics and piloting aircraft, I cultivate essential qualities such as rigor, discipline and rapid decision-making in dynamic environments. This passion fuels my teaching by adding a practical and inspiring perspective.

Grace
Fashion designing training/classes online or home tutoring
Fashion designing is a fun course which you will be glad you choose, with my depth of experience and knowledge in this field, I can assure you will find every curated course outline very interesting. I am very patient with my students as I allow them to learn at their pace while I help them tap into their creativity. A fun fact about how I impact my knowledge is helping my students see the simplicity in fashion designing as a course by exposing them to unique sewing techniques and superb styling skills. Fashion designing is a very broad and lucrative field. Many of my past students are grateful to me for helping them to maximize and juice out the best of the preferred part they individually have chosen to pursue in fashion designing. Allow me take you on a walk with that will eventually make a wave in the fashion world.

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.

Lineth
Unlock Business Success: Accounting & Economics Simplified
Hello! I’m a dedicated tutor with a strong passion for business studies, accounting, and economics. I believe these subjects are not just about numbers and theories, but about understanding how the world works and how decisions shape our daily lives. Whether you’re preparing for exams or looking to grasp key concepts, I’m here to help you navigate the intricacies of these fields with clarity and confidence. In business studies, I’ll guide you through the fundamentals of management, marketing, finance, and more, helping you understand how businesses operate and succeed. In accounting, I break down complex financial principles into simple, understandable steps, ensuring you get a solid grasp of everything from balance sheets to budgeting. When it comes to economics, I focus on helping you understand both micro and macroeconomic theories, with practical applications that connect to real-world issues. What sets me apart is my patient, student-centered approach. I tailor lessons to your unique needs, making sure you not only excel academically but also develop a deeper understanding and appreciation for these subjects. Let’s make business studies, accounting, and economics not only easier but enjoyable to learn!

Anna
Placement / Grad Scheme Mentor and Career Coach. Learn to ace application processes and secure high grades for competitive roles
Learn how to secure competitive positions at big companies or specific roles at fascinating start-ups with my advice and mentorship! I secured a placement year at GSK, the UK's largest pharma company and a graduate role at Deloitte, one of the big 4 accounting firms in the world that performs a range of business and analytical services. Learn from my first hand experience in the multi-stage applications processes of these large companies alongside my perspective as a member of two biotech start-ups. Eager to share my well-rounded experience across science, tech, innovation and business to help you have the best chance of achieving your career ambitions. Unsure about your future, I also offer career guidance specific to your talents and interests - let's chat!

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.

Ali
I help you understand the accounting principles in the easiest way.
With 7 years of experience in the accounting field and a US CPA, i am able to provide a thorough understanding of the accounting principles and help you get better at it. Sessions are tailored to your needs, after a 15 minute discussion to understand what you’re looking for.