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

    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

       LinkedIn   

    Pavan
    VBA (Excel, Word, Outlook) training with Practical Sessions
    VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results. Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc... Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

    Vishakha
    Business School exam preparation, masters, MIM, Grande Ecole
    Hello, I have finished Masters in Financial Economics and Masters in Corporate Finance and Banking from EDHEC Business School, Grande Ecole. I offer courses to help students excel in Corporate Finance, Accounting, Strategy and Management. I make it a point to provide easy examples and explanations to help students remember things; specially for students who don't have english as their first language. The courses will be designed to help the student overcome his/her weakness in a particular subject. Additionally, I also focus on communication and soft skills for holistic development and easy admission into universities. I understand university education in and out, for any help in joining one, or surviving one; Vishakha to the rescue :) Each successful student is a smile on my face :)

    Suranjit
    English Language and Grammar for all classes of students and for TOEFL IELTS GMAT GRE and Computer Progam (Word, Excel, Powerpoint Internet.
    Teaching English Language in India and Bangladesh for 15 Years, Specialized in English Language and English Grammar Teaching for all classes of students and for the students who wants to sit for the exam of TOEFL, IELTS, SAT, GRE, GMAT etc. I will show some techniques and some rules by which a student can easily excel in Reading, writing, speaking and listening. I can teach from primarily levels to tertiary levels so that any weak student can easily learn English Language as a Native speaker can. I have invented some rules of English Grammar after completing B.A Honors and Masters in English Language from Rajshahi University, Bangladesh, India. I will give homework but you can learn all at the time of teaching with pleasure, The technique which you have never got in your life i will teach you and will never forget in your life. I can teach in Computer Basics, and Program Microsoft Word, Excel, Access, Power point, Operating System, Visual Basics, Internet Browsing.

    Bicky
    Accountancy Tutor from London (ICAEW, ACCA, CIMA).
    I have been teaching different types of students on different levels since 2008 and my fundamental objective is to get them through decently. Considering myself as a problem solver for students has given me an edge over others and has made me confident. Equipped with a strong working knowledge of real world accountancy & finance has conceptually made me very clear with the subjects of listed professional bodies. Post exam qualified experience has enabled me to evaluate students' understanding on particular subjects and then deciding the level of approach. Students who are novices would be given attention from the basics & those who are familiar with the concepts and need a little push, would be moved directly on to past exam papers and examination kit. I am patient and committed to my students. I firmly believe in assessing the student's understanding on a particular subject, level of competence and then hitting the high notes, giving top priority to exam techniques, question bank and past papers. My students come from different walks of life. From Domestic to International, Privately funded/State funded, Students include from top 10 accountancy firms: KPMG, EY, Grant Thornton etc... University students covered from the following institutions: Birmingham LSE Manchester Coventry Warwick Aston

    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.

    Muhammad
    Private lessons specializing in Accounting, Finance, and Financial Management
    I am specialized in accounting and finance. I am currently completing my PhD degree in the field of Finance from University Clermont Auvergne, France. I also have two master's degrees in Business Administration (MBA) and Accounting and Finance. Furthermore, I have a two years experience as an Auditor in a bank. My goal is to keep students challenged, but not overwhelmed. I assign homework after lesson and provide periodic progress reports. Please note that I will teach in English.

    Syed Abdul
    Tutoring (Math, CAD, Excel, Primavera), Experience Pakistani and Indian foods
    I have an experience in teaching maths and other subjects for about 10 years. I have professional experience of 5 years also in Production Manufacturing and Project Management sector. I know how to cook Indian and Pakistani dishes. I can give you a company also.

    Chami
    Private Tuition for Undergraduates & Secondary/High School 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!

    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.

    Dr S Iyer
    One-on-One Online tutoring in Finance, Investments, Accounting, Economics by an experienced tutor for all levels: Bachelors, MBA, CFA, FRM
    I am Dr S Iyer-a tutor with over 16 years of teaching experience as of 2020 and students from across the globe. I teach one-on-one online (over Zoom/ Skype/ Google Meet) using a pen tablet and the screen-share feature. I teach from high school level to Masters level including professional certifications. I have helped several students from various parts of the world do remarkably well in several subjects like Corporate Finance, Investments, Accounting, Microeconomics, CFA, FRM. But more than that, I trust that if I can replace fear of a subject with love for it, then I would have truly made a difference to the student.

    Boris
    Microsoft Excel, Finance, Investments, Economics, Math
    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.

    Michael
    Private lessons in accounting, finance or mathematics - personal development - meditation
    Introductory course, repetition and / or consolidation of knowledge in economic branches, accounting, finance. Support for more than 20 students in 2019. Help as a summer camp facilitator / monitor. Personal development assistance, from beginner to advanced for meditation.

    Syed Muhammad
    Online classes for Economics, Finance and Accounting.
    I am a PhD student in development economics. My Masters was in Economics and Finance. I have a good grip on these subjects and can help students understand different topics. I can teach Micro and Macro economics, financial accounting, analysis of financial statements, and English.

    Andrea
    Business English for Work, Business Communication, Business English, Presentations, Job interviews, Business Writing
    Are you finding it difficult to express yourself at work in English in front of your international colleagues and clients? • Are you struggling to communicate with colleagues and clients confidently? • Do you find it difficult to explain things to others? • Are you having a hard time taking part in meetings? • Do you feel nervous when you have to give a presentation? • Are you frustrated when you have to say your opinion? • Are you stuck because you don't understand people on the phone? Hi, I am Andrea, a professional Business English tutor and coach. I have a Masters in Teaching English and postgraduate certificates in Pedagogy, Business Communication and Academic Writing. I have been successfully coaching Business professionals at all levels for over 15 years.

    Loic
    Courses or tutoring in management and accounting
    Courses or tutoring in management and accounting for all students of business schools in Geneva (public or private). Matu / CFC base or expanded. Repetiteur for over 8 years, my students are only improving their grades. Satisfied or refunded!