Skip to main content

Microsoft Office 2013 Training Bundle

LE018

Do you want to improve your Microsoft Office skills to enhance your career? Then this Microsoft Office 2013 Training Bundle could be perfect for you.

Course duration

Up to 1 year.

Course outcome

Certificate of Completion for Microsoft Word, Excel, PowerPoint, Access and Outlook 2013.

Entry requirements

No previous knowledge is required to enrol onto this course, just a basic knowledge of IT is recommended.

Assessment

Exam simulations after each module.

Study Options

This course is only available to study online.

Study Options

 
£329.00
or £9.51 /month*
Course code: LE018

*Pay monthly option available via Snap Finance on payment page in checkout

visamaestromastercardpaypalamexdiscoverdinerselo

Course overview

  • Learn the fundamentals of Microsoft Access 2013.
  • Master Microsoft Excel 2013 including formula creation and conditional formatting.
  • Develop skills with Microsoft Powerpoint 2013.
  • Master Microsoft Word 2013 including Mail Merge and Custom Configuration.
  • Develop skill with Microsoft Outlook 2013.

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.

During this Microsoft Office 2013 Training Bundle, you will explore setting up databases, rearranging data, presentation slide design and animations, and much more.

Home learning is simple and stress free, so why not enrol today and join the 110,000 students who have chosen Open Study College to improve their career prospects.

Course content

  • 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

  • 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

  • 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

  • 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

  • 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

Extra information

Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage.

With this flexible home learning course you can fast-forward, rewind or repeat all the online classes so you can go at your own pace. You will have a full 12 months to complete the course.

Upon successful completion of each of the courses in this bundle, you will receive a certification of completion so you can showcase your achievement to future employers. Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these.

Upon successful completion of this course, you will able to use it towards your university application. We recommend that you check with your chosen University that they accept this qualification as part of their entry requirements. If after, you’re looking to enhance your IT knowledge even further, take a look at the other IT and computer courses we offer.

Here are some job titles that frequently use Microsoft Office:

  • Administrative assistant
  • Data entry clerk
  • Human resources assisant
  • Project coordinator
  • Marketing coordinator
  • Executive assistant
  • Customer service representative
  • Financial analyst
  • Sales coordinator
  • Event planner

FAQs

No previous knowledge is required to enrol onto this course, just a basic knowledge of IT is recommended.

  • Dedicated learner services
  • FREE CV critique service
  • FREE employability guide to help you impress future employers
  • FREE XO Student Discounts membership

If you decide to sit the exam you will have to book and pay to take these exams and the examination centre you choose. You can find your closest exam centre on the Pearson Vue website.

That's not a problem. We want to make sure you're 100% confident about enrolling on the course and starting your study. So, just give our team of education specialists a call on 03300 563 100 and they'll do their best to help.

Related courses