facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
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!

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 $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.

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 $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


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.

Phoenix
Legal and Business English / Native Speaker from the United States / MA TESOL / CELTA / Juris Doctorate / Economics Degree
I am from the United States and have been teaching for ten years in Ukraine, Egypt, and now Georgia. I have a masters in Education, Juris Doctorate from a law school in New York. I also have a CELTA and bachelor's in Economics from the University of San Francisco. Course Overview: This dynamic and engaging course is designed for individuals interested in enhancing their English proficiency within the contexts of law and business. Whether you are an aspiring law student, a current legal professional, or someone looking to improve your academic and business English skills, this class will provide you with the tools and knowledge you need to succeed. Course Content: Legal Reasoning and Vocabulary: Master the specialized vocabulary used in legal contexts. Understand and apply principles of legal reasoning. Develop a strong foundation in the language of the law. Case Law Analysis: Learn how to read and analyze judicial opinions. Understand the significance of precedent and how it shapes legal decisions. Draw from a variety of landmark cases to illustrate key legal concepts. Argumentation and Debate: Practice constructing and presenting logical arguments. Engage in debates on contemporary legal issues. Develop persuasive speaking and writing skills essential for legal practice. Briefing a Case: Learn the process of briefing a case, including identifying key facts, issues, holdings, and reasoning. Develop the ability to succinctly summarize complex legal materials. Practice presenting case briefs to peers for feedback and discussion. Discussion of Legal Principles: Engage in discussions about fundamental legal principles and their application in various contexts. Explore the intersection of law and business through real-world examples. Understand the ethical considerations and professional responsibilities of legal practitioners. Target Audience: This course is ideal for individuals who: •Are interested in pursuing a career in law. •Wish to improve their academic English skills with a focus on legal and business contexts. •Are looking to enhance their understanding of legal concepts and terminology. •Want to develop strong argumentation and critical thinking skills. Benefits of the Course: •Gain a comprehensive understanding of legal vocabulary and reasoning. •Improve your ability to read, analyze, and discuss complex legal texts. •Develop practical skills in argumentation, case briefing, and legal writing. •Build a solid foundation for future studies or careers in law and business.

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.

Patricia
Microsoft Excel for beginners and intermediate, support with your Excel assignment or job
Microsoft excel lessons for beginners and intermediates. I will take you from the start in learning excel. Whether or not using your own examples or projects. I teach you things like working with formulas, formatting, graphs, pivot tables, data logic, data editing. Support with your Excel assignment or project is also possible. In various functions I have gained experience with excel in recent years. I have also designed small applications. I taught myself the basic and advanced steps, after which I followed a small-scale and interactive expert training where mainly many tips and tricks were discussed.

Humayoon
Learn Mathematics to excel with ease and convenient way
Teaching math is not just about numbers rather it is helping students to develop logical thinking, problem-solving skills, and confidence. With patience and creativity, I can make math enjoyable and accessible. I am available and flexible to teach according to agreed terms to meet the challenging task completion.

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.

Siddharth
Accounting and Finance Lesson from Top-Ranked LSE Graduate
Who Am I? I graduated in the top 5% of my advanced finance classes from the LSE, bringing both knowledge and passion to my teaching. I utilize core texts such as Investments by Bodie and Principles of Finance by Brealey to give students a deep understanding of financial concepts and practices. What I Offer: Each session is customized to meet your specific needs, whether you're preparing for A-level exams or GCSEs or just looking to strengthen your grasp of finance and accounting concepts. Key Topics Covered: Accounting Fundamentals: Learn how to read and interpret financial statements, understand accounting principles, and apply them to real-world scenarios. Financial Analysis and Investment Strategies: Explore investment concepts, risk management, and portfolio theory, ensuring you’re well-prepared for advanced topics in finance. My Teaching Philosophy: I believe that effective learning goes beyond rote memorization; it’s about fostering an intuitive understanding of the material. My approach emphasizes the importance of curiosity and a willingness to learn, encouraging students to engage with the content actively. Together, we’ll create a supportive and interactive environment where questions are welcomed, and complex topics become accessible. Your Path to Success: By the end of our tutoring sessions, you’ll not only be well-prepared for your exams but also equipped with valuable skills that are essential for future studies or careers in accounting and finance. Let’s work together to achieve your academic goals and build confidence in your abilities!

Favour Isioma
Learn English for Bussiness, Conversations, and build your confidence
Learning how to teach English as a second language has been a great experience, and I have been able to implement all that I learnt in virtual classrooms. I bring a blend of real life experiences and educational expertise to my classes. In my classes, I foster a supportive and interactive environment where students individual learning needs are prioritized. Whatever English skill a learner is looking improve; or if a learner is looking to build confidence in everyday communication, my goal is to help learners succeed while enjoying the learning process.

Aziz
Training in international accounting IAS/IFRS.
We offer you very enriching training on international accounting standards IAS/IFRS, during this training you will see the main accounting standards with practical exercises and a sophisticated methodology. a methodology focused on practical cases

Gaelle
Launch Your Online Business: From Idea to Success!
Have you ever dreamt of your child starting his own online business? That's exactly why we're here for! 🌱 Transform Your Idea into a Thriving Business 📈 In this dynamic course, we'll guide you through the entire journey of building an online business. Whether you have a brilliant business idea or need guidance in shaping one, we've got you covered. From concept development to market analysis, we'll help you transform your vision into a thriving online enterprise. 💼 Practical Steps to Success 📊 Our class provides practical, actionable steps for every stage of your business journey. Learn the art of crafting a solid business plan, setting up an effective online presence, navigating e-commerce platforms, and developing winning marketing strategies. You'll gain insights into the latest digital trends and tools to stay ahead in the online business landscape. 🚀 Launch with Confidence 💪 The world of online entrepreneurship can be daunting, but we're here to build your confidence. From legal considerations to customer engagement and beyond, we'll equip you with the knowledge and skills to make informed decisions and succeed in the competitive online market. 🌐 Community of Entrepreneurs 🤝 Join a vibrant community of aspiring entrepreneurs. Network, collaborate, and share experiences with fellow classmates. Together, we'll foster innovation and support one another on the path to online business success.

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.

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.

Ritika
Experienced Chartered Accountant, teaching Accounting, Finance and Management subjects at all levels.
The teaching methodology will be based on your course content and your objectives. My aim is primarily to help you with the concepts and application of that knowledge when submitting assignments and answering questions. I am passionate about teaching. I love sharing my knowledge and experience with my students. I am a life long learner and deeply passionate about books and learning new things. I teach students at High school, Undergraduate and Graduate levels.