Nayeem-Headshot

Mentor

Muhammad Ali Nayeem

Category

৳6000

Enroll Now

Course at a glance

Course Title: Microsoft Office Applications Specialist
Course Mentor: Muhammad Ali Nayeem
Number of Classes: 12
Class Duration: 1 hour 30 minutes
Tentative Date: May 1, 2024
Venue: Webexl Tech, 28 No. Dhalpur, 4th Floor, (Madrasah Building), Dhaka - 1204

What you'll learn

• Learn Microsoft Word from Beginner to Expert Level
• Learn to Create a Professional Document Template
• Learn to do Professional & Advanced Document Formatting & Layout in Microsoft Word
• Learn Microsoft PowerPoint from Beginner to Expert Level
• Learn to Create a Eye Catchy Presentation
• Learn to Customize the PowerPoint slides
• Learn Microsoft Excel from Beginner to Expert Level
• Learn the Mathematical Functions
• Learn the Logical Functions
• Learn the Excel Sheet Auditing Tools
• Learn Data Consolidation in Excel
• Learn Printing the Excel File
• Learn the Shortcut Keys for Microsoft Word, PowerPoint & Excel

Requirements

  • No prerequisites.
  • No prior skills or expertise required, this course teaches you how to get started with profitable freelance skills.
  • No prior freelance or job experience required, this course teaches you how to achieve freelance success from scratch.

Description

Course Overview:

    Embark on a comprehensive journey into the world of Microsoft Office with Webexl Tech's Microsoft Office Applications Specialist course. Designed for individuals seeking to master Microsoft Office tools, this course offers an in-depth exploration of Microsoft Word, Excel, and PowerPoint. Whether you're aiming to enhance your productivity in the workplace, aspiring to secure a certification, or simply looking to refine your skills in these essential applications, this course provides the knowledge and hands-on experience you need.
Who Should Enroll:
  • Professionals looking to improve their productivity and efficiency in the workplace.
  • Students and educators seeking to enhance their presentation and data management skills.
  • Individuals aiming to achieve Microsoft Office certification.
  • Anyone interested in mastering Microsoft Office applications for personal or professional use.
Course Features:
  • Detailed modules covering the key features and tools of Microsoft Word, Excel, and PowerPoint.
  • Practical, hands-on exercises designed to reinforce learning and enable real-world application.
  • Expert instructors with extensive experience in Microsoft Office applications.
  • Interactive sessions that encourage participation and discussion.
Course Outline: Microsoft Word
  • Dive into the essentials of Microsoft Word, from basic introduction to advanced features like editing options, paragraph formatting, and inserting various elements such as tables, pictures, and charts. Learn how to enhance your documents with SmartArt, hyperlinks, headers, footers, and much more.
Microsoft Excel
  • Explore the Microsoft Excel interface and master functions ranging from basic math to complex formulas. Understand how to effectively use tools like AutoSum, Array formulas, Conditional Formatting, and Logical Functions. Gain proficiency in data management techniques including sorting, filtering, and removing duplicates.
Microsoft PowerPoint
  • Get acquainted with Microsoft PowerPoint, focusing on creating impactful presentations. Learn to format text and paragraphs, utilize drawing tools, and incorporate tables, pictures, and charts. Discover how to insert videos, photo albums, 3D models, and Smart Arts to make your presentations stand out.
Certification: Upon successful completion of the course, participants will receive a Certificate of Completion from Webexl Tech, validating their proficiency in Microsoft Office applications.

Course content

Microsoft Word

    • Introduction to Microsoft Word
    • Paragraph Formatting in Microsoft Word
    • Heading Styles in Microsoft Word
    • Editing Options in Home Tab
    • Clipboard & Format Painter Options in Microsoft Word
    • Page Insert Options in Microsoft Word
    • Inserting Tables in Microsoft Word
    • Insert Pictures in Microsoft Word
    • Shapes, Icons & 3d Models in Microsoft Word
    • SmartArt Options in Microsoft Word
    • Inserting Charts in Microsoft Word
    • Text Box & Drop Cap Options in Microsoft Word
    • Hyperlink in Microsoft Word
    • Header, Footer & Page Number Options in Microsoft Word
    • Equations & Symbols in Microsoft Word
    • Water Mark, Page Color & Page Border Options in Microsoft Word

Microsoft Excel
    • Introduction to Microsoft Excel Interface
    • Basic Math Functions
    • AutoSum Functions
    • Sum IF Function & Remove Duplicates Option
    • Sum IF & Sum IFs, Count IF & Count IFs Functions
    • Sub Total Function
    • Arrays & Sum Product Functions
    • Other Math Functions
    • Cell or Range Name
    • Absolute & Relative References
    • Formatting Techniques in Excel
    • Excel Data Types
    • Roaming in Excel
    • Go to & Replace Options
    • Auto Fill Options
    • Flash Fill Option
    • Copy, Paste & Paste Special Options
    • Conditional Formatting
    • Sort & Filter
    • Excel Operators
    • Equations Solving in Excel
    • Errors in Excel Sheet
    • Logical Function (IF, Nested IF, OR)

Microsoft PowerPoint
    • Introduction to Microsoft PowerPoint Interface
    • Font & Slide Options in Microsoft PowerPoint
    • Paragraph Formatting in Microsoft PowerPoint
    • Drawing Tools in Microsoft PowerPoint
    • Editing Options in Home Tab
    • Inserting Tables in Microsoft PowerPoint - 01
    • Inserting Tables in Microsoft PowerPoint - 02
    • Inserting Pictures in Microsoft PowerPoint
    • Screenshot Option in Microsoft PowerPoint
    • Inserting Photo Albums in Microsoft PowerPoint
    • Inserting Icons in Microsoft PowerPoint
    • Inserting 3D Models in Microsoft PowerPoint
    • Inserting Smart Arts in Microsoft PowerPoint
    • Inserting Charts in Microsoft PowerPoint
    • Some Other Inserting Options in Microsoft PowerPoint
    • Inserting Videos in Microsoft PowerPoint