Course description
Including Word, Excel, Outlook, PowerPoint and Outlook, this course will not only cover the basics but more advanced powerful settings of these Office Tools to make your current job responsibilities easier. Home learning is simple and stress free, so why not enrol today and join the [past_students_count] students who have chosen Open Study College to improve their career prospects.
Course Content
Microsoft Access 2013
- Access 2013 introduction
- What are databases
- The interface window
- Setting up the database
- Creating forms
- Understanding table relationships
- Queries
- Reporting
- Table tools
- Forms and design
- Forms data entry
- Specialised form
- Customization and conclusion
Microsoft Excel 2013
- Introduction to excel
- Ribbon elements
- Entering data and editing font attributes
- Number formats
- Formating cells
- Printing
- Formulas
- Rearranging data
- Charts
- Conditional formatting
- Data validation
- Named ranges
- CSV files
- Text to column
- Grouping data
- Working with windows
- Headers and footers and protecting data
- Pivot tables
- Sparklines
- Trancing formulas
- What if scenario
- External data sources
- Customizing menus and options
- Macros
Microsoft Powerpoint 2013
- Introduction to PowerPoint
- Screen elements
- Starting a new presentation
- Layout
- Objects
- Slide design and transitions
- Animations
- View and slideshow
- Understanding slide masters
- Hotspots and actions
- Printing options
- Inserting charts
- Setting up slide shows
- Templates vs shows
- Reviewing information and compare
- Copy and paste across presentations
- Adding media video and audio
Microsoft Word 2013
- Screen layout
- Page setup and text entry
- Auto-correct text formatting
- Paragraph attributes
- Customizing bullets and numbers
- Reveal codes putting it all together and saving
- Viewing rulers
- Formating and inserting images
- Tabs
- Window views and putting it all together
- Headers and footers
- Section breaks and footers
- Tables in word
- Inserting text boxes
- Mail merge
- Working with outlines
- End notes and foot notes
- Captions and citations
- Table of authorities
- Reference page index table
- Track changes
- Compare
- Advanced smart art
- Templates
- Custom configuration
Microsoft Outlook 2013
- Understanding email setting outlook
- Configuring interface
- Email window
- Managing the inbox
- Using the calendar
- Contacts
- Task list
- Adding an account From scratch
- Multiple email accounts in one window
- Searching for mail
- Managing the folders view in inbox
- Using priority and receipts
- Calendars
- Auto-replies
- Signatures
- Advanced options
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Why choose Open Study College
Trusted by over 110,000 students
Study from home, at your own pace
Discounts on selected courses
Expenses
Pay Now: GBP 299.00
OR 6 Monthly Instalments of GBP 59.85 with a deposit of GBP
39.90 totalling 399
Get Inspired! Watch the Video
Request info
Ads