Databases
- LinkedIn LearningLinkedIn Learning offers online instructional videos on software applications such as Excel, PowerPoint, and even how to become a more effective presenter!
- PFP quick guideExplore e-books, video tutorials and journal databases
Resources for MS981Y
- Excel 2019 Essential Training : Getting Started with ExcelThis video shows functionality of Excel, where you can use it to:
- prepare spreadsheets
- analyze data using Pivot Table
- organize and present data (such as charts) - Creating totals and averagesThis video shows you how to calculate totals and averages using simple formulas
- Copying a formula for adjacent cellsThis video shows you how to create a worksheet to perform similar functions across cells.
- Working with relative, absolute, and mixed referencesThis video shows how to apply relative (across different cells), absolute (within fixed cell) references.
- Excel 2019 Essential Training : Exploring Chart TypesThis video shows different chart types for effective presentation of data
- Venngage: How to choose the best charts for your infographicThis page provides some ideas on picking the best charts for effective data presentation
- FluidSurveys: How to use 6 basic charts to create effective reportsThis page gives you some examples of chart types to help your determine the most effective way of presenting your data
Watch this video to see how data and charts can be used to tell a compelling story!
- Excel: Charts in DepthExplore more chart types contained within Excel 2019 such as Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker
Explore effective visual communications using charts. Even though this video involves the use of Microsoft PowerPoint, the suggestions are applicable
Beyond MS981Y
- LinkedIn Learning: Using other common functionsThis video shows the common functions within Excel and how to use them effectively
- LinkedIn Learning: Top 10 shortcutsExplore functions such as:
- Entering data or formulas in nonadjacent cells simultaneously
- Entering current data or time
- Adjusting column widths or row heights - Excel: Tips and TricksExplore the full set of tips and tricks within to help save time and get work done efficiently
- Using formulas to link worksheets and workbooksThis video shows how to incorporate formulas to calculate figures across worksheets and workbooks
- Using IF functions and relational operatorsThis video shows you how to make use of IF functions to test conditions (e.g. for scenario analysis)
- Getting approximate table data with the VLOOKUP functionThis video shows you how to use the VLOOKUP (or vertical lookup) function to compare data in a vertical table. This allows you to return values contained within a reference table
- Getting exact table data with the VLOOKUP functionThis video shows you how to use the VLOOKUP (or vertical lookup) function to perform exact matching of data
- TechOnTheNet: How to use the VLOOKUP Function (WS)Refer to this website to find out how to use the VLOOKUP function with syntax and examples
- Using the COUNTIF family of functionsThis video shows you how to use COUNTIF, SUMIF and AVERAGEIF functions
- Sorting dataThis video shows you how to sort data (according to specified criteria) using multiple levels for better organization of a large dataset
- Using filtersThis video shows you how to filter data in a large datasheet in order to save time when searching for specific data
- Creating PivotTablesThis video shows you how to create a PivotTable. PivotTables allow users to summarize, analyse, explore, and present data from a large dataset
- Microsoft: Create a PivotTable to analyze external dataRefer to this website to find out how to connect to external data source for creating PivotTable to analyse external data
- Using Goal SeekThis video shows you how to use the GoalSeek function. It allows you to find the result you want by adjusting an input value, e.g. amount of loan repayment based on pre-specified interest rate within specified period
- Using SolverThis video shows how to use Solver function. This involves techniques from operations research to find optimal solutions for decision problems (e.g. optimizing sales while maintaining gross profit level)
Contact SP Library
 |
Email Us |
 |
Project Advisory Service |
 |
SP Library Facebook |
 |
Call 6775 1133 |