Sunday, 30 July 2017
Thursday, 27 July 2017
syllabus
Overview
The online Microsoft Excel 2013 Beginner, Intermediate & Advanced
course will provide learners with a core understanding of how to effectively
operate and use the Excel spreadsheet software. Whether you need to learn the
skills for work, want to fill the gaps in your CV or simply fancy learning
something new, this Excel beginner course is perfect to do so.
Description
The online Microsoft Excel Beginner, Intermediate & Advanced course
will provide learners with a core understanding of how to effectively operate
and use the Excel spreadsheet software at an advanced level. Whether you need
to learn the skills for work, fill the gaps in your CV or simply fancy learning
something new, this Excel Advanced course is perfect.
Course Syllabus
Basic Level:
- Introduction
to Spreadsheets
- Understanding
Microsoft Excel
- Excel
Workbook Windows
- Basic
Spreadsheet Skills
- Excel
Help System
- Opening
and Closing Workbooks
- Understanding
Workbook File Formats
- Creating
New Workbooks
- Selecting
Cells
- Auto
Sum and Auto Fill Function
- Cell
Referencing and Request
- Formatting
Cells
- Formatting
Numbers
- Placing
Cell Alignment
- Cell,
Rows and Columns
- Understanding
Worksheets
- Editing,
Copying and Moving Cells
- Page
Layouts in Excel
- Proofing
Workbooks
- Basic
Options, Ribbons and Toolbar
- Final
Assessment
Intermediate Level:
- Introduction
to Excel Spreadsheet Intermediate Level
- Defining
Names in Excel
- Sorting
Data
- Using
Excel Tables
- Filtering
Data in Excel
- Understand
Charts
- Chart
Design Options and Tools
- Chart
Format Tools
- Combo
Charts
- Functions
within Excel
- Understanding
Date Function
- Information
Functions
- Logical
Functions
- Financial
Functions
- Find
and Replace
- Headers
and Footers
- Adding
Comments
- Conditional
Formatting
- Final
Assessment
Advanced Level:
- Introduction
to Excel Advanced
- Using
Text to Columns
- The
Paste Special Function
- Data
Validation
- Subtotals
and Grouping
- Consolidating
Data
- Scenario
Analysis
- Data
Tables in Scenario Analysis
- What-if
Analysis
- Mats
and Trig Functions
- Text
Functions in Excel
- Using
Lookup Functions
- Vlookups
- HLookups
- Using
Statistical Functions
- Databse
Functions
- Formaula
Auditing and Error Tracing
- Hyperlinks
in Excel
- Linking
Data
- Understanding
Pivot Tables
- Using
Pivot Charts
- Workbook
Properties
- Protecting
and Sharing Worksheets
- Data
Encrypting and Finalising Workbooks
- Understanding
to Macros
- Custom
Number Formats in Excel
- Using
Custom Lists
- Working
with Templates
- Tracking
Changes in Excel
- Merging
and Compare Excel Workbooks
- Final
Assessment
- Microsoft
Excel Software
This course relates to Microsoft 2013 software. In order to complete the
course, learners should have their own copy of Microsoft Excel 2013. If learner
does not own a copy of the software, Microsoft provide a free trial version of
Microsoft Excel 2013.
Assessment
To assess the learners ability and knowledge to effectively understand
the topics contained within the Microsoft Excel Basic, Intermediate &
Advanced course, the course features a number of end of module interactive quiz
questions.
Additionally, at the end of the course learners will also take an online
multiple choice assessment test. This online multiple choice test is marked
automatically so you will receive an instant grade and know whether you have
passed the course.
Certificate
On successful completion of this Microsoft Excel Basic, Intermediate
& Advanced course learners will receive a CPD Certificate of Achievement
award from Oplex Careers.
This certificate will be produced in PDF format, hard copies of the
certificate will be available at an additional fee of £9.99.
Course Format
This course is delivered online through eLearning. Learners of the
course will receive instant access to our interactive student learning portal,
which offers 24/7 access to the Microsoft Excel Basic, Intermediate &
Advanced course.
Course Duration
The online Microsoft Excel Basic, Intermediate & Advanced course
requires 90 hours to complete the course in full. This is only a guide to the
learning hours required and it depends on how quickly an individual can absorb the
information. The learning is online so it can be spread out over multiple
sessions or done in one session.
Learners will have access to this course for up to 12 months from the
date of joining. There is no time limit to complete the course during this period.
Tutor Support
When you are studying a course it is always useful to know that you have
the help and support of tutors that want you to succeed in your studies.
As part of the Microsoft Excel Basic, Intermediate & Advanced course
you will receive access to our dedicated tutor support service. The academic
tutors will be able to provide you with unlimited online email support to help
answer any questions that you may have whilst you are studying the course.
Course Compatibility
Our Microsoft Excel Advanced course is fully compatible with PC’s,
Mac’s, Laptop, Tablet and Smartphone devices.
We know that more and more people are using the web whilst they are on
the move, so we have designed this Microsoft Excel Advanced course to be fully
compatible across tablet and smartphone devices. You will be able to access the
same content from the course, just over a 3G or 4G network whilst on the move.
Wednesday, 12 July 2017
Spreadsheet
Google Docs spreadsheet is a free and simple way to keep data in a spreadsheet form. If you add a lot of information, knowing how to quickly search for a keyword or topic is handy.
1
Browser
-
1Open the Google Docs spreadsheet in Drive.
-
2Open the tab that is relevant for your search.
-
3Open "Find and Replace". There are two ways to do this:
- Drop-down menu: Click on the Edit tab in the drop-down menu. Scroll down to Find and Replace.
- You can also do the short key by pressing CTRL+H or CTRL+F on your keyboard. The “Find and Replace” window will appear.
- Drop-down menu: Click on the Edit tab in the drop-down menu. Scroll down to Find and Replace.
-
4Type the term or word you're searching for into the Find box. Don't put anything in the Replace box unless that's the action you're wanting to perform.
-
5Click Find. The document is searched and if the term or word is there, the first occurrence of it will appear (it will have a blue box around it in the spreadsheet).
- You can continue scrolling for more by clicking on Find again. It will jump to the next occurrence if there is one. If it finds nothing, it will tell you "No more results, looping around".
- 6Exit. When you’re done, click “Done” at the bottom of the window to exit the “Find and Replace” window and go back to your spreadsheet.
2
Google Sheets App
-
1Launch Google Sheets. Locate the app on your device and tap on it. The app icon has a green document or file icon on it.
- You won’t need to sign in, unless this is your first time to use the app.
-
2View your Google spreadsheets. All your Google spreadsheets, those you own and those shared with you, will be displayed. Swipe through the list and find the spreadsheet you’d like to open.
-
3Open a spreadsheet. Tap the spreadsheet you want to view. It will be opened on your screen.
-
4Access the search function. Search can be accessed from the menu. Tap the button with three vertical dots on the top right corner to bring out the menu. Tap “Find and Replace” from here, and a header search box will appear at the top of your spreadsheet.
-
5Do a search. Enter the word, number, or string you want to look for in the search box. Tap the Search key on your keypad to begin.
-
6View matches. If a match is found, the first cell containing the match will be highlighted and you will be brought to it.
- On the rightmost part of the header search box are two arrow buttons. The upward button goes to the previous match and the downward button goes to the next match. Tap the downward button to go to the next cell containing the match. Continue tapping this button to go through the matches until you find the data you’re looking for.
- 7Exit. When you’re done, tap the “X” button iHelpful 0
Subscribe to:
Posts (Atom)