![]() ![]() Being certified as an MOS Master demonstrates you have the deepest level of skills needed to proficiently use key Office programs. MOS Master-Pass exams in Word or Excel to earn a Microsoft Office Specialist Master certification. ![]() Being certified as an MOS Expert demonstrates you have advanced skills in key Office programs.įind training and earn an MOS Expert certification MOS Expert-Pass exams in Word or Excel to earn a Microsoft Office Specialist Expert certification. Microsoft Excel is a spreadsheet programme which supports the creation of financial, statistical and other. Find training and earn a MOS certification in: Being certified as a Microsoft Office Specialist demonstrates you have the skills needed to get the most out of Office. Your University OneDrive is deleted when you leave the University, so it's best to create or move your file elsewhere unless it's personal to you.Microsoft Office Specialist-Pass an exam in a specific Office program to earn a Microsoft Office Specialist certification. In addition, the overview of storing and sharing files will to help you determine the best place to keep your document. Review the guidance on how to share your Excel workbook with others. Using COUNTIF or SUMIF functions to create a simple table of your data - step-by step instructions and videos, with examples and best-practice advice.Creating and formatting a chart to summarise and visually present your data (step-by step instructions and videos), plus additional recorded bite-sized webinars in Moodle.Summarising and visually presenting your data using charts The bite-sized recordings in Moodle provide an introduction and show the basic processes for running and recording Macros, though please also be aware of the enhanced security measures which apply to Macros downloaded from the internet. If you are a daily user of Excel, such as those in Finance roles, you may sometimes wish to record or run Macros (a mini-program or a structured list of instructions) that tell Microsoft Excel, very specifically, what it should do. Using PivotTables to summarise your data to quickly reorganise and summarise large tables of data - recorded bite-sized webinars in Moodle.Using Advanced functions such as IF Functions, Conditional Formatting, and VLOOKUP to determine and apply rules about what information or formatting to put into cells, or to search your data - recorded bite-sized webinars in Moodle.Creating formulae and functions to quickly create and apply calculations - recorded bite-sized webinars in Moodle.Guidance and resources about specific functionality:.An introduction to extracting information from your data - step-by step instructions and videos.An overview of managing your data better through sorting, filtering and subtotals - recorded bite-sized webinars in Moodle. ![]() ![]() Hints and tips for quicker ways of working in Excel.Creating an Excel Spreadsheet - step-by step instructions and videos.Getting started with Spreadsheets - recorded bite-sized webinars in Moodle.Options to quickly create charts to present your data visually, such as a bar or pie chart.Įxplore online step-by step guidance and videos about Excel within our University of Bath Learning Pathways site, or use the links below to quickly access resources about key topics.Functionality such as formulas and functions to help you organise, find and analyse your data.Excel is a software programme from Microsoft which uses spreadsheets to help you organise numbers and data. ![]()
0 Comments
Leave a Reply. |