Developing Pivot Tables in Microsoft Excel step by step

Translated by GoogleSee original

From 18.59 C$ /h

A pivot table is an advanced tool for calculating, summarizing and analyzing data that will allow us to make comparisons, among other things.

In this course, we will create data slicers to filter our pivot tables, as well as a timeline to filter by date.

Location

Online from Ecuador

About Me

Economist and Systems Engineer.

Multifaceted Professional, Payroll Technician, Financial Analyst, Graphic Designer, Creative Director, Web Development, Professional Trainer in Advanced Excel and Business Intelligence Tools, Project Management, Bakend and Frontend Developer, Data Analyst.

Education

1999 -2005
SYSTEMS ENGINEER
Eloy Alfaro Secular University of Manabi

2007 -2012
ECONOMIST
Eloy Alfaro Secular University of Manabi

KNOWLEDGE
Data Analysis: Advanced Excel, Power Query, Power BI, Qlik Sense.
Graphic Design: Corel Draw, Photoshop, Illustrator, Page Maker.
Web Development: WordPress, PHP, MySQL.
Programming: C#, .Net, Angular, Node, Ionic, Flutter.
Database: SQL, MongoDB.
ERP and CRM: Microsoft Dynamics AX, Zoho CRM.
Methodologies: SCRUM

Experience / Qualifications

CREATIVE DIRECTOR AT JOSSDIGITAL SOLUTIONS
March 2004 - Present.
Graphic Designer, Web Development, BackEnd and FrontEnd Developer,
Implementation and maintenance of networks and servers, Trainer
Professional in Programming, Graphic Design; Advanced Microsoft Excel and
Business Intelligence Tools.

HEAD OF SYSTEMS AT BILBO SA BILBOSA PACKING BOX
February 2015 - Present.
Systems Manager in charge of the automation and systematization of all the
production processes of the company and other IT projects; Database
Data, Systems, Servers, Telecommunications, Information Analysis and
security, Implementation processes among other tasks, Maintenance and
Server implementation.

FINANCIAL ASSISTANT AT PACKAGING BILBO SA BILBOSA
May 2014 - February 2015.
Performance of various tasks specific to the financial area, including Accounts Receivable
Pay, Cash Flow among others.

HUMAN RESOURCES ASSISTANT AT SEAFMAN CA
March 2012–February 2014.
Performance of various functions in the Human Talent area; fulfilling
specific functions in the Payroll area, such as control of permits, positions
internal, discounts and payments to collaborators.

TEACHING COORDINATOR-SEMINARIAN AT UNILIT-MANTA
January 2000–Present.
Professor of Utilities, Graphic Design, Computer Maintenance,
Implement Networks, Web Page Design, Computerized Accounting and
Systems Programming. Teaching Coordinator

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

30 minutes

45 minutes

60 minutes

90 minutes

120 minutes

The class is taught in

Spanish

English

Skills

Microsoft excel

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Matías

4.88

(84)

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.

Jean

4.88

(84)

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

Salah

4.88

(84)

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.

Salomé

4.88

(84)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Amar

4.88

(84)

Unlock the beauty of the Arabic language from the comfort of your home. With personalized lessons tailored to your pace and schedule, you'll gain confidence and fluency in no time.

🌟 What You’ll Get:
✅ Engaging, interactive lessons
✅ A supportive, experienced instructor
✅ Flexible timings to fit your lifestyle
✅ Customized resources for faster learning

Whether you're starting from scratch or polishing your skills, this is your chance to achieve your goals. Don't wait—take the first step toward fluency today!"

Rayah

4.88

(84)

Master Microsoft Word, Excel and Power Point with Personalized Online Private Lessons!
Boost your confidence with one-on-one Microsoft Word, Excel and Power Point classes tailored to your level and goals. Whether you're a beginner or advanced, our flexible online sessions fit your schedule and focus on what you need today from the comfort of your home!

Farass

4.88

(84)

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.

Yassin

4.88

(84)

Master Word, Excel & PowerPoint with Private Online Classes!
Boost your productivity and skills with one-on-one sessions tailored to your level and goals. Learn at your own pace—from beginner to advanced. Perfect for students, professionals, and job seekers!

✅ Personalized Lessons
✅ Flexible Scheduling
✅ Real Projects & Practical Skills

Book your class today and start mastering Microsoft Office!

Fatima

4.88

(84)

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

Mohammed

