Bundle Course

# MS Word+PowerPoint+ExcelEfficiency

Improve your complete MS office to save time and increase productivity.

## What you Learn?

By the end of the course, you’ll have the hands-on skills to navigate, edit data, use basic formulas, format and create charts, which you could print and collaborate with others on.

## This course covers

MICROSOFT WORD ESSENTIALS

Create a new document.
Basic Entering And Editing Text
Navigating Microsoft Document
Text Selection
Creating Bulleted And Number List
Text Formatting

WORKING WITH PAGE LAYOUT

Working With Microsoft Margins
Page Breaks
Page Background Work

MICROSOFT WORD DOCUMENT AND PRINTING

Ms Word Spell Checker
Navigation Pane To Find And Replace The Document
Printing Document
Convert Into PDF

TABULATION IN MICROSOFT WORD

Setting Tabs In A Document
Formatting Word Tab
Modifying Spacing And Removing Word Tabs
Other Tabs

TABLES

Creating Tables
Calculations Tables
Formatting Tables

STYLES FEATURES

PICTURES AND VIDEO DOCUMENTS

Working With Picture Documents
Modifying And Editing Picture
Formatting Wrap Text

EXCEL ESSENTIAL

Introduction to Excel Interface
Understanding the structure of excel workbook
Formatting Options
Saving Excel Document
Common Excel Shortcut
Copy, Paste

FORMATTING DATA IN EXCEL

Changing the colour
Formatting Data
Excel's Format
Conditional Formatting
Add Delete Cells Rows And Columns
Sort And Filters

ENTERING AND EDITING FORMULAS

Absolute Vs Relative Reference
Sum Formula
Logical Formula -IF
Logical Formula -AND and OR
Count Function
Average if
Sum If
Statistical FormulaLarge, small, and Rank
Error Type

TEXT , TIME AND DATE FORMAT

Difference between text time and date
Changing the case of text
Combining text
Cutting substring from text
Combining date and time data
Conducting day of the week

CREATING BASIC CHART IN EXCEL

Creating Excel column chart
Modifying data in Excel Chart
Formatting excel chart
Working with pie chart
Insert sparkline

MODIFYING AND PRINTING EXCEL WORKSHEET

Moving and copying data in excel worksheet
Deleting and renaming Excel worksheet
Document output management

TEXT , TIME AND DATE FORMAT

Difference between text time and date
Changing the case of text
Combining text
Cutting substring from text
Combining date and time data
Conducting day of the week

Commonly Used Hot Keys

Speed Up With Hot Keys
Working With Text
Bullets Busting and Smart Art

Alt F And Quick Acess Toolbar
Alt Home: Layout, Sections And Shape effects
Alt Insert : SmartArt, Video And Comments
Alt View : Slide sorters, Gridlines And More
Design, Transitions And Animations

Objects and Alignment
Working With Tables
Mastering charts
Images In Presentations
Slide Master

01

### Organize and Analyze data

you can ensure that your data is properly collected, cleaned, and analyzed to generate insights

02

### Perform Complex Calculation

The ability to perform complex calculations is essential in many fields, including science, engineering, finance, and data analysis.

03

### Create charts and graphs

Creating charts and graphs is an effective way to visually represent data and communicate insights to others.

04

### Automate Calculations

Automating calculations can save time and increase accuracy by reducing the risk of human error.

Why Choose Us?

# Certificate of Training

Rewarded upon successful completion of your  course.

Who is this course for?

Anyone can learn Excel! course takes someone from beginner to advanced using guided simulation learning.

What is guided simulation learning?

Unlike video which is a passive way to learn we use a hands-on approach to building muscle memory. This hands-on approach results in a significant increase in memory retention.

I am new to Excel. Would this course be suitable for someone at my level?

This Excel course covers a range of topics, starting from the basics and progressing towards essential concepts and skills. Once you have learned Excel efficiency, you can expect to experience increased productivity, accuracy, data analysis, reporting, efficiency, organization, and career opportunities.

Once you have a solid understanding of the basics, you will be better equipped to handle more advanced Excel courses and concepts with greater ease.

What is the duration of the Excel course?

Our LMS course consists of 80 hours of comprehensive training that is designed to enhance your Microsoft Excel skills, enabling you to work with greater efficiency and speed.

Do we need to have Microsoft Excel installed on our computer to take the Excel course?

A simulated learning environment is a type of educational setting that replicates a real-life scenario or situation in a controlled and safe environment. Our Excel course is designed to be accessible through a web browser, so you don't need to have Microsoft Excel installed on your system to take the course.

Are there any other resources or materials available to help learners improve their Excel skill?