Power BI Essentials Course - Any Experience Level Accepted

Àpd 50.23 $ /h

Dive into the world of data visualization with Power BI. This course is perfect for those looking to create compelling and insightful reports and dashboards. Gain hands-on experience in transforming raw data into meaningful visualizations that drive informed decision-making.

Informations supplémentaires

Must have access to Power BI.

Lieu

En ligne depuis Royaume-Uni

Présentation

Hello, I'm Aaron, a dedicated and experienced tutor with over 5 years of expertise in education. My passion lies in empowering students aged 4-16, guiding them through the intricacies of Maths and English. I specialize in preparing students for 11+ Entrance Exams, ensuring they excel in their academic pursuits.

In addition to my work with younger learners, I bring a wealth of knowledge to adult tutoring, particularly in Microsoft Applications. Whether you're looking to master Excel, Power Apps, Power Automate, Power BI, Alteryx, or SQL, I provide tailored guidance to help you navigate and succeed in these essential tools.

My tutoring approach is characterized by patience, personalized attention, and a commitment to fostering a positive learning environment. I believe in equipping students with not only the knowledge they need but also the confidence to apply it independently.

Let's embark on a learning journey together, where academic success and skill mastery await.

Education

My educational journey has been marked by a strong focus on Accounting and Finance, culminating in the attainment of a Bachelor of Science degree. In both A Level and GCSE examinations, I excelled with distinction, securing 2 A*'s and 6 A's, a testament to my unwavering commitment and academic prowess. Additionally, my achievements extend to the Eleven Plus Entrance Exams, where I earned the top positions, placing 1st and 2nd. These accomplishments not only underscore my proficiency in Accounting and Finance but also highlight my consistent dedication to academic excellence and success.

Expérience / Qualifications

With over 5 years of tutoring experience, I bring a wealth of knowledge and expertise to my role. My academic journey includes multiple A* and A grades, reflecting a strong foundation in various subjects. As an experienced analyst, I specialize in database architecture and data visualization, with proficiency in writing SQL and building dashboards. My skills have been further honed during my pursuit of an accountancy degree. My passion for teaching spans both adults and children, and I have a proven track record of success, having placed 1st and 2nd in my Eleven Plus entrance exams. This diverse and extensive background positions me as a dedicated professional with a holistic approach to education and analytical proficiency.

Age

Enfants (7-12 ans)

Adolescents (13-17 ans)

Adultes (18-64 ans)

Seniors (65+ ans)

Niveau du Cours

Débutant

Intermédiaire

Avancé

Durée

60 minutes

90 minutes

120 minutes

Enseigné en

anglais

Compétences

Microsoft sql server

Microsoft excel

Disponibilité semaine type

(GMT -04:00)

New York

Cours par webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

11+ Comprehensive Tutoring Course for UK Entrance Exams

37.68 $ /h

Dive into Success: Aaron's 11 Plus Mastery Class! Hi, I'm Aaron – your guide to acing the 11 Plus. Having clinched 1st and 2nd spots in my entrance exams, I'm excited to share my firsthand strategies for success. Together, let's navigate targeted lessons, conquer practice exams, and unlock your full potential. Join me on this journey to 11 Plus excellence!

Primary School Maths and English Adventures (Elementary Level)

41.86 $ /h

Make learning maths fun for your little ones! This engaging class is designed for primary school students, introducing mathematical concepts through interactive activities and games. Build a strong foundation for future mathematical success.

Ignite a passion for English in young learners! This class focuses on language development, reading comprehension, and creative writing for primary school students. Foster a love for literature and enhance language skills through interactive lessons.

Anas

4.75

(12)

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

Matías

4.75

(12)

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.

Yanis

4.75

(12)

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

Amin

4.75

(12)

Microsoft Office skills are expected in almost every professional environment — yet most people have never been properly taught how to use these tools efficiently.
This course covers Word, Excel, and PowerPoint at whatever level you need, from basic document formatting to advanced Excel functions and automation.
Excel (most popular):

