FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from42.58EUR/ 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 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
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!

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 -04: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 42.58€Online via webcam
from 47.42€At 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 -04: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 42.58€Online via webcam
from 47.42€At 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.

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools ? One of the most popular pieces of software is Microsoft Office. The three most popular Microsoft Office products are Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. All three items in this class of Microsoft Office are covered. Although the focus of this course is on the beginner or entry-level user, if you are already familiar with the Microsoft Office basics, we can still help you become proficient with these tools. With our assistance, you can master the Microsoft Office tools in no time. This class can be adapted for yourself or with others. If you have any further questions, please do not hesitate to contact us.

Maria
ACCOUNTING - ECONOMY - FINANCE - Support in these subjects
I am an accounting and finance professional with a passion for learning and teaching. With solid training and experience in accounting, tax settlement, financial analysis and teaching. You are going to learn how they work and use the tools that I will give you.

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.

Norma
English as a Second and Additional Language Skills
(ESL) English as a Second Language, (EAL) English as an Additional Language, and Business English sessions. Lessons are offered by a tutor who holds a BA degree in languages, and certificates in TEFL, IELTS Preparation, and Business English.

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.

Zanèl
Microsoft Office: Word, Excel, PowerPoint, Outlook
Microsoft Office is used worldwide by a variety of companies. I will empower you starting from scratch to using Office as a pro. I do not use computer terminology that will confuse you, but rather speak in a way that you will comprehend and help you to become the boss of the computer.

Abrar
Business studies classes for All level and Boards online & in person
I have successfully guided numerous students around the globe, from various grade levels and backgrounds to achieve their educational goals. •Currently, I am teaching: 1. GCSE students 2. IGCSE students 3. IB students 4. European School students 5. AS/A level students 6. American curriculum •Boost your understanding: Clear explanations, engaging activities, and practice exercises to solidify your knowledge. Master exam prep: Conquer past papers, tackle tricky concepts, and build confidence for upcoming tests. Individualized approach: Personalized curriculum and learning pace to fit your needs and goals. •Flexible scheduling: Online or in-person lessons to suit your busy schedule. Thanks for visiting my profile.

Leo
Finanzas corporativas y modelos financieros en Excel
Análisis Financieros en general. Proyección de estados financieros (estado de resultados, estado de situación financiera) Indicadores financieros Flujos económicos, cálculo de VAN y TIR Modelamiento financiero en excel Plan Financiero para tesis o trabajos

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.

Fabian
Accounting, Economics and Finance Course for students and adults
I have been an accountant and professor of Accounting, Economics and Finance for more than 15 years and I work in the financial market. I can teach you in an agile and enjoyable way with a focus on reality, from the basic topics to the most complex ones. I teach online Contact me, Kind regards, Fabian

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.

Rafael Andres Altamar
Marketing and sales skills: boost your business
Marketing and Sales Course: Drive your Business towards Success Do you want to learn the most effective strategies to promote your business and increase your sales? Then this marketing and sales course is for you! In this course, you will immerse yourself in the world of digital marketing and the most innovative sales techniques, guided by experts in the field. You will learn how to identify and understand your target audience, develop marketing strategies tailored to your specific needs, and use digital tools to reach your customers effectively. Additionally, you will explore the fundamentals of consumer psychology and how to apply them to influence purchasing decisions. You'll learn how to create persuasive advertising campaigns and use social media and content marketing to build a strong online presence. When it comes to sales, we'll teach you proven techniques to close deals, handle objections, and build lasting relationships with your customers. From the prospecting process to post-sale follow-up, you'll gain the skills necessary to convert potential customers into loyal customers. Whether you are starting your own business or looking to improve your company's marketing and sales strategies, this course will provide you with the knowledge and practical tools you need to achieve success in today's competitive business world. Enroll now and take your business to the next level with our Marketing and Sales course!

Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (children and teenagers)
Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Communication with Teams - Presentations with PowerPoint - Databases with Access If learners are advanced or not interested in any of the above modules, I could happily exclude those modules from the course.

Albert López
Learn how to use Excel and become an expert!
Have you always wanted to learn Excel but don't know where to start? Do you want to advance in your professional career by being a reference in Excel? You've come to the right place! My name is Albert, a professional in the Pharmaceutical Industry with more than 10 years of experience. Excel has been the key to my success both in the professional and personal spheres. Its versatility and ease of use make it an essential tool. Mastering Excel will not only allow you to start projects that you have always wanted to do, but it will also open doors for you in a job market with HIGH DEMAND for Excel experts. What can you expect from my classes? - 100% Online Classes in Spanish, Catalan or English. - Theoretical concepts and practical examples for comprehensive learning. - You will learn from the most basic concepts to the most advanced. - You will master tables, graphs and formats to analyze any type of data. - I will teach you how to create automatic tools and professional reports. Featured Topics: - Simple formulas (sum, average, max, min, count,...) - Advanced formulas (if, addif, vlookup, unref, match, ...) - Graphics (simple and dynamic) - Simple Tables and Dynamic Tables - Filters and Data Validation - Macros and automation - Creation of professional reports Any idea you have can be done in Excel! Feel free to contact me to design a CUSTOM class and take your Excel skills to the next level.