Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

Simon Sez IT via YouTube

Start learning Write review

Embark on a comprehensive 9-hour journey through Microsoft Office, mastering Excel, PowerPoint, and Word. Gain a solid foundation in essential skills for work or school, from basic formulas and data manipulation in Excel to creating engaging presentations in PowerPoint and formatting professional documents in Word. Practice with downloadable exercises to reinforce your learning. Explore features like backstage view, file management, object formatting, SmartArt creation, and document navigation. Perfect for beginners, this tutorial covers everything from basic operations to advanced techniques, ensuring you become proficient in these crucial productivity tools.

Syllabus

- Intro to Excel
- What's New in Excel
- Course Overview
- Overview of the Excel Window
- Mouse Features
- BackStage View in Excel
- Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Practice Exercise
- Working with Save and Save As Commands
- File Extensions, Share, Exports & Publish Files
- Practice Exercise
- Opening a File
- Working with Larger Files
- Freeze Panes
- Split Screen
- Practice Exercise
- Headers & Footers
- Print Titles
- Comments in Excel
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Practice Exercise
- Adding and Deleting Cells
- Chaing Column and Row Widths
- Practice Exercise
- Cut, Copy and Paste
- Copying Formulas
- Practice Exercise
- Overview of Formulas
- Create Formulas Using Functions Part 1
- Create Formulas Using Functions Part 2
- Absolute Values
- Practice Exercise
- Adding, Deleting, and Remaining Sheets
- Additional Sheet Tab Options
- Dimensional Functions
- Practice Exercise
- PowerPoint Welcome and Overview
- Navigating a PowerPoint Presentation
- Overview of the Screen and the Views
- PowerPoint Exercise 01
- Presentation Tips and Guidelines
- Creating New Presentation
- Working with Slides
- Saving Presentation
- PowerPoint Exercise 02
- Formatting Text
- Working with Bullets and Numbered Lists
- PowerPoint Exercise 03
- Inserting Shapes
- Inserting Graphics
- Inserting Icons and 3D Models
- Inserting Pictures
- PowerPoint Exercise 04
- Selecting Objects
- Editing Objects
- Formatting Objects - Part 1
- Formatting Objects - Part 2
- Arranging Objects
- Grouping Objects
- PowerPoint Exercise 05
- Picture Options
- Cropping Pictures
- Formatting Pictures
- Things You Can Do with Pictures
- PowerPoint Exercise 06
- Creating SmartArt
- Modifying SmartArt
- Creating a Flow Chart
- Word Course Overview
- Word Screen
- Backstage View
- Creating a New Document
- Non-printing Characters and Line Spacing
- Saving a Document
- Opening a Document
- Navigating a Document
- GoTo, Find and Replace
- Editing a Document
- Section 2 Practice Exercise
- AutoCorrect Options
- Selecting Text
- Cut, Copy and Paste
- Character Formatting Options
- Format Painter
- Working with Numbers
- Working with Bullets
- Creating an Outline
- Section 3 Practice Exercise
- Alignment Options
- Line Spacing Options
- Working with Indents
- Working with Tabs
- Section 4 Practice Exercise
- Sorting a List

Taught by

Simon Sez IT

Reviews

4.8 rating, based on 62 Class Central reviews

Start your review of Microsoft Office Tutorial - Learn Excel, PowerPoint and Word

M Dwi Arsyad Siddiq @Arsyla

This "Microsoft Office Tutorial - Learn Excel, PowerPoint, and Word" course is **highly recommended** for anyone looking to master the basics of these vital applications. The material is presented **clearly, structured, and easy to understand**, eve…

This "Microsoft Office Tutorial - Learn Excel, PowerPoint, and Word" course is **highly recommended** for anyone looking to master the basics of these vital applications. The material is presented **clearly, structured, and easy to understand**, even for complete beginners.

I personally found the **step-by-step explanations** provided for each feature in Excel, PowerPoint, and Word to be incredibly helpful. The practical examples included made the learning **interactive and relevant** to daily needs, both for academic and professional purposes.

Overall, this course **met and even exceeded my expectations**. I now feel much more confident using all three applications, and I believe my skills have drastically improved. If you're looking for a comprehensive and effective guide to Microsoft Office, this course is the perfect choice!
MOHAMMED SIDDIQUE K
1

