Advanced excel skills how to#
Advanced excel skills software#

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.

In addition, the overview of storing and sharing files will to help you determine the best place to keep your document.

Advanced excel skills how to#

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.The interactive test consists of multiple-choice, short answer and interactive input questions that cover a range of topics, including pivot tables, VLOOKUP formulas, and cell formatting. 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. An Advanced Excel test is an online assessment that measures a candidate’s ability to use Microsoft Excel for complex data analysis and reporting tasks.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.

Advanced excel skills software#

Excel is a software programme from Microsoft which uses spreadsheets to help you organise numbers and data.