Home
About
Academics
Undergraduate Study
Associate Degree
Associate Degree in Professional Design
Associate Degree in Software Development
1 Year Courses
Advanced Programming with Python and JavaScript
6 Months Course
Short Courses
Admission
Faculty
Students
Contact
Apply Now
Login
✕
18 Sections
40 Lessons
10
Expand all sections
Collapse all sections
Advanced Document Formatting and Styles
3
1.0
Customizing styles and themes
1.1
Advanced formatting options (headers, footers, section breaks)
1.2
Creating and managing templates
Document Collaboration and Review
3
2.0
Track changes and comments
2.1
Compare and merge documents
2.2
Protecting and sharing documents
Mail Merge and Macros
2
3.0
Setting up and executing mail merges
3.1
Creating and using macros to automate tasks
Advanced Functions and Formulas
2
4.0
Using functions like VLOOKUP, HLOOKUP, INDEX, MATCH
4.1
Nested functions and array formulas
Pivot Tables and Data Visualization
3
5.0
Creating and customizing pivot tables
5.1
Using pivot charts for data analysis
5.2
Advanced charting techniques (sparklines, combination charts)
Automation with Macros
2
6.0
Recording and editing macros
6.1
Using VBA (Visual Basic for Applications) for advanced automation
Slide Design and Layouts
3
7.0
Designing effective slide layouts
7.1
Using slide masters and custom themes
7.2
Incorporating multimedia elements (images, videos, audio)
Animation and Transition Effects
2
8.0
Applying and customizing slide transitions
8.1
Creating advanced animations for text and objects
Presentation Techniques and Tools
2
9.0
Using Presenter View and other tools for effective delivery
9.1
Preparing slides for different display setups (e.g., multiple monitors)
Email Management and Organization
2
10.0
Using folders, categories, and rules to manage emails
10.1
Setting up and managing email filters and priorities
Calendar and Task Management
2
11.0
Scheduling meetings and appointments with advanced options
11.1
Managing tasks and to-do lists
Collaboration and Integration Tools
2
12.0
Using Outlook’s collaboration features (shared calendars, delegate access)
12.1
Integrating Outlook with other Office applications (Word, Excel, PowerPoint)
Integrating Word, Excel, and PowerPoint
2
13.0
Linking and embedding content between Office applications
13.1
Creating cohesive documents, reports, and presentations using integrated data
Advanced Features and Tips
2
14.0
Exploring lesser-known features and shortcuts
14.1
Tips for improving productivity and efficiency
Review and Practice
2
15.0
Review of key concepts and tools from all applications
15.1
Practice with sample projects and scenarios
Final Project Development
2
16.0
Work on final project with instructor guidance
16.1
Apply skills from Word, Excel, PowerPoint, and Outlook
Final Project Review and Refinement
2
17.0
Final review and refinement of projects
17.1
Address any remaining questions or issues
Final Project Presentation and Course Wrap-Up
2
18.0
Present final projects to the class
18.1
Discuss course takeaways and future applications
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content