4.88

(84)

Online Private Classes in Microsoft Word, Excel, and PowerPoint

Boost your productivity and master essential office skills with personalized one-on-one online training in:

Microsoft Word – Document formatting, tables, mail merge, and more.

Microsoft Excel – Formulas, pivot tables, data analysis, and automation.

Microsoft PowerPoint – Professional presentations, animations, and design tips.

✅ Flexible schedules
✅ Customized lessons
✅ Beginner to Advanced levels
✅ Certification guidance

📩 Contact us today to book your session!

Youssef

4.88

(84)

Master Microsoft Office with Expert Online Private Classes! 🔹

Boost your skills with one-on-one training in:

📝 Microsoft Word – Professional document formatting, tables, mail merge, reports, and more.
📊 Microsoft Excel – Formulas, functions, pivot tables, charts, data analysis, and macros.
🎨 Microsoft PowerPoint – Stunning presentations, animations, slide design, and storytelling.

Why Choose Our Classes?
✔ Personalized Lessons – Tailored to your skill level & goals.
✔ Flexible Scheduling – Learn at your own pace, anytime.
✔ Practical Training – Real-world exercises & tips.
✔ Certified Instructors – Experienced & patient teachers.

Alishaan

4.88

(84)

This course is designed for learners ready to move beyond the basics and master advanced accounting principles. You will explore complex topics such as consolidated financial statements, auditing practices, cost accounting, and in‐depth financial analysis. Through practical examples and step‐by‐step guidance, the class equips you with the skills needed to interpret sophisticated financial data, strengthen decision‐making, and prepare for professional qualifications or career advancement in accounting and finance.

Laeticia

4.88

(84)

Hello,

I offer personalized courses in:
- Excel (basics, advanced functions, pivot tables, automation...)
- VBA (macros, automation, file optimization)
- Python (basics, scripts, data, programming logic)

I graduated from Paris-Dauphine University with a Master's degree in Economic and Financial Engineering, and I adapt my lessons to your level and objectives:
- Complete handling
- Help with a specific project or file
- Understanding of key concepts
Courses can be taken in person or online.
Feel free to contact me to discuss your needs or schedule an initial meeting!

Sahbi

4.88

(84)

Master Excel easily, whether for your classes, school projects, or professional needs. These courses are designed for all ages, from elementary to high school, and are available in French and Arabic.

You will learn :
The basics of Excel: tables, cells, formulas
Essential functions: SUM, AVERAGE, VLOOKUP, IF...
Creating graphs and formatting data
The application of Excel to the school curriculum and practical exercises

Each course is personalized according to the student's level and needs, with practical exercises and concrete examples to better understand and retain information.

Individual or small group online courses
Educational materials (PDFs) and explanatory videos
Practical exercises adapted to the school curriculum
Personalized support to assess and improve skills

At the end of the course, a project is completed.

Sheersh

4.88

(84)

These Microsoft Excel classes are designed to help students, freshers, and working professionals build strong Excel skills that are directly applicable in real corporate environments. The course focuses on hands-on learning, real business scenarios, and practical problem-solving rather than just theoretical functions.

With guidance from an industry professional currently working as a Pricing Analyst at Honeywell International, learners will gain exposure to how Excel is actually used in analytics, pricing, operations, and business decision-making.

What You Will Learn:

● Excel basics: interface, formatting, shortcuts, and productivity tips

● Data handling: sorting, filtering, data validation, and cleaning

● Core Excel formulas: IF, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS

● Advanced Excel techniques for analysis and reporting

● Pivot Tables & Pivot Charts for data summarization

● Dashboard creation using Excel

● Automation using formulas and Excel tools to reduce manual work

● Real-world use cases from finance, pricing, sales, and operations

● Best practices used in corporate reporting and decision support

Teaching Approach:

● Step-by-step explanation from basic to advanced level

● Practical exercises using real business datasets

● Focus on speed, accuracy, and efficiency

● Industry examples from global organizations.

● Personalized attention based on the learner’s background and goals

Who Should Join:

● Students and fresh graduates looking to build strong Excel skills

● Working professionals aiming to improve productivity and reporting

● Aspiring data analysts and business analysts

● Anyone who wants to use Excel confidently in real-world scenarios

By the end of the course, learners will be able to analyze data effectively, create professional reports and dashboards, automate repetitive tasks, and use Excel confidently in their academic or professional work.