□
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint | G-Talent.Net

¡Rebajas de Navidad! | Avanza en 2025 | Todos los cursos por solo $9.99 USD. ¡Finaliza hoy!

Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

Master the most essential productivity tools with our course, 'Mastering Microsoft Office 2021-365.' Learn to fully utilize the advanced features of Word, Excel, and PowerPoint to create professional documents, dynamic spreadsheets, and impactful presentations.

 

Por Sekhar Metla | Developer and Lead Instructor

👥 100
$9.99 USD $59.99
Finaliza en:
Un Pago, Todos los Cursos con PLUS

Garantía de reembolso de 30 días

Este curso incluye:

▪️ 8h 05m de duración bajo demanda

▪️ 134 lecciones

▪️ 1 recursos descargables

▪️ Disponible en dispositivos móviles

▪️ Acceso para siempre

▪️ Idioma:

  • Ingles

▪️ Consultas ilimitadas

✦ Bonus: Set of Downloadable Guides

⚑ Certificado de finalización

Lo que aprenderás

🟧 Learn the essential Microsoft Office Skills in these three courses: Word, Excel, and PowerPoint.

🟧 How to use Microsoft Word to create, format, and edit documents.

🟧 Learn to use Microsoft Excel to create, format, and analyze data in spreadsheets.

🟧 Apply new and improved features in Excel 2021 and Office 365.

🟧 Work with styles, templates, tables, and images in Word.

Contenido del curso
U1: Getting Started
  • Introduction
  • Getting started on Windows, macOS, and Linux
  • How to ask great questions
  • FAQ’s
U2: Excel 2021: Basics
  • Excel Overview
  • Start Excel Spreadsheet
  • Enter Text and Numbers
  • Relative References
  • Working with ranges
  • Save and Save as Actions
  • File Extensions, Share, Export, and Publish files
U3: Excel 2021: Rows, Columns, and Cells
  • Adding Rows and Columns
  • Modifying Rows and Column lengths
U4: Excel 2021: Data Handling
  • Adding Rows and Columns
  • Modifying Rows and Column lengths
U5: Excel 2021: Page Setting Up and Print
  • Page setup options
  • Fit to print on One Page
  • Print Workbooks
U6: Excel 2021: Sorting and Filtering
  • Sorting Data Ascending Order
  • Sorting Data Descending Order
  • Filter Data
U7: Excel 2021: Writing Formulas
  • Creating Basic Formulas
  • Datetime Formulas
  • Mathematical formulas phase1
  • Mathematical formulas phase2
U8: Excel 2021: Advanced Formulas
  • VLOOKUP formula
  • HLOOKUP formula
U9: Excel 2021: XLOOKUP only for 2021 and Office 365
  • XLOOKUP
  • Handling #NA and Approximates match in XLOOKUP
U10: Excel 2021: Data and Tools
  • Split Text into columns
  • Flash Fill
  • Data Validation
  • Remove Duplicates
  • Import Data from Text files
  • Import Data from .CSV files
U11: Excel 2021: Formatting data and tables
  • Formatting Font
  • Formatting Alignment
  • Formatting Numbers
  • Formatting Date
  • Formatting Tables
U12: Excel 2021: Pivot Tables
  • Pivot Tables
  • Pivot Charts
U13: Excel 2021: Charts
  • Excel Charts – Categories
  • Elements of a chart
  • Creating Charts
  • Column or Bar charts
  • Formatting charts
  • Line Charts
  • Pie and Doughnut charts
U14: PowerPoint 2021: Course Introduction
  • Overview
  • Start PowerPoint Presentation
  • Screen setting and Views
U15: PowerPoint 2021: Basics
  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Save a Presentation
  • Print Slides
U16: PowerPoint 2021: Text and Bullet Options
  • Formatting Text
  • Slide Text Alignments
  • Multi-Column Text Alignments
  • Adding Bullets and Numbered List Items
U17: PowerPoint 2021: Adding Graphic Assets
  • Insert Shapes
  • Insert Icons
  • Insert Graphics
  • Add 3D Models
  • Insert Pictures
U18: PowerPoint 2021: Picture Formatting
  • Picture Options
  • Picture Cropping
  • Applying Built-in Picture Styles
U19: PowerPoint 2021: SmartArt Graphics
  • Add SmartArt Graphic
  • Modifying SmartArt
  • Creating a Target Chart using SmartArt
U20: PowerPoint 2021: Working with Tables
  • Create a Table on Slide
  • Formatting Tables
  • Inserting Tables
U21: PowerPoint 2021: Working with Charts
  • Add a Chart
  • Formatting Charts
  • Insert Chart from Microsoft Excel
U22: PowerPoint 2021: Adding Multimedia
  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Screen Recording and Adding
U23: PowerPoint 2021: Working with Transition
  • Applying Transitions to Presentation
U24: PowerPoint 2021: Animation
  • Object Animation
  • Effect Options
  • Advanced Animation
  • Triggers to control animation
U25: PowerPoint 2021: Slideshow Effects
  • Onscreen Presentation
  • Hiding Slides
  • Changing Order of Slides
  • Copying Slides
U26: Word 2021: Introduction
  • Overview of MS Word
  • Start MS Word 2021
U27: Word 2021: Basics
  • Create a new blank document
  • Creating a paragraph text
  • Non-printing characters
  • Save a document
  • Open a document
  • Find and replace