This course will be useful for my skills and career in future The MS Office 365 training was very informative and useful for improving my computer skills. I gained practical knowledge in MS Word, Excel, PowerPoint, and Outlook. The hands-on practice sessions helped me understand real-time applications clearly. The trainer explained each topic in a simple and effective manner. I learned how to create documents, prepare spreadsheets, design presentations, and manage emails professionally. This course increased my confidence in using office tools for academic and professional purposes. Overall, the session was well-organized, interactive, and beneficial for enhancing productivity and workplace efficiency.
Ibrar Ali Shah
1

Good for me as I have learnt many things from it which I was not know thus it is very beneficial for me and I am so happy completing on it
Prado_06.07

curso de Excel da Microsoft é uma excelente opção para quem deseja aprender ou aprimorar seus conhecimentos nessa ferramenta tão importante no mercado de trabalho. O conteúdo é bem organizado, começando pelos conceitos básicos e avançando gradualmen…

curso de Excel da Microsoft é uma excelente opção para quem deseja aprender ou aprimorar seus conhecimentos nessa ferramenta tão importante no mercado de trabalho. O conteúdo é bem organizado, começando pelos conceitos básicos e avançando gradualmente para funções mais complexas.
As aulas são claras, objetivas e apresentam exemplos práticos, o que facilita o entendimento. Durante o curso, é possível aprender a usar fórmulas, gráficos, tabelas, filtros, formatação e recursos avançados, tornando o aprendizado completo e útil para o dia a dia.
Outro ponto positivo é a qualidade do material oferecido, que é atualizado e confiável, já que vem diretamente da empresa desenvolvedora do programa. Além disso, o curso ajuda a desenvolver habilidades importantes, como organização de dados, análise de informações e produtividade.
De modo geral, o curso de Excel da Microsoft é muito recomendado para estudantes, profissionais e qualquer pessoa que queira se destacar no mercado. Ele contribui para o crescimento pessoal e profissional, oferecendo uma base sólida para o uso do Excel.
Fos Abdullahi

I really enjoyed taking this course. It helped me understand Microsoft Office in a simple and practical way. Before starting, I was confused about some Excel formulas and how to organize data properly. Now I can use basic functions, create tables, a…

I really enjoyed taking this course. It helped me understand Microsoft Office in a simple and practical way. Before starting, I was confused about some Excel formulas and how to organize data properly. Now I can use basic functions, create tables, and format spreadsheets with more confidence. The PowerPoint lessons were also very helpful because I learned how to design clean and professional slides instead of crowded ones. The Word section improved my formatting skills, especially working with headings and documents for school or office tasks. The instructor explains step by step and does not rush. Even when the lessons are long, they are clear and easy to follow. I would recommend this course to anyone who wants to improve their computer skills for work or study.
Okta Vius

I recently completed a Microsoft certification course, and the experience was exceptional. The curriculum is perfectly structured, balancing theoretical knowledge with highly practical, hands-on labs that simulate real-world scenarios. What I appreciate most is how the modules are broken down into digestible parts, making complex cloud and computing concepts much easier to grasp. The interactive sandbox environments allowed me to practice without any additional costs, which was a huge plus. This course has significantly boosted my technical confidence and provided me with industry-recognized credentials that are invaluable for my professional growth. I highly recommend this to anyone
Jovane Alex

Um bom curso. O curso apresentou uma abordagem clara e objetiva dos conteúdos propostos, sendo adequado para iniciantes que desejam adquirir uma base sólida sobre o tema. Os módulos estão organizados de forma lógica, o que facilita a compreensão pro…

Um bom curso.
O curso apresentou uma abordagem clara e objetiva dos conteúdos propostos, sendo adequado para iniciantes que desejam adquirir uma base sólida sobre o tema. Os módulos estão organizados de forma lógica, o que facilita a compreensão progressiva dos conceitos, desde os mais simples até os mais complexos. A linguagem utilizada é acessível, permitindo que mesmo estudantes sem conhecimentos prévios consigam acompanhar as aulas sem grandes dificuldades.
No entanto, por se tratar de um curso de curta duração, alguns tópicos poderiam ser explorados com maior profundidade, especialmente na parte prática. A inclusão de mais exemplos aplicados à realidade profissional e exercícios práticos ajudaria a consolidar melhor o aprendizado. Ainda assim, o curso cumpre bem o seu objetivo principal, servindo como uma excelente introdução ao tema e como base para estudos mais avançados no futuro
Muhammad Raqib

