UNIT 1

Microsoft Word makes it easy to create professional documents, whether

starting from a blank page or using a pre-designed template. With intuitive
tools for setting up layouts, fonts, and formatting, you can tailor your
document for various purposes, such as reports, letters, or resumes.

Steps to Create a New Document

Step 1: Open Microsoft Word

To begin, launch Microsoft Word on your computer:

 Windows: Click the Start menu, search for "Word," and select the
Microsoft Word app.

 Mac: Open Word from the Applications folder or Launchpad.

Step 2: Start a Blank Document

When you open Word, you’re typically greeted with the Start screen, which
offers options to create a new document:

 Select Blank Document: Click the "Blank document" option to open

a new, empty document with default settings (e.g., A4 or Letter paper
size, Calibri 11pt font).

 Keyboard Shortcut: Press Ctrl+N (Windows)

or Command+N (Mac) to create a blank document instantly.
 Result: A new document opens, ready for you to start typing
or formatting.
Step 3: Use a Template (Optional)

Instead of a blank document, you can create a document based on a

template for a pre-designed layout:

 On the Start screen, browse templates like "Resume," "Letter,"

"Newsletter," or "Flyer."

 Click a template to preview it, then select Create to open it.

 Search Templates: Use the search bar (e.g., type "invoice") to find
specific templates online.

 Use Case: Templates are ideal for creating professional-looking

documents quickly, such as a resume or business letter.

Step 4: Set Up Your Document

After creating a new document, configure basic settings to suit your needs:

 Page Layout: Go to the Layout or Page Layout tab and adjust:

o Margins: Select Margins > Normal (1 inch) or customize as

needed.

o Orientation:
Choose Portrait or Landscape under Orientation.

o Paper Size: Select Size to choose A4, Letter, or other sizes.

 Font and Paragraph: Go to the Home tab to set the default font
(e.g., Calibri, Times New Roman) and paragraph settings (e.g., line
spacing).

 Tip: Save these settings as a custom template for future use (File >
Save As > Word Template).

Step 5: Begin Working on Your Document

With your document created, you can:

 Start typing text for your content (e.g., a report, essay, or letter).

 Add elements like images, tables, or headers via the Insert tab.
Unit 2

Excel, one of the powerful spreadsheet programs for managing large

datasets, performing calculations, and creating visualizations for data
analysis. Developed and introduced by Microsoft in 1985, Excel is mostly
used in analysis, data entry, accounting, and many more data-driven tasks.

Why Choose Excel

 It is one of the most popular and secure spreadsheet programs

available.

 Easy to learn and easily available for multiple devices.

 Support various tasks like budgeting, inventory tracking, and data

analysis.

 Excel offers over 400 functions, like VLOOKUP, SUM, LET, LAMBDA,
and more.

 Easily connected with Power BI, MS Teams, and OneDrive.

 VBA support for scripting and automations.

  Excel Formatting - Basics
Proper formatting is key to making your data clear, visually
appealing, and easier to understand. From adjusting cell sizes
to applying custom date formats, the below articles are
designed to help you present your data in the most effective
way possible.
Excel Formulas and Functions - A to Z

Excel's formulas and functions are the backbone of its powerful data analysis
abilities. Whether you need to perform basic calculations, manipulate text, or
analyze complex datasets, our detailed guides below will help you master
every function Excel has to offer.

Learn Data Analysis and Visualization in Excel

Data analysis and visualization are crucial for converting raw data into
actionable insights. In this section, you'll find complete tutorial on sorting,
filtering, and visualizing your data using Excel's powerful tools. From creating
pivot tables to designing dynamic dashboards

Charts and Data Visualization

Excel offers an in-built professional charting and visualization tool that can
turn your data into meaningful insights and visually appealing reports. From
basic charts to complex visualizations, this section covers all the techniques
you need to master data presentation in Excel.
UNIT 3

Microsoft Access is a Database Management System (DBMS) from Microsoft

that combines the relational Microsoft Jet Database Engine with a graphical
user interface and software development tools. It is a member of the
Microsoft Office suite of applications, included in the professional and higher
editions.

Ms Access - Objects

MS Access uses objects" to help the user list and organize information, as
well as prepare specially designed reports. When you create a database,
Access offers you Tables, Queries, Forms, Reports, Macros, and Modules.
Databases in Access are composed of many objects but the following are the
major objects −

 Tables
  Queries

 Forms

 Reports

Together, these objects allow you to enter, store, analyze, and compile your
data. Here is a summary of the major objects in an Access database;

Table

Table is an object that is used to define and store data. When you create a
new table, Access asks you to define fields which is also known as column
headings.

 Each field must have a unique name, and data type.

 Tables contain fields or columns that store different kinds of data, such