U28: Word 2021: Word Formatting
  • AutoCorrect options
  • Formatting text
  • Copy cut and paste
  • Character formatting
  • Format painter
  • Work with numbers
  • Add bullets
  • Outline creation
U29: Word 2021: Tables
  • Creating a table
  • Adding rows and columns to a table
  • Formatting table data
  • Borders and shading
  • Sorting in a table
  • Draw a table
  • Convert text to table
  • Convert table to text
  • Insert a spreadsheet
  • Quick tables – readily available formats
U30: Word 2021: Styles
  • Working with styles
  • Creating styles
  • Clear formatting
U31: Word 2021: Page Layout
  • Margins
  • Orientation
  • Page size setting
  • Adding columns
  • Page break – section break
  • Adding watermark
  • Headers and footers
U32: Word 2021: Envelops and Lables
  • Create envelops
  • Creating labels
U33: Word 2021: Mail Merges
  • Creating a mail merge document
U34: Word 2021: Review and Printing
  • Thesaurus and spell check
  • Word count
  • Speech - read aloud
  • Language - translate
  • Tracking
G-Tools: For students
  • Exclusive access to cutting-edge tools for students: improve your employability, participate in exclusive events, take advantage of our smart virtual assistant and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Recursos descargables:

📎 Downloadable material:

▸ Set of 1 coding exercise.

Descripción

✔️ Unlock the full potential of Microsoft Office with "Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint"—a comprehensive course designed to empower you with advanced skills in the most essential productivity tools. Whether you're a student, professional, or entrepreneur, this course will take your abilities to the next level, enabling you to work smarter and more efficiently.

Start with Microsoft Excel, where you’ll transform raw data into actionable insights. Learn the fundamentals of data organization, calculations, and visualization. Progress to advanced topics like pivot tables, conditional formatting, and powerful functions such as VLOOKUP, HLOOKUP, and IF statements. Excel automation with formulas will also be introduced to save time and boost productivity.

Move on to Microsoft PowerPoint to create stunning presentations. Learn to design slides with impactful layouts, animations, and transitions. Discover how to embed multimedia, collaborate in real-time, and deliver presentations that leave a lasting impression.

Finally, dive into Microsoft Word, where you’ll learn to create polished, professional documents. Master essential features like formatting, styles, tables, and templates. Explore advanced capabilities like mail merge, collaboration tools, and integrating graphics and charts to make your documents stand out.

Throughout the course, you’ll engage with hands-on projects and real-world examples to reinforce your learning. By the end, you’ll be proficient in using Word, Excel, and PowerPoint, ready to tackle personal, academic, and professional tasks with confidence.

Take your productivity to the next level—enroll now and master Microsoft Office 2021-365 today!

Empresas de todas las industrias invierten en el desarrollo de sus equipos con este curso de G-Talent y Sekhar Metla

Customer Reviews

Be the first to write a review
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

Sekhar Metla

Developer and Lead Instructor

Sobre Sekhar Metla

Developer and Lead Instructor

Is a passionate educator and IT specialist with extensive experience in software development and professional training. His unwavering commitment to educational excellence has empowered students and professionals with practical, applicable skills that enable them to excel in today’s competitive technology industry.

With a vision focused on bridging the gap between academic education and market demands, Sekhar designs transformative learning experiences that prepare aspiring IT professionals to tackle real-world challenges with practical and effective solutions.

What Makes Sekhar Metla Different?
Extensive Experience in Technology and Education:
Sekhar combines his deep knowledge of software development with a pedagogical approach centered on quality and applicability. His technological expertise enables him to deliver training that aligns perfectly with current industry demands.

Practical and Results-Oriented Approach:
His courses are designed to provide real solutions to complex challenges. Sekhar guides his students step by step, simplifying advanced concepts to make them accessible and functional, ensuring effective learning that can be applied in professional settings.

Commitment to Transformative Learning:
Sekhar Metla doesn’t just teach theory; he inspires his students to achieve their full potential. His accessible, dynamic, and results-driven teaching style allows learners to develop practical skills that have a direct impact on their professional growth.

Passion for Teaching and Inspiring:
With a genuine and passionate approach, Sekhar believes education is a powerful tool to transform lives. His dedication and enthusiasm are evident in every course, motivating students to push their limits and achieve their goals.

If you are looking for an instructor who combines technical expertise with practical and inspiring teaching, Sekhar Metla is the ideal choice. Join his courses and take the first step toward a successful career in the technology industry.

Start today and unlock your potential with an expert guide!

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

Ver todos

Explora otros cursos de Sekhar Metla

Descubre otros cursos y aprende algo nuevo hoy mismo. ¡Aprende de los mejores!

Los cursos más vendidos

Cursos de Desarrollo Personal

Ver todos

¿Qué esperar de los cursos de G-Talent?

  • Estudia a tu ritmo

    Consigue cursos en video, impartidos por instructores de primera, para estudiar a tu propio ritmo

  • Aprende de los mejores

    Lleva cursos de alta calidad desarrollados expertos seleccionados con cuidado

  • Calidad garantizada

    ¿No estás seguro?, todos nuestros cursos ofrecen garantía de éxito de 30 días

  • Acompañamiento permanente

    Aprende a tu ritmo, con actualización, acceso y acompañamiento de por vida.

  • Certificado personalizado

    Consigue un certificado de clase mundial, con validez internacional y código único cifrado QR

  • G-Tools: Para estudiantes

    Encuentra todas las herramientas que necesitas para tu empleabilidad en un solo lugar.