Formulas and functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more)
PivotTables and data analysis
Charts and professional dashboards
Macros and VBA automation — eliminate repetitive tasks entirely

Word: Professional document formatting, styles, tables, mail merge
PowerPoint: Clean, professional presentation design and structure
This is a hands-on course — we work directly on your files and your real-world tasks, not generic exercises. You'll leave each session knowing exactly how to apply what you learned to your actual work.
Ideal for students, job seekers, administrative professionals, and anyone who wants to stop wasting time on manual work.

Brahim

4.75

(12)

Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views

Salah

4.75

(12)

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.

Carine

4.75

(12)

Diplômée d'un Bachelor en économie, je propose mes services pour donner des cours particuliers et aider des élèves d'école secondaire, maturité et haute école de gestion à préparer leurs examens des branches économiques, de comptabilité et de mathématique. Je suis également à l'aise avec les enfants de l'école primaire pour l'aide au devoir.

N'hésitez pas à me contacter pour savoir si je peux vous aider.

Assim

4.75

(12)

- Distance Excel courses For all levels: ONLINE-

I give Excel lessons remotely for all levels.

I offer remote Excel sessions for all levels.

I provide extensive support and well supported by the most effective learning tools.

For more information, contact me

Farass

4.75

(12)

Online Private Classes in Excel for Beginners

Master Excel from the comfort of your home with personalized, one-on-one training!

Why Choose Our Excel Classes?
✅ Tailored for Beginners – No prior experience needed!
✅ Flexible Scheduling – Learn at your own pace.
✅ Hands-On Training – Practical exercises & real-world examples.
✅ Certification – Get a completion certificate to boost your resume.

What You’ll Learn:
📊 Basic spreadsheet navigation & formatting
🔢 Essential formulas & functions (SUM, AVERAGE, IF, VLOOKUP)
📈 Creating charts & graphs
📑 Data sorting, filtering & basic analysis
💡 Time-saving tips & tricks

How It Works:
1️⃣ Book a Session – Choose a convenient time.
2️⃣ 1-on-1 Live Training – Interactive lessons via Zoom/Teams.
3️⃣ Practice & Improve – Get assignments & expert feedback.

Who Should Join?
🔹 Students 🔹 Professionals 🔹 Job Seekers 🔹 Small Business Owners

📩 Enroll Now! Limited slots available.

Yassine

4.75

(12)

Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

Fatima

4.75

(12)

Master Microsoft Office, the essential tools of the professional world!

Do you want to gain efficiency and confidence with Excel, Word, and PowerPoint? Whether you're a beginner or already familiar with the basics, my customized course will guide you step by step to become independent and efficient.

What you will learn:
Excel: from data entry and formatting to advanced formulas, pivot tables, etc.

Word: Professional document creation, styles, table of contents, mail merge, and advanced layout.

PowerPoint: Design impactful presentations, animations, and visual storytelling techniques.

Why choose this course?
✔️ Adapted progression: from total beginner to advanced user, everyone progresses at their own pace.
✔️ Practical and personalized approach: concrete exercises linked to your personal or professional projects.
✔️ Flexible: online courses, individual
✔️ Complete educational support: documents, tips and personalized follow-up between sessions.
✔️ Certified expertise: experienced trainer with an engineering background and several years of professional training

Hamed

4.75

(12)

Online Private Classes: Microsoft Word, Excel & PowerPoint
Unlock your productivity potential with personalized one-on-one training!

📘 Microsoft Word: Master document formatting, reports, and professional layouts.

📊 Microsoft Excel: Learn formulas, charts, and data analysis with ease.

🎤 Microsoft PowerPoint: Create impactful presentations that impress every audience.

👩‍🏫 Private & Flexible: Classes tailored to your level, schedule, and goals. 🌍 Online Access: Learn from anywhere, at your own pace. 🎯 Practical Skills: Focus on real-world applications for work, study, or personal projects.

