Add to Wish List
Add to Wish List
from375.29CNY/ h
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
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
Extra information
The student can either choose the full course, which will be composed of 10 classes, or a reduced syllabus based on selected modules, or even a single class on a specific topic among the ones presented above.Location
Online via webcam
General info
Skills:
Age: | 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, Italian |
My beginner guitar classes are designed to help you build a solid foundation, whether you're picking up the guitar for the first time or want to revisit the basics.
What You’ll Learn:
- Basic chords and strumming patterns
- Simple songs to practice and enjoy
- Guitar tuning and maintenance tips
- How to read tablature and understand music basics
Why Choose My Classes?
- Patient, supportive teaching approach
- Customized lessons based on your pace and interests
- Flexible scheduling to fit your routine
- A fun and engaging learning environment
Whether you aspire to play for yourself, family, or friends, my goal is to make your learning experience enjoyable and rewarding. Let’s make music together!
Ask a question
Send a message explaining your needs and Edoardo 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 375.29 CNYOnline 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 December 2024
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 375.29 CNYOnline 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
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.
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.
Ray
Digital Skills in IT. Learn how to use Microsoft Word, Excel and PowerPointI can and will teach anyone who has a desire to learn basic digital skills. You will learn basic file management and how to use Microsoft Word, Excel and PowerPoint. You wi learn how to use Google applications as well as how to send Emails.
This class will teach you the basic skills of how to use these application proficiently and efficiently. I will teach how to use MS Word to write letters and create a variety of documents from posters to party leaflets. I will tech you how to use Excel to create tables, charts and how to create formulas. You will also learn how to create presentations using PowerPoint. This is just the tip of the iceberg of what you will learn.
Please contact me to see if we are a good fit.
Tristan
General computing, Excel, Word, PowerPoint, AI (ChatGPT, prompt engineering,...), iPhoneMaster Excel, Word, ChatGPT and simplify your life with my private lessons
Learn how to harness the full potential of AI to transform your daily life and improve your digital skills:
- Job search: Write impactful CVs and cover letters.
- Personal life: Create personalized meal or workout plans.
- Productivity: Automate tasks, write impeccable emails, or manage your projects more efficiently.
- Studies and learning: Structure your revisions and create clear and organized content.
General computing: Optimize your use of Word, Excel and other office tools to gain efficiency.
Accessible to everyone, whether you are a novice or a curious user. In just a few hours, you will master digital tools and skills that will make all the difference in your professional and personal life.
Book your session now!
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.
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.
Said
Microsoft office : Excel / Word for everyone, Online sessionYes, I know you want to learn Microsoft office like Excel, word and PowerPoint, so you can find everything you need about Microsoft office.
I will teach you how draw tables in Excel and how to calculate using different formulas.
I will teach you how to write a text using Word.
I will teach you how present your projects using power point.
Contact me.
Anass
Computer and office training Word Excel and PowerPointHello,
You want to learn the basics of computers or how to use software such as Word, Excel or Powerpoint.
I will give you the skills you need to better understand the features of this software to write, for example, a document.
I will also give you advice on how to make the most of the internet, protect and back up your data, or on the day-to-day use of your computer.
Contact me.
Amine
Microsoft Excel (Formules et création des tableaux et calculs)Une formation selon votre besoin et le niveau sur les fonctionnalités et formules Excel.
Je divise la session sur 2 phases:
Phase 1: Formules Avancées (formules de calculs, formules de logiques, formules mathématiques etc)
Phase 2 : Cas pratique et création des tableaux
Vous serez capable de manipuler les formules avancées
Vous serez capable de les pratiquer dans la création de vos tableaux.
Adil
Excel pour les débutants / Microsoft Excel pour les débutantsJe vous offre des séances pour apprendre l'excel.
Vous allez pouvoir apprendre des différents outils qui vont vous permettre de mettre des tableaux sur Excel.
Par ce cours, vous allez pouvoir calculer par des formules de calcul.
Qu'est ce que vous attendez?
Allez, réservez votre cours.
Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions
Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...
Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.
Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...
I am waiting for your message.
Amine
Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office AutomationI offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.
Jean Marc
Excel course Word ACCESS PowerPoint general ITEXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.
Azzedine
Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données proVous êtes impliqué dans les finances, la gestion, la planification, la gestion de projet, les ressources humaines, ou peut-être même un étudiant ambitieux désireux de perfectionner ses compétences en matière de tableau de bord professionnel. Si vous recherchez une solution qui va au-delà des limitations d'Excel et de PowerPoint, alors vous êtes au bon endroit : permettez moi de vous présenter Power BI.
Avec Power BI, je vous propose bien plus qu'un simple outil. C'est une passerelle vers des rapports interactifs, une gestion efficace des données et une analyse avancée. Voici ce que je peux vous offrir :
- Création et gestion experte de rapports interactifs.
- Transformation et nettoyage minutieux des données pour une précision maximale.
- Utilisation des puissantes formules DAX pour une analyse de données avancée.
- Création de visualisations personnalisées et de tableaux de bord percutants.
- Partage sécurisé et publication de vos rapports pour une collaboration sans heurts.
-Automatisation des tâches répétitives avec Power BI & Power Query.
Peu importe vos besoins spécifiques - qu'il s'agisse de projets professionnels, d'études ou d'aspirations personnelles - je suis là pour vous offrir une solution sur mesure. Ensemble, nous créerons un programme adapté à vos objectifs, vous guidant à chaque étape de votre parcours d'apprentissage.
Que vous soyez un novice cherchant à maîtriser les bases ou un expert désireux d'approfondir vos connaissances en analyse de données, je suis là pour vous fournir l'expertise et le soutien nécessaires pour réussir.
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.