FavouritesAdd to Wish List
FavouritesAdd to Wish List
from18.00EUR/ h

Learn advance Microsoft excel and vba macro programming with finance examples

This course will help to build your skill in MS excel advance formulas like vlookup, hlookup, sumifs, countifs. Also we will look on analytics side covering Excel pivoting. We will also build small application covering excel formulas, vba macros and finally see the results via pivot reporting. Finally we will cover excel dashboarding also.

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:English, Hindi
You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.
In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.
This course will be focusing on the programming basics. Student can choose his choice of language to learn like python, c#, vb.net or vba. This course will focus base constructs of programming like functions, classes, conditional, decision, repetitive constructs etc.
In this class I would like students to work on the real world time series fore-casting project. Where with the help of AI/ML Deep learning we will build models to forecast in future. We will write fore-casting models which will learn with historical data and then we test the model and see different scores. Finally we will use this model to predict.

Ask a question

Send a message explaining your needs and Shalini 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            Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12          Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13    Tuesday at 13:00    Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14    Tuesday at 14:00    Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15    Tuesday at 15:00    Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16    Tuesday at 16:00    Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17    Tuesday at 17:00    Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18    Tuesday at 18:00    Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from 18€Online 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 May 2023

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6              
7              
8            Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12          Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13    Tuesday at 13:00    Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14    Tuesday at 14:00    Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15    Tuesday at 15:00    Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16    Tuesday at 16:00    Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17    Tuesday at 17:00    Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18    Tuesday at 18:00    Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from 18€Online 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


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.

Salah Eddine
Master Microsoft Excel, Word and PowerPoint from zero to expert!
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: 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 daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Emmanuella
Data Analytics and Visualization (PowerBi, Pivot Tables, etc)
This Microsoft Excel course is designed to equip learners with comprehensive skills spanning from basic data entry to advanced data analysis. Through interactive modules, participants will master essential Excel functionalities, including formulas, functions, pivot tables, and chart creation. With practical projects and real-world case studies, students will gain the expertise needed to excel in diverse professional environments, enhancing productivity and decision-making capabilities.

Youness
Office Automation Training: Excel, Word, Remote Power Point / Online
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me.

Salomé
University graduate gives computer/excel/word/typing lessons
A 32-year-old university graduate, management engineer, with 8 years of professional experience offers her teaching services. Course of (1H) - 1H30 or 2H depending on the subject/level/location Educational and organized teacher with good revision and organization techniques Microsoft Office - excel/word/powerpoint - mail - typing - ... Pedagogue and patient 97% success rate with regular monitoring I come to your home and also teach online Group lessons also possible, with reduced rates from 3! Feel free to contact me for more information ! See you soon

Zain
Excel Mastery Private Sessions - For Job Preparation, Beginner, Intermediate.
Microsoft Excel is an indispensable tool in today's academic, professional, and personal spheres. However, its true potential can only be harnessed with the right knowledge and skills. With my private tutoring sessions, I aim to equip you with the essential Excel skills needed to excel in various facets of your life. Whether you're seeking a comprehensive overview of Excel or focused assistance tailored to specific needs, I am here to guide you through your Excel journey. What I Offer: I provide personalised private sessions that cater to your unique requirements, whether you're looking to gain a broad understanding of Excel or focus on specific applications, such as preparing for a job interview that assesses Excel proficiency. Areas of Expertise: Introduction to Excel: Familiarisation with the Excel interface and ribbon. Navigation through workbooks, worksheets, and cells. Basic data entry techniques and formatting principles. Formulas and Functions: Constructing formulas for various calculations. Utilizing essential built-in functions like SUM, AVERAGE, and IF. Understanding absolute and relative cell references. Data Management: Sorting and filtering data for effective organization. Implementing data validation and creating drop-down lists. Working efficiently with tables for structured data handling. Data Visualization: Crafting visually appealing charts and graphs. Customizing chart elements to convey insights effectively. Applying conditional formatting for data visualization. Data Analysis: Harnessing the power of PivotTables and PivotCharts for data analysis. Performing data consolidation to streamline information. Advanced Techniques: Exploring advanced functions such as XLOOKUP and SUMIFS for enhanced data manipulation. Who Can Benefit: My private sessions are ideal for students, professionals, and individuals seeking to enhance their Excel skills for academic, career, or personal purposes. Why Choose Me: Tailored Approach: Sessions are customised to your skill level and learning objectives, ensuring maximum relevance and effectiveness. Flexible Learning: Schedule sessions at your convenience, and progress at your own pace. Expert Guidance: Benefit from my expertise and guidance as an Financial Analyst who uses Excel on a daily basis. Practical Application: Hands-on exercises and real-world examples facilitate practical learning and skill retention. Ready to Unlock Your Excel Potential? Book a Private Session Today!

