BASIC COURSE
MS-Word
Formatting Text
• Character formatting
• Paragraph formatting
• Shading
• Indent settings
Page Layout and printing
• Margins
• Headers and footers
• Page break
Tools to Save Time
• Format Painter
• Comments
Other Editing tools
• Bullets and numbering
• Adjusting margins
• Headers and footers
Styles
• Applying styles
• Saving the style
Graphics
• Importing graphics
• Text wrapping
• SmartArt
Tables
• Setting up a table
• Adjusting column, row, and cell height
Creating Forms & Templates
• Drop down menus
• Check boxes
• Text form fields
Tables of contents
• Automating with headings
• Updating
References
• Hyperlinks in a document
• Bookmarking
• Cross references
Additional Tools
• Watermarks
• Word count
Macros
• Recording a macro
• Adding the macro to the Quick Access
MS-Excel
Navigating to accomplish tasks
o Using the Ribbon, Office Button, and menus (depending on software version)
o Cells, columns, and rows
o Keyboard shortcuts
o Freezing and splitting panes
o Hiding columns and rows
Entering basic data into Excel
o Formatting dates and times
o Creating and modifying tables
o Sorting and filtering tables
Creating basic Excel formulas
o Subtraction, division, multiplication
o Other classes covering Excel formulas
Using functions
o Manually typing functions
o AutoSum and Auto Calculate
o Other classes covering Excel functions
Moving and copying data
o Cut, copy & paste
o Fill handle
o AutoFill
o Flash Fill
o Smart Tags
Organizing and Working with Multiple worksheets
o Renaming and coloring tabs
o Moving, copying, and inserting worksheets
o Margins
o Headers and Footers
o Printing Options
Basic Excel Formatting
o Adjusting width and alignment
o Formatting text in cells
o Wrapping and merging
o Formatting numbers
o Other classes covering Excel Formatting
Formulas & Functions
o Typing formulas and functions
o Cell references and reference formulas
o AutoSum
o The Functions Library
o Average, date, and time functions
o IF statements
o Nested IF Statements
o Other classes covering Formulas & functions
Moving and Copying Data in Excel
o Cut, copy, and paste data
o The Fill Handle
o Absolute and relative references
o AutoFill and custom Lists
Working with More Functions
o Date and Time Functions
o Calculating dates in years
o IF Statements in Date Functions
o The Proper Function
o The Roundup Function
Working with Multiple Worksheets
o Renaming worksheets
o Color coding tabs
o Moving and copying worksheets
o 3D reference formulas
o Hyperlinks
o ScreenTips
Formatting Cells and Appearance
o Formatting text and numbers in cells
o Merging cells
o Wrapping text within a cell
o Custom number formats
o Conditional formatting
o Copying formatting
o Other classes covering Excel formatting
Viewing Worksheets
o Showing formulas and references
o Tracing precedents and dependents
o Grouping rows and columns
o Cell comments
o Headers and footers
o Other classes covering Navigation and Views
Introduction to Basic Charts
o Creating and defining a chart
o Positioning, rotating, and resizing charts
o WordArt in charts
o Editing charts in Excel
o Changing types
o Formatting a data series
o Multiple series charts
o Sparkline charts
o Other classes covering Excel charts
MS-Power Point
Topic Covered
• Quick Access menu
• Moving through slides
• Views
• Zooming
• Building a new presentation
• Entering text
• Saving the presentation
Outline View
• Creating new slides
• Indent levels
• Cutting & pasting text
Slide Master & Slide View
• Formatting the slide master
• Applying designs and styles
• Working in the normal view
• Inserting new slides
• Customizing a slide
Pictures & Graphics
• Inserting pictures
• Resizing & moving pictures
• Placing a picture on a slide
• Placeholders
• Drawing shapes
Charts
• Adding a chart
• Editing data in a chart
• Formatting a chart
Transitions & Animations
• Slide sorter view
• Duplicating & rearranging slides
Creating a new presentation
• Inserting text from a file
• Deleting slides
• Adding text
• Organizing slides
Slide Master & Normal View
• Formatting the Slide Master
• Slide Master placeholders
• Slide Master fonts
• Changing slide layouts
• Working on a slide in normal view
Pictures & WordArt
• Inserting pictures
• Resizing & moving clip art
• Modifying pictures
• Adding pictures to the master slide as a back-
ground
• Adding pictures to content placeholders
• Adding WordArt
• Formatting WordArt
SmartArt
• Converting text to SmartArt
• Formatting SmartArt
• Creating SmartArt from scratch
Custom Animation
• Slide sorter view
• Applying custom animation
• Multiple animation effects
• Motion paths
Completing the Presentation
• Packaging for CD
• Linking slides
• Hiding slides
• Presentation tools
• Adding a background fill effect
• Editing the slide master
• Using a template
Custom Shapes and Text Animation
• Animating text
• Re-shaping placeholders
• Animating shape
• Animation settings
Builds Vs. Animation
• Image layering animation
• Adding WordArt
• Combining AutoShapes and WordArt
• Animating shapes
• Adding a chart as a picture
• Creating builds
• Adding an Excel chart
Video and Audio
• Adding a video file
• Microsoft animations
• Adding and adjusting audio clips
Presentation Tools
• Right-Click slide show menu
• Keyboard shortcuts
• Timing the presentation
OS (Operating System)
Files Copy Paste
Rename
Delete
Create New Folders/Files etc
INTERNET &
SOCIAL MEDIA
Creating Email Account
Online Ticket Booking
Face Book
You Tube
Songs & Videos Downloading