as a name or an address, and records or rows that collect all the
information about a particular instance of the subject, such as all the
information about a customer or employee etc.

 You can define a primary key, one or more fields that have a unique
value for each record, and one or more indexes on each table to help
retrieve your data more quickly.

Query

An object that provides a custom view of data from one or more tables.
Queries are a way of searching for and compiling data from one or more
tables.

 Running a query is like asking a detailed question of your database.

 When you build a query in Access, you are defining specific search
conditions to find exactly the data you want.

 In Access, you can use the graphical query by example facility or you
can write Structured Query Language (SQL) statements to create your
queries.

 You can define queries to Select, Update, Insert, or Delete data.

 You can also define queries that create new tables from data in one or
more existing tables.

Form
Form is an object in a desktop database designed primarily for data input or
display or for control of application execution. You use forms to customize the
presentation of data that your application extracts from queries or tables.

 Forms are used for entering, modifying, and viewing records.

 The reason forms are used so often is that they are an easy way to
guide people toward entering data correctly.

 When you enter information into a form in Access, the data goes
exactly where the database designer wants it to go in one or more
related tables.

Report

Report is an object in desktop databases designed for formatting, calculating,

printing, and summarizing selected data.

 You can view a report on your screen before you print it.

 If forms are for input purposes, then reports are for output.

 Anything you plan to print deserves a report, whether it is a list of

names and addresses, a financial summary for a period, or a set of
mailing labels.

 Reports are useful because they allow you to present components of

your database in an easy-to-read format.

 You can even customize a report's appearance to make it visually

appealing.

 Access offers you the ability to create a report from any table or query.

UNIT 4

What is PPT? Understanding PowerPoint Basics

The world of presentations is dominated by PowerPoint, a tool that has

revolutionized how we communicate ideas. To harness its full potential, it’s
essential to understand the basics of PowerPoint, including its definition,
evolution, and the various platforms it supports.

The Definition and Origin of PowerPoint

PowerPoint, commonly referred to as PPT, is a presentation software
developed by Microsoft. First released in 1987, it has since become a
cornerstone in both professional and educational environments. The software
allows users to create engaging presentations by combining text, images,
and multimedia elements. Over the years, PowerPoint has evolved
significantly, incorporating advanced features that enable users to convey
complex information in a clear and concise manner.

PowerPoint in the Microsoft Office Suite

PowerPoint is an integral part of the Microsoft Office suite, a collection of

productivity software that includes Word, Excel, and Outlook. The integration
between these applications enhances the functionality of PowerPoint,
allowing users to seamlessly incorporate data and content from other Office
tools. For instance, users can embed Excel charts or Word documents directly
into their PowerPoint presentations, enriching their content and improving
overall presentation quality.

Essential Features and Functions of PowerPoint

One of the key strengths of PowerPoint is its rich set of features that enable
users to craft compelling presentations. PowerPoint offers a range of tools
and functionalities that make it an ideal choice for creating engaging and
interactive content.

Creating and Managing Slides

PowerPoint allows users to create and manage slides efficiently. This

includes using slide layouts and master slides to maintain consistency
throughout the presentation.

Slide Layouts and Master Slides

Slide layouts help in organizing content, while master slides enable users to
apply a uniform design across multiple slides. This feature is particularly
useful for maintaining a professional look.

Organizing and Rearranging Content

Users can easily rearrange slides and organize content to improve the flow of
their presentation. This flexibility is crucial for creating a logical and
engaging narrative.

Design Elements and Templates

PowerPoint provides a variety of design elements and templates to
enhance the visual appeal of presentations. These templates are designed to
cater to different needs, from business to education.

Using Pre-built Templates

Pre-built templates offer a convenient starting point, allowing users to

quickly create professional-looking presentations. These templates are
customizable to fit specific requirements.

Customizing Designs and Themes

Users can customize designs and themes to align with their brand or
personal preferences. This includes changing colors, fonts, and other design
elements to create a unique look.

Adding Multimedia and Interactive Elements

To make presentations more engaging, PowerPoint allows users to add

various multimedia and interactive elements. This includes images,
charts, SmartArt, audio, and video.

Images, Charts, and SmartArt

Users can incorporate images, charts, and SmartArt to visualize data and
illustrate complex concepts. These elements help in making the content
more accessible and interesting.

Audio and Video Integration

PowerPoint supports the integration of audio and video files, enabling users
to add narration, background music, or video content to their presentations.

Animation and Transition Effects

Animation and transition effects can be used to enhance the visual appeal
and keep the audience engaged. However, it’s essential to use these effects
judiciously to avoid distractions.
UNIT 5

