Event box
Microsoft Office Specialist in Excel - Advanced (MOS 4/4) In-Person
Microsoft Office Specialist in Excel – Advanced (MOS 4/4)
Brief Outline
Not only could this session contribute to your training and preparation for the MOS exam for Excel 2016, but it can also be a stand-alone Excel session teaching you some of the advanced skills and functions of the program.
This session focuses on the more advanced skills and functions of Excel with most of the focus being on working with formulas and functions.
Learning Outcomes
-
Creating a formula with values that match your conditions
-
editing defined conditions in a formula
-
using a series of conditional logic values in a formula
-
precedence of operators for per cent vs. exponentiation
-
Defining, editing and renaming a named range
-
Entering a cell range definition in the formula bar; defining a cell range using the mouse; defining a cell range using a keyboard shortcut
-
Relative, absolute
-
Using Line, Column and Win/Loss chart types; creating a Sparkline chart; customising a Sparkline; formatting a Sparkline; showing or hiding data markers
-
using the Rule Manager to apply conditional formats
-
using the IF Function and Apply Conditional Formatting
-
Icon sets, data bars, clear rules
Pre-requisites
If attending this session as part of working toward the MOS certification in Excel, it is essential that you have attended the Foundation and Intermediate sessions in Excel, or spoken to Staff Development about your Excel skills.
If attending this session as a stand-alone session, a very good understanding of Excel and “better than average” skills with the application are needed. Please contact Staff Development if you have any questions about suitability or the MOS certification.
- Date:
- Tuesday, April 16, 2019 Show more dates
- Time:
- 9:30am - 12:30pm
- Time Zone:
- UK, Ireland, Lisbon Time (change)
- Location:
- Room CD113, Academy House, Colindeep Lane
- Campus:
- Colindeep Lane, NW9 6HB
- Categories:
- Using Technology & University Systems
Event Organizer
Email: staffdev@mdx.ac.uk
Intranet: www.intra.mdx.ac.uk/tools-policies/your-development
Phone: 020 8411 6212