Azzedine
Become an expert in Microsoft Excel, Word and PowerPoint, even from scratch!
Boost your productivity and unleash your creativity with Microsoft Office: unleash your potential with every step! If you're looking for a solution to improve your efficiency, stimulate your creativity, and increase your productivity in everyday life, look no further than Microsoft Office. Why choose Microsoft Office? Test your creativity: With Word, Excel, PowerPoint, and other applications, you can unpack powerful tools to create your ideas, which are to create professional documents, create spreadsheets from executives, or give impressionistic presentations. Save time with automation: Excel simplifies complex touches with smart formulas, dynamic cross-tapes, and other smart functions. Accessible: Whether you use, commute, or want to use the office, Microsoft Office is accessible across all your devices, allowing you to work when you need to. Enjoy the Microsoft Office revolution! Don't let everyday obstacles stop you from progressing. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, start working easily, and do new things with Microsoft Office. Continuously progress to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at all levels, whether beginner, intermediate, or advanced.

Ousmane
Computer science, office automation, algorithms and programming
Computer and office courses are learning programs designed to help individuals acquire essential skills in information technology and office software management. These courses are offered in a variety of educational environments, ranging from elementary and secondary schools to colleges and universities, career training centers and online programs. My commitment to this goal extends to the constant search for varied educational resources, participation in specialized training and the creation of stimulating learning environments, in order to ensure a complete and enriching transmission of IT knowledge to my students. students.

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.

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.

Aniket
Certified Trainer For SQL, Excel and Html (Web Development) with 300+ Reviews
- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

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. Excel versions 2010 - 2013 -2016. >>> 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.

