1. Creating, Formatting, and Saving Documents
Creating a Document Launch the application from your desktop or start menu. Choose Blank Document to create a new one, or select a template for predefined styles. Saving a Document First Save: File Save As Select a location (local drive, OneDrive, or an external device). Enter a file name and select a file type (for example,.docx,.pdf). Click Save.
Autosave Feature (Cloud): If using OneDrive, enable Autosave for real-time saving.
Opening and Editing Existing Documents
Open: Navigate to File > Open and browse your files.
Edit content directly or update formatting using the tools in the ribbon.
2. Basic Text Editing Tools
Font Styles, Sizes, and Colors
Font Style:
Select text and go to the Home tab.
Choose from fonts like Calibri, Arial, Times New Roman, etc.
Font Size:
Highlight the text and use the dropdown in the Font Size section.
Shortcut: Increase using Ctrl+Shift+> and decrease using Ctrl+Shift+<
Font Color:
Select a color using the Font Color icon (in the Home tab, underlined “A”).
Text Enhancements
Bold: Use the B button or press Ctrl+B
Italic: Use the I button or press Ctrl+I
Underline: Use the U button or press Ctrl+U
Text Alignment
Adjust left, center, right, and justify text using the Paragraph section in the Home tab.
3. Inserting Images, Tables, and Headers/Footers
Inserting Images
From Device: Open Insert > Pictures > This Device, select the picture, and click Insert.
Online Images: Use Insert > Pictures > Online Pictures to search and insert pictures directly from Bing or other sources.
Editing Images:
Resize by dragging corners.
Use the Picture Format tab for effects like borders, shadows, and alignment.
Inserting Tables
Quick Table:
To enter a table: Insert > Table, hover on the grid to select rows and columns.
Custom Table: In insert table, it is possible to define dimensions by hand.
Styling Tables
Use the table design tab to apply styles
Merge or split cells using the layout tab.
Align text inside table cells to achieve a proper layout.
Headers and Footers
Insert header or footer using Insert > Header or Footer.
Select a style or blank area to type in your own contents.
Content: Add headers, dates, page numbers, or logos.
Clearing: Navigate to Header & Footer Tools > Click Close Header and Footer to leave edit mode.
4. Page Layout and Print Settings
Page Layout
Margins: Use Layout > Margins to adjust to Normal, Narrow, or Custom.
Orientation: Select Portrait or Landscape using Layout > Orientation
Paper Size: Select A4, Letter, or customize using Layout > Size.
Columns: Use Layout > Columns to split text into one, two, or three columns.
Spacing: Adjust paragraph spacing via Layout > Spacing.
Printing Options
Preview: Go to File > Print to see a live preview of your document.
Select Printer: Choose your desired printer under the Printer dropdown.
Settings:
Choose Print All Pages, specific pages (e.g., “1-3, 5”), or current page.
Adjust settings like double-sided printing or collated output.
Print: Click the Print button to start.
Module 1: An Introduction to Spreadsheets and Basic Formulas
1. What is a Spreadsheet?
Grid of rows and columns used to organize, calculate, and analyze data.
Rows: Numbered (1, 2, 3…)
Columns: Alphabetized (A, B, C…)
Cells: Intersection of a row and column (e.g., A1, B2)
2. Basic Excel Navigation
Launch Excel: Begin a new workbook or open a file.
Save Files: File > Save As, select location and file type (e.g.,.xlsx).
Enter Data: Click a cell and type; hit Enter to save input.
3. Basic Formulas
SUM: Adds numbers in a range.
Example: =SUM(A1:A5) adds values from cells A1 to A5.
AVERAGE: Finds the average of numbers.
Example: =AVERAGE(B1:B5).
MIN/MAX: Returns the smallest/largest value in a range.
Example: =MIN(C1:C10) or =MAX(C1:C10).
COUNT: Counts the number of numeric entries.
Example: =COUNT(D1:D10).
Basic Arithmetic: Add (+), subtract (-), multiply (*), or divide (/).
= A1+B1
Module 2: Formatting Cells, Rows, and Columns
1. Cell Formatting
Font Style, Size, and Color: Use the Home tab to format text (e.g., bold, italic, color).
Borders: Add borders via Home > Borders dropdown.
Cell Background: Apply color using Fill Color in the toolbar.
2. Row and Column Adjustments
Resizing: Drag the boundary of the row/column headers or use Format > AutoFit Row Height/Column Width.
Inserting/Deleting Rows or Columns: Right-click a row/column header and choose Insert or Delete.
Hiding/Unhiding: Right-click and select Hide or Unhide for selected rows/columns.
3. Number Formatting
Format numbers as currency, percentage, date, or custom using Home > Number dropdown.
Module 3: Creating and Editing Charts
1. Creating Charts
Select the data range (e.g., A1:B10).
Go to Insert > Charts and choose the chart type, such as Column, Line, or Pie.
2. Chart Customization
Add Titles: Click on the chart and go to Chart Elements > Chart Title.
Change Colors: Use Chart Styles or formatting options from the Design tab.
Edit Axes: Right-click the axis and select Format Axis to change scale, labels, etc.
3. Common Chart Types
Column/Bar Chart: comparisons
Pie Chart: proportions
Line Chart: trends in change over time.
Scatter Plot: Displays associations between two variables.
Module 4: Working with Data Sorting and Filtering Tools
1. Sort Data
Column to sort
Go to Data > Sort and order, select the order
Sort by: Option for multi-level sort, such as by name then date
2. Filter Data
Select range of data to filter
Go to Data > Filter
Arrow in column header to filter for text, number, or condition.
Clear filters using Data > Clear.
Practice Exercises
Make a Table: Input a list of items, prices, and quantities. Use formulas to compute totals (for example, =Price*Quantity in each row).
Format Apply: Add bold headers, color-code cells, and borders.
Make a Chart: Use the total column to make a bar chart of item sales.
Sort and Filter: Sort the list by highest price and filter to show items above a certain price.
Learning Outcomes
By the end of this course, you’ll be able to:
Navigate and manipulate spreadsheets.
Use basic formulas for calculations.
Format data for better readability.
Create and customize charts.
Sort and filter data for analysis.
Basic Microsoft PowerPoint Course Outline
This course will teach beginners how to create, format, and present engaging PowerPoint slides.
Module 1: Introduction to PowerPoint
1. What is Microsoft PowerPoint?
A tool for creating presentations with slides containing text, images, charts, and multimedia.
2. Opening PowerPoint
Open the application from the Start menu or desktop shortcut.
Choose between Blank Presentation or a Template.
3. Understanding the Interface
Ribbon: at the top with tabs such as Home, Insert, Design, and Animations.
Slide Pane: shows a preview of the slides on the left.
Workspace: this is the main area where you will design your slide.
Notes Pane: add speaker notes below the workspace of your slide.
Module 2: Creating and Formatting Slides
1. Adding Slides
Go to Home > New Slide or use the keyboard shortcut Ctrl+M.
Select a slide layout for example Title Slide, Title and Content, Two Content.
2. Adding Content
Text: Click a text box and begin typing. Use the Home tab for font style, size, and color.
Images: To add images from your computer or online, go to Insert > Pictures.
Shapes: To add rectangles, circles, arrows, etc., use Insert > Shapes.
Icons: Insert icons via Insert > Icons for professional visuals.
3. Formatting Slides
Themes: Apply a pre-designed style by going to Design > Themes.
Background: Use Design > Format Background to add colors, gradients, or images.
Align Objects: Select objects and use Format > Align to arrange them neatly.
Module 3: Adding Multimedia and Effects
1. Adding Multimedia
Videos: Go to Insert > Video and choose a file. Resize and position as needed.
Audio: Use Insert > Audio to add background music or voiceovers.
2. Animations
Add Animations Select an object, then go to Animations and choose effects like Fade, Wipe, or Fly-In.
Animate Object Animating animations using Animation Pane by controlling timing and order
3. Slide Transitions
Transitions Go to Transitions and select effects like Morph, Push, or Dissolve between slides
Adjust timing and apply transitions to all slides for consistency
Module 4: Presenting and Sharing
1. Slideshow Mode
Start presentation with Slide Show > From Beginning or with F5.
Start at current slide by using Shift+F5.
Using arrow keys or mouse, one can move around the slides
2. Presenter View
Using Presenter View enables speaker notes along with a preview of upcoming slides.
To make use of it, one would need to connect a second screen or projector
3. Printing Handouts
File > Print
Print Layout options such as Slides, Notes Pages, or Handouts
Grayscale or Color printing
4. Saving and Sharing
Save as Presentation: Save as.pptx to be edited later.
Export to PDF: Use File > Export > Create PDF to share static slides.
Sharing Online: Use File > Share to collaborate via email or OneDrive.
Practice Exercises
Create a 5-Slide Presentation:
Slide 1: Title Slide (Title and Subtitle).
Slide 2-4: Content Slides (Text, Images, and Icons).
Slide 5: Thank You Slide.
Apply a Theme: Use a theme and customize the background.
Add Animations and Transitions: Apply effects to text and transitions between slides.
Present Your Work: Use Slide Show mode to present.
Learning Outcomes
When you complete this course, you will be able to:
Produce professional PowerPoint presentations.
In Easysolution, interface elements layouts can be configured to automatically change size on different devices on iPad, split view, when the screen is rotated, and more. It’s essential that you design an adaptable interface provides great experience in any environment.
WhatsApp us