Microsoft Office (Word, Excel, PowerPoint), Social Media Basics, Intro to Computer
The BC2 Digital skill Certification provides students and job-seekers with the foundation of knowledge they need to succeed in environments that require the use of computers and the Internet.
Duration:
Weekdays - 2 Months
Weekends - 3 Months
Course Description:
Microsoft Office (Word, Excel, PowerPoint), Social Media Basics, Intro to Computer
The BC2 Digital skill Certification provides students and job-seekers with the foundation of knowledge they need to succeed in environments that require the use of computers and the Internet.
Course Outline:
PC/IT Basics
Keyboard Basics
Microsoft Windows
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Internet Basics
CorelDraw
Microsoft Outlook
Microsoft Publisher
Advanced Internet
Who needs the Training:
Students
Office Assistants
Secretaries
Personal Assistants
Administrative Officers/Managers
Accountants
Marketing/Sales Offices
Students
Job Seekers or anyone that is required to work with computers on a day-to-day basis.
Microsoft Advance Excel
This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.
It is an instructor led course, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. We train on version 2013 which is almost identical to 2007, 2010 and 2016, please make the trainer aware on the day if you use a another version and they can point out anything that may be slightly different.
Overview
Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering. In addition, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analysing data, and using Excel data in other applications.
Duration
2 weeks
Course Outline
Define Names
Logical Functions
Validating Datas
Lookup Functions
Summarising and Subtotalling
Grouping and Outlining
Pivotable
Pivotable Features
Data Consolidation
Scenarios
Import and Exporting
Solvers
Controls
Recorded Macros