facebook
    Hector
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from28.56GBP/ h

    Teaching Macros or applications in Microsoft Excel

    Translated by Google. Click to view original.
    In this class you are taught everything related to the analysis, design and construction of computational solutions in this spreadsheet.

    The correct way to create macros and process automation in VISUAL BASIC FOR APPLICATIONS (VBA) of Microsoft® Excel is explained.

    Location

    Online via webcam

    General info

    Age:
    Children (7-12 years old)
    Teenagers (13-17 years old)
    Adults (18-64 years old)
    Seniors (65+ years old)
    Student level:
    Beginner
    Intermediate
    Advanced
    Duration:
    60 minutes
    The class is taught in:Spanish, English

    About Me

    Translated by Google. Click to view original.
    Best regard;

    I hereby present myself to you to present my experience in online education, consulting and consulting, and building custom computing solutions.

    I specialize in:
    • Freelance online advice and consultancy 24 hours a day on issues related to management and appropriation of ICT, Web 2.0 services, and computer programming logic and algorithms in the languages: JAVA (IDE: Netbeans, Eclipse, JBlue), C / C ++, C #, PSeint, I3 Processing, DFD, SLE, LPP, Microsoft Visual Basic .NET, Microsoft EXCEL VBA or Microsoft ACCESS VBA.
    • Software development for: desktop or desktop applications, applications for mobile devices (Apps) on Android and video games.

    Education

    Translated by Google. Click to view original.
    I am a systems engineer, three postgraduates in: mathematics education, educational computing and multimedia for education, many, but many diplomas and courses on pedagogy, author of the books: "The fault lies with the programmer version 1.0" available in Google Books and " I thought I knew Excel "(for posting).

    Experience / Qualifications

    Translated by Google. Click to view original.
    University professor with thirty years of experience, I have worked in one (1) college and six (6) universities teaching everything related to computer programming logic and software development.
    Do you want to learn how to program desktop applications in Java, C language, C ++, CSharp (C #), PSeint, Visual Basic .NET, Macros in Excel? Do you want to learn how to program mobile applications in App Inventor 2? My teaching methodology is Project Based Learning (PBL). In this way, to build an application, I will teach you that the really important thing before sitting down to code (by attempt and error) in front of the computer, is the analysis and design of the algorithm (which constitutes 90% of the success of the program to be implemented. ), for this, with an example from the real world, the construction process will be explained: 1. Example with data from the real world, 2. Collection of information on requirements (input data, calculations, output data), 3. Hierarchy of operators (mathematical formulas versus computational formulas), 4. Desk test on a spreadsheet, 5. Constants, variables and data types to use, 6. Algorithm construction, 7. Flowchart, 8. Desk test on paper, 9. Implementation of the algorithm in the chosen programming language, if it is in console mode, it is implemented directly, if it is in form mode, the user interface is drawn on paper (UX) first.

    Ask a question

    Send a message explaining your needs and Hector 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  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
    7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
    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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  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  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
    23              
    from £28.56Online via webcam

    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 2021
    • Phone number verified
    • Google connected

    Availability of a typical week

    (GMT -06:00) Chicago
    MonTueWedThuFriSatSun
    0              
    1              
    2              
    3              
    4              
    5              
    6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
    7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
    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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  Sunday 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  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  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
    23              
    from £28.56Online via webcam

    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

    You are here


    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.

    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.

    Josè
    Master Learning&Training Innovation in the Italian language and mathematics disciplines
    Improve yourself with the Italian language with mathematics applied to a good motivation. I am a native speaker in Italian and have been familiar with Excel for 25 years and have been motivated all my life. Let's develop together a growth path made of tangible results that you can use immediately on a practical level.

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

    Ilesanmi
    Computer Information Technology/ Learn to be a computer literate.
    Technology is now the order of the day, as a computer Instructor for over 10 years with many experiences, I would be happy to help you be a computer literate from beginner to professional. You will learn how to operate the computer starting from the mouse to the system unit. You will learn how to be a data analyst, you will learn so much about the AI tools which is now the popular to the world. I am also happy to adapt our session according to the topic you wish to cover, etc. I am very flexible, my only goal is to help you improve and be a computer literate.

    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.

    Amine
    Introduction to Office Tools: Microsoft Word, Excel and PowerPoint etc 💻
    Course description: Introduction to Office Tools 💼📊📎 This introductory office tools course is designed to provide participants with a solid foundation in the effective use of commonly used business software, such as Microsoft Word, Excel and PowerPoint, as well as other essential applications such as e -emails. 🖥️📧 Graduate teacher in Information Systems and Service Science (Bachelor) and holder of a Bachelor's degree in Computer Networks, as well as an M1 in Digital Systems and Services, I am passionate about teaching essential digital skills to succeed in the modern professional world. 🎓💻 This course covers the basics of creating professional documents, managing data, and designing visually appealing presentations, while emphasizing effective communication via email. By the end of the course, participants will have acquired the skills to use these tools confidently and effectively, improving their productivity and employability. 🚀📈

    Edoardo
    Excel Mastery: From Basics to Advanced Applications
    Excel is more than just a spreadsheet—it’s a powerful tool for data analysis, problem-solving, and automation. This course is designed to take you from foundational skills to advanced techniques, enabling you to harness Excel's full potential in real-world scenarios. Whether you're managing data, building models, or optimizing workflows, this hands-on course will equip you with the knowledge and practical expertise to excel (pun intended) in any professional environment. Introduction & Foundations - Overview of Excel’s interface and advanced formatting tools - Key functions like LOOKUP for efficient data handling Working with References & Logical Functions - Mastering relative and absolute references, INDIRECT function - Using ranges, lists, and logical/information functions Formatting, Functions, & Shortcuts - Conditional formatting for data insights - Text functions and essential keyboard shortcuts Data Import & Advanced Operations - Importing data from external sources - Working with dates, times, and matrices Data Analysis Tools - Creating and managing data tables - Data validation and pivot tables for deep analysis Advanced Functions & Formula Auditing - Math, statistical, and financial functions - Troubleshooting and auditing worksheets Advanced Analysis & Automation - Form controls, regression analysis, and scenario building - Introduction to macros for automation

    Loren
    Microsoft Excel from basic to advanced - specific problem or lessons about various tools
    From simple sums to cost overviews and pivot tables, Excel is a powerful tool that has become an indispensable part of the workplace for many of us! Do you have a specific problem or would you like a general introduction to Excel? Feel free to message me!

    Alberto
    Basic Excel - Intermediate - Advanced. Customized solutions. Oriented to Office Work or students.
    In this Course you will learn everything you need to know about Excel. To get your new job. Forms, functions, tables. dynamic tables. Queries. We can also automate your daily work. You will learn how to update your tables as you receive new information.

    Yasmine
    I have a Master 2 in Audit and management control, I offer Excel courses
    Excel lessons based on exercises. Learn to use formulas, pivots, useful shortcuts. Demonstration and practice via exercises. The lessons depend on the level of the student and depending on their needs, this can be adapted gradually. I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries). As well as experiences in coaching and mentoring in international competitions for students.

    Anas
    Master Microsoft Excel (Beginner - Intermediate - Advanced)
    >>> What is Excel? Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs. >>> What about pedagogy? I favor the learning by doing method >>> Who am I? For information, I am consultant / trainer and certified Microsoft Excel Expert. I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private. >>> Location of the training? The place is to be agreed with the apprentice. Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...) >>> Content of the training I can adapt to your level and your needs in terms of content. Here is a non-exhaustive example of the subjects taught. **** Excel Training (Beginner and Intermediate) **** Part I: Basic Concepts What is Excel? Discover the Excel window. Workbooks, spreadsheets, cells. Use the toolbars, the menu, the help. Part II: Working in a spreadsheet Identify basic concepts Manage cells: capture and copy Set up formulas. Master the modes of referencing cells: absolute, relative. Insert, delete rows or columns, move fields. Part III: Formatting a spreadsheet Format cells: present numbers, text, titles. Define conditional formatting. Print the entire sheet or part. Build the layout: titles, pagination Part IV: Workbook Management Save, edit a workbook. Divide your data over several sheets. Insert, delete, move, copy a sheet. Edit multiple sheets simultaneously Part V: Data Analysis Using Functions Calculate percentages, establish ratios. Perform statistics: AVERAGE, MAX, MIN Apply conditions: SI. Use functions: NOW, TODAY. Consolidate multiple sheets of a workbook with the SUM function. Part VI: Linking spreadsheets Transfer data from one table to another Copy / paste with link. Create summary tables. Part VII: Illustrate with graphics Create a chart from a table Change the type: histogram, curve, sector. Add or delete a series. **** Excel Training (Advanced) **** Part I: Configure Excel Options Set up Excel options. Customize the interface. Part II: Gaining time to present his paintings Define styles, use themes. Define conditional formats. Insert Sparklines charts. Part III: Creating simple and complex calculation formulas Master the various modes of referencing: relative, absolute, mixed. Name cells. Set up simple and complex conditions: IF, OR, AND. Calculate statistics: NBVAL, NB, NB.SI. Use mathematical functions: Sum and SUM. Retrieve data with search functions: VLOOKUP Calculate dates, times: DATE(), DAY() and MONTH() ... Manipulate text: CAPITAL, MINISCULE and CONCATENATE. Protect formulas, sheets or binders. Part IV: Consolidation of data Link multiple cells in a workbook. Manage connections between workbooks. Consolidate tables in a workbook. Consolidate data from multiple workbooks. Part V: Exploiting Data Lists Tris multicriteria. Custom sorting: Numeric, Textual and Chronological. Extract data: advanced filters. Delete duplicates. Part VI: Implementing Pivot Tables / Charts Create charts / pivot tables Group the information by period and by slice. Filter and sort Segment filters Show / hide data. Add ratios and percentages.

    Ashington
    STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALS
    This class covers statistics and statistical methods for data analysis which cuts across all industry and disciplines. Sample topics, Statistical calculations Statistical methods Statistical analysis Quantitative analysis Quantitative analysis techniques Non Quantitative data analysis Research methods Research methods paper section Mathematical analysis Statistical software and spreadsheets like Rsutdio, Excel, SPSS, and many others. and any statistical topic requests by students

    Sufyan
    Learn to use Excel. Student in e-Business teaches Excel.
    Excel is an effective tool when you master it. However, for a neophyte, its operation may seem a little cryptic. My courses are mainly aimed at people with a beginner or intermediate level in Excel. "A good teacher does everything to have no more students". I don't have a predefined method for teaching. Just as a doctor does not give the same remedy to all his patients, I treat each person on a case-by-case basis. What interests me is to be able to advance and improve the student's skills. From cell management to logical and mathematical formulas, including date and time management, table or graphic insertion, or conditional formatting, etc. I can follow a pre-established program or possibly arrange one.