Developing Pivot Tables in Microsoft Excel step by step

Translated by GoogleSee original

From 11.6 € /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 -04: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

(85)

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

(85)

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.

Amin

4.88

(85)

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.

Salah

4.88

(85)

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.

Amine

4.88

(85)

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

Assim

4.88

(85)

- 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

Yasser

4.88

(85)

Are you ready to embark on a journey to fluency? Our online French classes are designed for learners of all levels, from beginners to advanced speakers. With engaging lessons, experienced instructors, and interactive resources, you’ll build the skills you need to communicate effectively in French.

Join a supportive community where you can practice speaking, listening, reading, and writing in a fun and dynamic environment. Whether you’re preparing for travel, work, or personal enrichment, our classes will empower you to express yourself with ease and confidence.

Don’t let language barriers hold you back. Sign up today and take the first step toward speaking French fluently!

Issa

4.88

(85)

Ready to unlock the beauty of the Arabic language? Our online Arabic classes are designed for learners of all levels, from beginners to advanced speakers. With our flexible, self-paced format, you can learn Arabic anytime, anywhere, fitting your language studies into your lifestyle.

Led by expert instructors, our interactive lessons will help you build confidence in speaking, listening, reading, and writing Arabic. Whether you’re learning for travel, career, or cultural enrichment, our classes provide the tools you need to succeed.

Don’t wait to start your Arabic journey—sign up today and learn Arabic anytime, anywhere!

Rayah

4.88

(85)

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

(85)

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

(85)

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.

Brent

4.88

(85)

Stuck in Excel? Want to finally understand how those formulas really work? Do you need to create a pie chart of your expense report for work or school, but feel completely lost? Don’t worry! I’m here to help... at your pace, with no jargon or complicated explanations.

Whether you:
- are starting completely from scratch,
- already have some basic knowledge,
- or want to solve a specific problem,
we’ll tailor the session to your needs. No one-size-fits-all course, just practical help that actually works for you.

👨‍🏫 About me
I’ve been using Excel since I was a teenager — for personal use (like budgeting tools or calorie trackers) and professionally as part of my work and studies in data analysis. Thanks to my experience and structured approach, I explain Excel in a clear and understandable way. I know how frustrating it can be when something technical doesn’t work... and how satisfying it feels when it finally clicks.

🎯 Topics we can cover
- Smart formulas (IF, VLOOKUP, INDEX, MATCH, etc.)
- Creating charts, pivot tables, and dashboards
- Using Excel for budgeting, planning, or managing projects
- Data analysis and basic programming in Excel
- Preparing for Excel tests or improving job-related Excel skills

💻 Practical info
- Having your own laptop/PC is helpful, but not required
- Online or in-person sessions possible
- Have specific questions or files you’d like to work on? Let me know! I also have my own practice materials.

Feel free to send me a message with your question or goal. I’ll gladly look at how I can help you out!

Noreino

4.88

(85)

The class is designed to help beginners learn how to use Microsoft Excel confidently for work, school, and personal projects.
Students will learn how to organize data, use basic formulas, create tables, format spreadsheets, and analyze simple information. The lessons focus on practical, real-life examples such as budgets, expense tracking, reports, and basic data analysis.
By the end of the course, students will be able to work with Excel efficiently, understand common functions, and create clear and professional spreadsheets.
The course is suitable for complete beginners and anyone who wants to improve their Excel skills step by step. Lessons are tailored to each student’s pace and learning goals.

Abdallah

4.88

(85)

Statistics is a cornerstone and a very important entry point for many sciences such as data analysis, artificial intelligence, and machine learning.
In this course, we will learn together how to gain a deep understanding of the various statistical concepts that are important for every researcher or statistician.
This course will include an explanation of:
1- Descriptive statistics and measures of central tendency and dispersion
2- Introduction to Probability Science
3- Correlation and Regression
4- Inferential statistics and statistical hypothesis testing

Yasser

4.88

(85)

Boost your digital skills with personalized online private classes in Microsoft Office! Whether you are a beginner or want to improve your professional skills, these lessons are designed to help you master essential tools such as Word, Excel, PowerPoint, and Outlook.

With over 14 years of teaching experience, I provide clear explanations, practical exercises, and step-by-step guidance to ensure you gain confidence using Microsoft Office for work, studies, or personal projects.

✅ Learn at your own pace
✅ Personalized lessons adapted to your needs
✅ Practical tasks and real-life examples
✅ Flexible schedule and supportive learning environment

Develop the skills you need to create professional documents, analyze data, design presentations, and manage emails efficiently.

📩 Contact now to start your Microsoft Office learning journey!