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 66 Class Central reviews

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

Allan Survivor Laluyan @Sorbaybor

This course provided a clear and practical introduction to Microsoft Office tools, especially Excel, PowerPoint, and Word. The lessons were easy to follow, well-structured, and helpful for improving productivity and creating professional documents, presentations, and spreadsheets.
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.
TIBEBU YENEW WOLELA

I found this tutorial to be an excellent deep dive into the core Microsoft Office applications. The Excel portion is especially strong, providing practical knowledge that can be immediately applied to data management and professional reporting. Simon Sez IT does a great job of breaking down complex tasks into manageable segments. For a free course on YouTube, the production quality and educational value are outstanding, and it has definitely helped me feel more confident in handling digital documentation and presentations.
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
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.
DANNIELE SANTOS DE SOUZA

foi uma esperiencia incrivel , pois me mostrou atalhos e coisas que não sabia excel fazia para ajuadar no dia e o powerpont veio para somar no dia a dia com formas e opçôes para melhorar nas apresentaçoês e et...
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.
Andrew Murambi

Enjoyed it. This is the most comprehensive Microsoft 365 course I've ever encountered, every detail and functionality about the platform is in here
Phoenix Suns

This is great tutorials, good to learn easy to know.
Its very helpful to learn excel even words and power points.
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
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
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.
Sofia Pereira

Curso excelente, claro e prático, com ótimos professores e conteúdo atual que faz diferença! sempre!
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.