ADVANCED COMMUNICATIONS

A mobile device is a general term for any type of handheld computer.

These devices are designed to be extremely portable, and they can often fit
in your hand. Some mobile devices—like tablets, e-readers,
and smartphones—are powerful enough to do many of the same things you
can do with a desktop or laptop computer.

Tablet computers

Like laptops, tablet computers are designed to be portable. However, they

provide a different computing experience. The most obvious difference is
that tablet computers don't have keyboards or touchpads. Instead, the entire
screen is touch-sensitive, allowing you to type on a virtual keyboard and
use your finger as a mouse pointer.
Tablet computers can't necessarily do everything traditional computers can
do. For many people, a traditional computer like a desktop or laptop is still
needed in order to use some programs. However, the convenience of a tablet
computer means it may be ideal as a second computer.

E-readers

E-book readers—also called e-readers—are similar to tablet computers,

except they are mainly designed for reading e-books (digital, downloadable
books). Notable examples include the Amazon Kindle, Barnes & Noble
Nook, and Kobo. Most e-readers use an e-ink display, which is easier to
read than a traditional computer display. You can even read in bright
sunlight, just like if you were reading a regular book.
You don't need an e-reader to read e-books. They can also be read
on tablets, smartphones, laptops, and desktops.

Smartphones

A smartphone is a more powerful version of a traditional cell phone. In

addition to the same basic features—phone calls, voicemail, text messaging
—smartphones can connect to the Internet over Wi-Fi or a cellular network
(which requires purchasing a monthly data plan). This means you can use a
smartphone for the same things you would normally do on a computer, such
as checking your email, browsing the Web, or shopping online.
Most smartphones use a touch-sensitive screen, meaning there isn't a
physical keyboard on the device. Instead, you'll type on a virtual keyboard
and use your fingers to interact with the display. Other standard features
include a high-quality digital camera and the ability to play digital music and
video files. For many people, a smartphone can actually replace electronics
like an old laptop, digital music player, and digital camera in the same
device.

Mobile technology has transformed communication and connectivity

worldwide. It encompasses portable devices like smartphones, tablets,
and smartwatches that enable users to access information and services on
the go. Mobile technology allows people to make calls, send
messages, browse the internet, and use various apps from almost
anywhere.

These devices connect through wireless networks, including cellular networks

and Wi-Fi. The technology has evolved rapidly, from basic cell phones to
today’s powerful smartphones. Modern mobile devices function as mini-
computers, capable of tasks once limited to desktop machines.
Mobile technology impacts various aspects of life. It changes how people
work, learn, shop, and interact. Businesses use mobile tech for improved
productivity and customer engagement. In education, it enables remote
learning and access to educational resources. The convenience and
functionality of mobile devices continue to shape society and drive
innovation.

1. Mobile Devices

At the heart of mobile technology are the devices themselves. These

portable, wireless-enabled gadgets include:

 Smartphones: These versatile devices combine communication

features with powerful computing capabilities, internet access, and a
wide array of applications.

 Tablets: Larger than smartphones, tablets offer a more immersive

experience for tasks like browsing, watching videos, and reading.

 Wearable Devices: Smartwatches, fitness trackers, and augmented

reality (AR) glasses extend mobile technology to our bodies, providing
new ways to track health, access information, and interact with our
surroundings.

2. Mobile Applications

Mobile applications (apps) are software programs designed to run on mobile

devices, offering a vast range of functionalities:

 Communication: Apps for messaging, social networking, and video

calls keep us connected.

 Productivity: Apps for email, document editing, and task

management help us stay organized and efficient.

 Entertainment: Games, streaming services, and music apps provide

endless entertainment options.

 Utilities: Apps for navigation, weather, and health tracking offer

practical tools for everyday life.

3. Use of Mobile technology

 The incorporation of mobile technology into business has aided

telecollaboration. Now, people could connect from anywhere using
 mobile technology, and access the papers and documents they need to
complete collaborative work.

 Work is being redefined by mobile technologies. Employees are no

longer confined to their desks; they can work from anywhere in the
world.

 Mobile technology can help your company save time and money.
Employees who work from home save thousands on a regular basis.
Mobile phones eliminate the need for costly technology like landline
carrier services. Cloud-based services are less expensive than
traditional systems. Technology can also help your company become
more flexible and productive.

 Mobile technology has the potential to boost productivity significantly.

Mobile application integration saves an average of 7.5 hours per week
per employee. Workers can also become more productive with the use
of smartphones and mobile gadgets.

 The popularity of cloud-based services has skyrocketed in recent years.

Cloud-based mobile technology applications have been seen to be
more useful than any smartphone, particularly in terms of available
storage space.