I found the Excel, PowerPoint, and Word course extremely useful and beginner-friendly. The course starts from the basics and gradually moves to advanced features, making it easy to follow and practice. Each topic is explained clearly with practical examples that help build real-world skills. Excel lessons improved my data handling and formulas, PowerPoint enhanced my presentation design and confidence, and Word helped me create professional documents efficiently. The hands-on exercises and clear instruction made learning smooth and effective. Overall, this course is ideal for students and professionals looking to improve productivity and computer skills.
Hrishank Upadhyay

Completing this Excel course has been a game-changer for my workflow. Before starting, I found spreadsheets quite intimidating, but the instructor broke down complex concepts into manageable, easy-to-digest steps. The lessons on data visualization and conditional formatting were particularly helpful, allowing me to turn raw numbers into clear, professional reports. The pace was perfect, and the practice files provided a great way to learn by doing. I now feel much more efficient and capable of managing data independently. This is a must-take course for anyone who wants to master Excel basics quickly and effectively."
Zakariae Belkbir

My experience with the Office course was very useful and rich in information. I benefited greatly from this course, as I learned the basics of Office programs such as Word, Excel, and PowerPoint in an easy and well-organized way. The explanations were clear and simple, with practical examples that helped me understand quickly and apply what I learned in real situations. This course helped me improve my skills at work and in my studies, and increased my confidence in using computers and office software. I highly recommend this course to anyone who wants to develop themselves and gain important skills needed in professional life.
AbdulRehman

Was good interesting learned something new and love it. Really recommended try it yourself and enjoy
Leydi Oyarce

El curso fue muy claro y práctico. Me permitió aprender y reforzar conocimientos básicos de Excel, Word y PowerPoint, facilitando el uso de estas herramientas en actividades académicas y laborales.
Nalina 2002

Thank you for offering this course for free.i learnt lot of things from this course it is very useful to me for the future l.
Idara Friday Moses

best trainer, the learning process was good , well explain and hands-on traning categories. and it was my first time learning a powerpoint how to create presentation slide
Sofia Pereira

Curso excelente, claro e prático, com ótimos professores e conteúdo atual que faz diferença! sempre!
Roberto Navarro Quiroz

This comprehensive tutorial by Simon Sez IT is an excellent starting point for anyone looking to master the core Microsoft Office suite. The course is well-structured and genuinely includes all the fundamentals needed to begin using Excel, PowerPoint, and Word effectively.

I found the instruction clear and easy to follow, making complex topics approachable for a beginner. It provides a solid foundational base that boosts confidence. If you need to quickly gain practical skills in essential office applications for academic or professional use, this course is a fantastic, all-in-one resource. Highly recommended for efficiency!
Dc.abubakar

Nice course I completely agree with method of delever with deep understanding and very good .I like this course,my all concept is clear
Rahat Fatima

Solid nine‑hour Excel course that balances fundamentals and real‑world practice. The instructor explains formulas, formatting, tables, charts, and pivot tables clearly, with steady pacing and plenty of shortcuts. I liked the sections on data cleaning, conditional formatting, and XLOOKUP; the demos feel practical, not theoretical. Practice files and mini projects reinforce learning without being overwhelming. Chapter breaks and recap quizzes make it easy to pause and revisit tough bits. Could use a brief intro to macros and Power Query, but what’s here is comprehensive for everyday work. If you want confident, job‑ready Excel skills in a day, this delivers. Recommended.
Mohammed A.S

The "Microsoft Office Tutorial - Learn Excel, PowerPoint and Word" is a well-structured and beginner-friendly guide that covers the essential features of the three core Office applications. The tutorial offers clear explanations and practical examples, making it easy to follow even for those with minimal experience. It effectively introduces key tools like formulas in Excel, slide design in PowerPoint, and formatting techniques in Word. However, adding interactive practice exercises or real-time projects would enhance engagement and learning. Overall, it's a valuable resource for students and professionals looking to improve their Microsoft Office skills efficiently and confidently.
Iqbalur Rosyad

Sangat membantu bagi yang masih belajar, hebat Microsoft bisa memberikan fasilitas untuk belajar bagi yang masih pemula mulai dari word PowerPoint excel Outlook dll