👉 Start today and gain the confidence to use Microsoft Office like a pro!

Ladouceur

4.75

(12)

I offer computer courses tailored to your level, using a simple, practical and personalized approach.

As a former developer with nine years of experience, I've created numerous websites for various projects: showcase sites, e-commerce sites, and professional platforms. I can assist you if you want to understand how a website works, create your own, or improve an existing project.

For adults and seniors, I also offer a progressive introduction: using a computer, the Internet, managing emails, digital security, Excel... The goal is to gain autonomy and confidence.

Each session is built around your real needs. We progress step by step, without pressure, with plenty of practice.

4.75

(12)

Suivi 10h00 personnalisé avec un formateur agréé & dédié en visio, évaluation entrée & sortie, progression des compétences, fiche pédagogique & certificat de réalisation

Tout public & collaborateur (assistant(e), souhaitant gagner en efficacité sur Excel et valider ses compétences par une certification reconnue.

Prérequis : Avoir des connaissances de base sur Excel (savoir saisir des données, enregistrer un fichier, effectuer des calculs simples comme l’addition).

Matériel : Ordinateur équipé d'Excel (version 2016, 2019 ou 365).

📚 Objectifs détaillés (par domaine TOSA)
1. Environnement et Méthodes
Naviguer avec fluidité dans le ruban et utiliser la barre d'outils accès rapide.

Gérer efficacement les feuilles de calcul (déplacement, copie, groupement, liaison entre feuilles).

Configurer les options d'impression complexes (zone d'impression, sauts de page, répétition des titres).

Utiliser les raccourcis clavier essentiels pour accélérer la production.

2. Calculs et Formules
Maîtriser les différents types de références (relatives, absolues $, mixtes) pour copier des formules sans erreur.

Effectuer des calculs conditionnels simples et imbriqués (Fonctions SI, SI.CONDITIONS, NB.SI, SOMME.SI).

Croiser des données issues de plusieurs tableaux (Fonctions RECHERCHEV, RECHERCHEX ou INDEX/EQUIV).

Manipuler des données textuelles et temporelles (Fonctions GAUCHE, DROITE, CONCAT, DATE, MOIS).

3. Mise en forme
Appliquer des formats de nombres personnalisés (devises, dates, pourcentages).

Mettre en place des Mises en Forme Conditionnelles (MFC) pour faire ressortir visuellement les indicateurs clés (jeux d'icônes, barres de données, formules dans les MFC).

Utiliser les styles de cellules et les thèmes pour uniformiser la présentation des documents.

4. Gestion des Données et Graphiques
Convertir des plages de données en "Tableaux de données Excel" (Tableau structuré) pour faciliter la gestion et les calculs automatiques.

Trier et filtrer les données (filtres avancés, segments).

Synthétiser de grands volumes de données grâce aux Tableaux Croisés Dynamiques (TCD) : groupements, champs calculés, pourcentages.

Illustrer les données par des graphiques pertinents (histogrammes, courbes, secteurs, graphiques combinés) et les mettre en forme professionnellement.

5 Automatisation

De la mise en forme

🎓 Modalités d'évaluation
Des connaissances acquises précédemment par l’apprentissage, l’étude ou l’expérience

Continue : Cas pratiques et exercices, Quizz, etc, tout au long de la formation avec le formateur, accompagné de la plateforme www.behahu.eu.

Des nouvelles connaissances
Un rapport de progression est délivré à l'apprenant à l'issue

Frank

4.75

(12)

Maîtrisez les outils essentiels de la suite Microsoft Office pour booster votre productivité. Ce cours pratique vous enseigne à créer des documents impeccables sur Word, à concevoir des présentations percutantes sur PowerPoint et surtout à dompter Excel, de la gestion de données aux formules complexes. Adaptée à tous les niveaux, ma méthode repose sur des exercices concrets pour vous rendre autonome rapidement. Gagnez en efficacité professionnelle et transformez votre manière de travailler.