from28.63GBP/ 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
Skills:
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.28.63GBP/ h
Computer programming algorithms and logic
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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £28.63Online via webcam
100% Satisfaction Guarantee
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
- Facebook connected
- Google connected
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £28.63Online 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
Private lessons
online via webcam
Similar classes
Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf RegionDo 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.
Patricia
Microsoft Excel for beginners and intermediate, support with your Excel assignment or jobMicrosoft 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.
Doychin
Excel for Beginners and Intermediates: Formulas, Charts and Pivot TablesDo you want to master Excel to save time and make better decisions? My courses, designed for beginners and intermediates, will teach you how to use key features effectively. My expertise in the Automotive industry will allow you to apply your new skills directly to your professional projects.
Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBAAre 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 advancedLooking 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.
Samuel Oyakhilome Kwasi
Data Analytics Tutorials -- Join the Data Dive: Your Guide to Excel, SQL, Power BI and PythonExcel, SQL, and Python: Essential Tools for Data Analysts
As a data analyst, mastering Excel, SQL, and Python is crucial for effectively extracting, manipulating, and analyzing data. This comprehensive course is designed to equip you with the practical skills needed to excel in these essential tools.
Key areas of focus include:
Excel: Learn advanced Excel techniques, including data manipulation, pivot tables, and data visualization.
SQL: Gain proficiency in SQL for querying databases, extracting relevant data, and performing data analysis.
Python: Discover the power of Python for data analysis, including data cleaning, manipulation, and visualization using popular libraries like Pandas, NumPy, and Matplotlib.
Through hands-on exercises and real-world examples, you'll develop the confidence and expertise to tackle complex data analysis challenges and drive informed decision-making.
Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (adults)Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results.
This course includes one or more of the following modules:
- Documents with Word
- Spreadsheets with Excel
- E-mail with Outlook
- Presentations with PowerPoint
- Communication with Teams
- 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.
Loren
Microsoft Excel from basic to advanced - specific problem or lessons about various toolsFrom 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!
Nadia
Computer Science Basics – Build a Strong Foundation in TechStep into the world of technology with our Computer Science Basics class, perfect for beginners or anyone looking to refresh their knowledge. This course is designed to make complex concepts accessible and engaging, covering essential topics like programming, data structures, algorithms, and more. You'll learn the fundamental principles that drive the tech world, with hands-on exercises that reinforce your understanding. Whether you're aiming to start a career in tech or simply want to enhance your problem-solving skills, this class will equip you with the core knowledge you need to succeed. Join us and start your journey in computer science today!
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. 🚀📈
Yanis
Courses or tutoring in computer science, Microsoft Office, Word, Excel, Powerpoint in GenevaRepeater for over 8 years, my students are only improving their grades.
Satisfied or refunded!
Always save time for the student to bring exercises, theories, homework, failed tests and corrections ...
I am patient, used, cool, flexible and honest.
See you soon!
Yasmine
I have a Master 2 in Audit and management control, I offer Excel coursesExcel 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.
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.
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.
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.