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.7 rating, based on 77 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.
Analy Melendez

This course provides a solid introduction to the core Microsoft Office tools: Excel, PowerPoint, and Word, making it an excellent option for beginners or anyone looking to refresh their skills. The content is structured in a clear and easy-to-follow…

This course provides a solid introduction to the core Microsoft Office tools: Excel, PowerPoint, and Word, making it an excellent option for beginners or anyone looking to refresh their skills. The content is structured in a clear and easy-to-follow manner, guiding learners step by step through essential functions and features.
One of the biggest strengths of the course is its practical approach. Each section focuses on real-life applications, allowing users to quickly understand how to create documents, presentations, and spreadsheets effectively. The explanations are straightforward, which makes complex topics more accessible even for those with little to no prior experience.
Excel lessons are particularly useful, covering basic formulas, data organization, and simple analysis techniques. PowerPoint modules help build visually appealing presentations, while the Word section ensures a strong foundation in document formatting and editing.
However, the course may feel somewhat basic for intermediate or advanced users who are looking for deeper insights or advanced functionalities. Expanding on more complex features could enhance its overall value.
Overall, this tutorial is a great starting point for anyone wanting to gain confidence in Microsoft Office tools. It is practical, beginner-friendly, and delivers the fundamentals needed to work efficiently in a professional or academic environment.
Steven Mikhael Sadek

This course is one of the best Microsoft Office tutorials I have taken. The lessons are clear, well-organized, and easy to follow, even for beginners. The instructor explains every step patiently and uses practical examples that make learning Excel, Word, and PowerPoint much easier. I improved my understanding of formulas, document formatting, and professional presentations through this course. The videos are engaging, and the pace is perfect for learning without feeling overwhelmed. I highly recommend this course to students, professionals, and anyone who wants to improve their Microsoft Office skills. It is an excellent free resource, and I am very satisfied with the knowledge and confidence I gained after completing it.
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
Preetham Chandrashekhar N

Microsoft Office tutorial courses are highly useful for beginners and professionals who want to improve their productivity skills. These tutorials provide step-by-step guidance on using Microsoft Excel, Microsoft PowerPoint, and Microsoft Word effec…

Microsoft Office tutorial courses are highly useful for beginners and professionals who want to improve their productivity skills. These tutorials provide step-by-step guidance on using Microsoft Excel, Microsoft PowerPoint, and Microsoft Word effectively. Excel tutorials help users understand formulas, charts, data analysis, and spreadsheet management. PowerPoint lessons focus on creating attractive presentations with animations, transitions, and professional slide designs. Word tutorials teach document formatting, tables, templates, mail merge, and report preparation.

The tutorials are easy to follow and suitable for students, office employees, teachers, and business professionals. Practical examples and exercises make learning more interactive and help users apply concepts in real-world tasks. Another advantage is that Microsoft Office skills are widely required in workplaces, making these tutorials valuable for career development. Overall, Microsoft Office tutorials are an excellent learning resource for improving computer knowledge, office efficiency, and professional communication skills.
Defan Ardana

I found this course very helpful for learning the basics of Microsoft Office, especially Excel, PowerPoint, and Word. The instructor explains concepts clearly and step by step, making it easy to follow even for beginners. The lessons include practical examples that can be applied directly to everyday tasks. This tutorial has boosted my confidence in using key Office features for work and study. It is a great resource for anyone who wants to quickly improve their productivity skills.
Orville Pascual

The course provides clear explanations and practical examples that help learners become familiar with creating documents, spreadsheets, and presentations. While the content is mostly basic and may not be suitable for advanced users, it serves as a solid foundation for developing essential Microsoft Office skills.

Overall, this course is recommended for beginners who want a simple and accessible introduction to Microsoft Office.
Harmanjot Singh

This is a very comprehensive tutorial provides an exceptional, fast-paced deep dive into Microsoft Word, PowerPoint, and Excel, making it an invaluable toolkit for boosting workplace productivity. It masterfully simplifies intimidating features, fas…

This is a very comprehensive tutorial provides an exceptional, fast-paced deep dive into Microsoft Word, PowerPoint, and Excel, making it an invaluable toolkit for boosting workplace productivity. It masterfully simplifies intimidating features, fast-tracking your document formatting in Word and teaching you how to build engaging, cinematic presentations in PowerPoint using modern tools like Morph. Meanwhile, the Excel segment expertly demystifies complex data analysis, formulas, and Pivot Tables into practical, easy-to-follow steps. Packed with clear, real-world examples and highly structured, bite-sized lessons, this course completely skips the fluff to deliver an efficient and thoroughly rewarding learning experience for both beginners and professionals.
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.
Yash Uu

very good course i felt very good after learning from here and the course it worth time and it feels that i have learnt way to more things
Naqib Ullah

Great good teacher experience and enhanced my knowledge and skills and Great fun and time and really experience teacher great knowledge
Hania Altaf

Great course, easily understandable and very informative. I have learned many things that i didnt knew before.
Merlin White D

Good to have these kinds of course can learn more on this. Explanation is clear and can have good practice sessions to get clarifications on doubts.
Surafel Endeg

It's effective for learning key skills like formulas, pivot tables, and data analysis at your own pace. However, it loses one point due to limited live instructor support and the risk of low engagement without hands-on practice. Great for self-motivated learners.
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...