John
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    FavouritesAdd to Wish List
    from44.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

    At student's location: Around Bixby, OK, United States
    Online via webcam

    |
    Use ⊞+wheel to zoom!
    +

    General info

    Skills:
    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

    MonTueWedThuFriSatSun
    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 $44Online via webcam
    from $49At 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

    MonTueWedThuFriSatSun
    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 $44Online via webcam
    from $49At 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)
    Office, in particular Excel and Access, are programs widely used both in industry and in the personal field. It is worth learning. I am used to working with people of different ages. I believe in segmentation, visualization of progress, objective results and practice. Beyond these general lines, there is no rule or magic method. Some things work with some students and not with others. Adapting to needs is really the goal of private lessons. So I will do my best to find what motivates and helps my student.

    Chami
    Private Tuition for Undergraduates & Secondary/High School Economics, Management and Accounting Students
    My goal is to make learning easy for you - not just to pass exams but to develop life skills. If you have the passion to learn any of the above and feel like you could use some effective help - I am the tutor for you! Lessons are structured in a manner to apply the concepts learned in the real world - this makes 'understanding' breezy!

    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.

    Hajar
    Computer courses in Office automation (Beginner, Intermediate, Advanced): "Word", "Excel", "PowerPoint"
    Throughout my engineering student studies, I worked on multiple projects which require mastery of office automation tools ("Word", "Excel", "PowerPoint", ...). I would therefore like to share my knowledge with you, whether you are a student or not, in order to introduce you to office automation, to train you, and to guide you in your projects.

    Sue English
    ENGLISH TEACHER from ENGLAND excellent quality lessons
    Hello, are you looking for an English teacher, qualified from the UK? Do you wish to improve your pronunciation, your grammar and get ready for your job/school? The English lessons here are especially designed to meet your needs. Do you wish to have your work corrected, to work on literature/ business subjects/ linguistics or prepare yourself for an exam? Don’t wait and send me a message. The teacher can prepare you as well for specific examinations like IETLS or specific English programs (A-Levels, GCSE…). Why learning English? English is a worldwide language and you will need to have solid basis in English for your job or for leisure when travelling. Did you know? Knowing an extra language is extremely appreciated by recruiters because not only you are familiar with a foreign language but also you will be open-minded, knowing various cultures. 😊 You have the possibility to have the lessons via Skype (the majority of my students prefer having their lessons online, technology is fun!). If you have further inquiries, don’t hesitate to let me know, it will be a pleasure to help you and present you to your teacher.

    Boris
    Microsoft Excel, Finance, Investments, Economics 🔥 🔥 🔥
    Lessons from an experienced tutor (8 years of tutoring privately and in groups). I have a B.Sc. and an MBA, specializing in Finance and international Business. If you are a student, a professional or just building up your business, then Excel is a MUST tool for you. I can also help you with financial planning, investment portfolios, sensitivity and feasibility analysis for your projects, and much more. Tutoring is either online (Zoom/Skype) or at my place.

    Gainmore
    Accounting & Finance for all from beginners to advanced
    Accounting & Finance Accounting is the process of recording financial transactions pertaining to a business. The accounting process includes summarizing, analyzing and reporting these transactions to oversight agencies, regulators and tax collection entities. Finance is defined as the management of money and includes activities such as investing, borrowing, lending, budgeting, saving, and forecasting.

    Samia
    Économie gestion comptabilité finances marketing management pour tous les niveaux
    Je suis professeur hautement diplômée et expérimentée faisant preuve d'une excellente pédagogie pouvant aider les apprenants en difficulté et je propose mes services pour TOUS LES NIVEAUX du système Français , Tunisien et université : *élèves du Baccalauréat et lycée : Économie, gestion, marketing, finances..... *Niveau supérieur : comptabilité , économie +microéconomie , gestion , finances + toutes les spécialités s'y rapportant Il s'agit de cours particuliers INDIVIDUELS et PERSONNALISÉS avec des supports de cours riches et adaptés à chaque niveau et une excellente pédagogie. Je propose également mon aide pour la préparation de projets , rédaction des rapports et des mémoires , résolution des exercices et différents sujets ..... Les cours sont à Manar 2 ou en ligne avec des horaires flexibles.

    Vanessa
    Français, Anglais, Comptabilité dans la bonne humeur
    J'accompagne des écoliers et des apprentis en français, anglais et comptabilité. J'enseigne aussi le français à des adultes non francophones. Reconnue pour mon sens de l'organisation, ma patience et mes qualités d’adaptation. Je vous propose de travailler dans une atmosphère bienveillante et encourageante, afin de vous permettre de développer la confiance et l'aisance nécessaires pour acquérir les matières travaillées.

    Jay
    MAKING ONESELF HEARD! (For Public Speaking & Presentations)
    Explore Public Speaking through... Intonation and Melody When training for a presentation, decide which words and passages deserve extra attention and increase the tone to emphasize these points. If something sounds exaggerated or false, your audience can turn against you. Volume A speech is not ordinary conversation, and a presenter can’t convey passion and enthusiasm if the words are delivered softly. Clarity Don’t forget to articulate every word, to ensure clarity on your part and understanding on the part of the audience. Emphasis Even in the same sentence, emphasizing different words can change the focus of a message. Changing emphasis can alter meaning and/or implication. Pauses when pauses are placed in strategic spots in a speech, they can make the difference between a good and an excellent presentation. There are several purposes for which pauses can be used: to give listeners a chance to absorb something that’s just been said; to generate expectations about something that’s going to be said... Pacing & Tone If you often get negative feedback about the faster or slower delivery of your speeches, practice delivering a speech sometimes faster and sometimes slower, so you can arrive at a natural pace.

    Joris
    Learn Python - from the basics to real world business cases
    Python is the fastest growing programming language. Master it and you can solve business and science problems! If you are an absolute beginner, don't worry, I've got exercises that will help you get up to speed. About me: I have worked 10 years in financial markets (bond trading and market data). Now I am working as a freelance Python trainer & developer. Favourite Python packages / frameworks: Pandas, Numpy, Flask, Django, Beautifulsoup, PySpark & Pytest,

    Mugdha
    • Business & Financial Accounting • Business Management (including Marketing and Business Strategy) • Maths • Learn to Cook Basic Indian Food
    • I specialise in Accounting and Business Management. In my class I will teach Accounting from the very basic 3 golden rules and build upon the concepts of Accounting upon it. I believe it is important to understand the basic concepts of accounting clearly to enjoy the subject. I will assign homework, conduct regular assessments and create a progress report for my students. • I enjoy cooking and I will teach few very simple Indian Cuisine. I will also share some effective cooking techniques.

    Youness
    Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx
    Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx - Je donne des cours en Sphinx. ( Logiciel Sphinx ). - Grace à cette formation, vous pourrez facilement créer des questionnaires, enquêtes et sondages selon les besoins de votre marché. - Cette formation est accompagneé avec des exemples Pratiques, réels et Concrets. - J'attends votre réservation!!! *** Pour plus d'informations, Contactez moi.

    Stefano
    - Business Accounting - General Accounting - Finance
    I'm a CPA and Registered Auditor from Italy with roughly 15 years of experience in Business accounting and in general Finance under all aspects. During my previous working experiences I've realized that one of my strong point is to explain and teach the fundamentals of accounting and finance in a very direct and simple way, being careful about the characteristics of each single person. So I would like to put my knowledge to the service of students who have difficulties to understand some fundamental principles of the Business Accounting and of the Finance in general.

    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.