Prof.Mendoza
Excel Computer Classes in Silver Spring Wheaton Bethesda Rockville Gaithersburg Maryland Virginia Washington DC
Dear Student, Prof. Mendoza greets you. I train students, entrepreneurs, professionals, small business owners, office staff, and small business staff on various topics, virtually over Zoom. You can learn Basic Computing, Microsoft Office (Word, Excel, PowerPoint...), Google Suite Apps (Docs, Sheets, Slides...) and Basic Automotive Mechanics; among many other courses or trainings. My trainings are given in Spanish. I focus primarily on the Hispanic or Latino community, but I also serve other populations. I mainly serve the DMV area (DC, Maryland and Virginia, USA), but I also serve other locations remotely. Any questions, doubts or comments, feel free to write me the question by message. Kind regards, Prof.Mendoza. Computer classes for adult learners, available in person and online in Silver Spring, Wheaton, Bethesda, Rockville, Gaithersburg, Maryland, Virginia and Washington DC. Classes are in Spanish. Courses offered: a) Classes to learn how to effectively use your computer, manage your files and email, surf the Internet and store your documents securely in the cloud. b) Introduction to computing, Windows, Office (Word, Excel, PowerPoint, Outlook, OneDrive), Google Apps (Google Docs, Sheets, Slides, Gmail, Google Drive). c) IT Fundamentals. d) Other computer courses. e) Administrative courses focused on business management. f) Other courses developed according to the particular interest of the student or business. About classes: • Population served: Young and adult students (must be over 18). • Class language: Latin American Spanish. • Modality: Virtual (online), individually and/or group. Classes are live and with a teacher. For in-person classes, the instructor must be contacted to check availability. • The classes are aimed at those people who did not have the opportunity to finish their primary school, secondary school, or university. You do not need to present any documents or have an academic degree to get started. All that is required is a strong desire to learn, commitment and perseverance to study and pass the content. • Classes are focused on developing practical and technical skills for work. • Upon successful completion of the course, a certificate of attendance or participation will be awarded. Excel Computer Classes in Silver Spring Wheaton Bethesda Rockville Gaithersburg Maryland Virginia Washington DC In-Person and Online Computer Courses and Classes at Adelphi In-Person and Online Computer Courses and Classes in Alexandria In-Person and Online Computer Courses and Classes in Anacostia In-Person and Online Computer Courses and Classes in Annandale In-Person and Online Computer Courses and Classes in Arlington In-Person and Online Computer Courses and Classes in Ashton-Sandy Spring In-Person and Online Computer Courses and Classes in Aspen Hill In-Person and Online Computer Courses and Classes in Baltimore In-Person and Online Computer Courses and Classes in Beltsville In-Person and Online Computer Courses and Classes in Bethesda In-Person and Online Computer Courses and Classes in Bladensburg In-Person and Online Computer Courses and Classes in Brentwood In-Person and Online Computer Courses and Classes in Brookland In-Person and Online Computer Courses and Classes in Capitol Heights In-Person and Online Computer Courses and Classes at Cheverly In-Person and Online Computer Courses and Classes in Chevy Chase In-Person and Online Computer Courses and Classes in Chillum In-Person and Online Computer Courses and Classes in Chinatown In-Person and Online Computer Courses and Classes in Clarendon In-Person and Online Computer Courses and Classes in Clarksburg In-Person and Online Computer Courses and Classes in Colesville In-Person and Online Computer Courses and Classes in College Park In-Person and Online Computer Courses and Classes in Columbia Heights In-Person and Online Computer Courses and Classes at Dupont Circle In-Person and Online Computer Courses and Classes in Eastern Market In-Person and Online Computer Courses and Classes in Ellicott City In-Person and Online Computer Courses and Classes in Fairfax In-Person and Online Computer Courses and Classes in Falls Church In-Person and Online Computer Courses and Classes in Forest Hills In-Person and Online Computer Courses and Classes in Fort Totten In-person and Online Computer Courses and Classes in Franconia In-Person and Online Computer Courses and Classes in Frederick In-Person and Online Computer Courses and Classes in Friendship Heights In-Person and Online Computer Courses and Classes in Gaithersburg In-Person and Online Computer Courses and Classes in Georgetown In-Person and Online Computer Courses and Classes in Germantown In-Person and Online Computer Courses and Classes in Glen Burnie In-Person and Online Computer Courses and Classes in Glenmont In-Person and Online Computer Courses and Classes in Glover Park In-Person and Online Computer Courses and Classes in Greenbelt In-Person and Online Computer Courses and Classes in Hillandale In-Person and Online Computer Courses and Classes in Huntington In-Person and Online Computer Courses and Classes in Hyattsville In-Person and Online Computer Courses and Classes at Kemp Mill In-Person and Online Computer Courses and Classes in Kensington In-Person and Online Computer Courses and Classes in Landover Hills In-Person and Online Computer Courses and Classes in Langdon In-person and Online Computer Courses and Classes in Langley park In-Person and Online Computer Courses and Classes in Largo In-Person and Online Computer Courses and Classes in Laurel In-Person and Online Computer Courses and Classes in Maryland In-Person and Online Computer Courses and Classes in McLean In-Person and Online Computer Courses and Classes in Montgomery County In-Person and Online Computer Courses and Classes in Montgomery Village In-Person and Online Computer Courses and Classes in Mount Rainier In-Person and Online Computer Courses and Classes in Mt Rainer In-Person and Online Computer Courses and Classes in North Bethesda In-Person and Online Computer Courses and Classes in Olney In-Person and Online Computer Courses and Classes in Oxon Hill In-Person and Online Computer Courses and Classes in Potomac In-Person and Online Computer Courses and Classes in Prince George's County In-Person and Online Computer Courses and Classes in Riverdale In-Person and Online Computer Courses and Classes in Rockville In-Person and Online Computer Courses and Classes in Rosslyn In-Person and Online Computer Courses and Classes in Silver Spring In-Person and Online Computer Courses and Classes in Springfield In-Person and Online Computer Courses and Classes in Takoma Park In-Person and Online Computer Courses and Classes in Tysons Corner In-Person and Online Computer Courses and Classes in Virginia In-Person and Online Computer Courses and Classes in Washington DC In-Person and Online Computer Courses and Classes in Wheaton In-Person and Online Computer Courses and Classes in White Oak Computer Classes in Washington DC Courses Excel Computer Classes in Los Angeles, California Courses Excel Computer Classes in Long Beach, California Courses Excel Computer Classes in Riverside, California Courses Excel Computer Classes in San Bernardino, California Courses Excel Computer Classes in San Francisco, California Courses Excel Computer Classes in Oakland Vallejo, California Courses Excel Computer Classes in Chicago, Illinois Courses Excel Computer Classes in Phoenix, Arizona Courses Excel Computer Classes in San Antonio, Texas Courses Excel Computer Classes in Houston, Texas Courses Excel Computer Classes in Brazoria, Texas Courses Excel Computer Classes in Dallas Forth Worth, Texas Courses Excel Computer Classes in Manhattan, New York Courses Excel Computer Classes in New Jersey Courses Excel Computer Classes in Delaware Courses Excel Computer Classes in Miami, Florida Courses Excel Computer Classes in Hialeah, Florida Courses Excel Computer Classes in Providence, Rhode Island Courses Excel Computer Classes in Pawtucket, Rhode Island Courses Excel Computer Classes in Fall River, Massachusetts Computer Classes in Maryland Computer Classes in Virginia Computer Classes at Wheaton Glenmont Computer Classes in Silver Spring Computer Classes in Bethesda Computer Classes in Rockville

Sarah
Office tools (Excel, Word, Power Point, Access)
do you need to improve on Word, Excel or PowerPoint? I am here to give you the concepts and techniques of Microsoft office (Excel, Word, Power-point or Access) adapted to your professional needs. private, professional and complete private lessons in OFFICE: Word (course, practice), Excel (course, practice), Power Point (course, practice), Access (course, practice) ... etc For more information please contact me.