Introduction for Beginners
Next-Level Techniques
LinkedIn Learning - Excel Essential Training
Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program.
Microsoft Excel Video Training
A library of training guides and videos created by Microsoft.
YouTube - Excel Introduction
Excel Basics playlist includes Excel tutorials for those who're new to Excel and also for anyone who has used Excel for a while but has missed out on some of these techniques.
Basic Data Cleaning and Analysis for Data Tables, Video
A video on the basics of data cleaning and analysis from data analysts at Duke University.
LinkedIn Learning - VLOOKUP and XLOOKUP for Beginners
In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas.
O'Reilly Excel Insights
Dive into the world of advanced Excel techniques designed to elevate your data analysis skills. Start with mastering custom number formatting, efficient data entry, and powerful formulas like INDEX MATCH.
O'Reilly Microsoft Excel 365 Intermediate Course
In this course you will learn to design better spreadsheets, improve readability, and control data input with cell styles and validation. You'll streamline data analysis and comparison tasks by mastering logical functions, lookup formulas, and sorting techniques. Additionally, you'll delve into statistical and math functions, formatting, date and time manipulation, text and array operations, pivot tables, charts, and formula auditing.
YouTube - Excel Lookup Formulas
Excel has many great lookup formulas - such as VLOOKUP, INDEX MATCH and now the new Excel XLOOKUP function. This playlist will give you many ideas and formula combinations so you can use the best lookup formula for your task.
LinkedIn Learning - Pivot Tables for Beginnners
In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data.
YouTube - Excel Pivot Tables
Learn how to use Excel Pivot Tables, from beginner to advanced, with this YouTube playlist.
YouTube - Excel Charts
Learn about charting in Excel including bar charts, line graphs, pie charts, and histograms.
YouTube - Excel Intermediate Functions and Features
Watch this YouTube playlist to learn about intermediate Excel formulas.
Business Statistics Using Excel: A Complete Course in Data Analytics
by
How to Install the Bloomberg Excel Add-In:
Note: You should only have to do this process the first time you use this Bloomberg Terminal, or after computer maintenance has removed your profile.
Open Excel, accept the License Agreement if prompted, close Excel.
Go to Windows Start menu > All (top right corner under the search bar) > Bloomberg folder > Install Office Add-Ins and select it.
Click Install. A confirmation box will appear. Close the boxes.
Re-open Excel and the Bloomberg tab should be visible at the top.
Note: If errors appear in the confirmation box, repeat Step1 for each application with an Add-in error (e.g. Word, PowerPoint) and run Install Office Add-Ins again (Steps 2 and 3)
To install the Excel Plug-In for LSEG you will need to Download LSEG Workspace. There is a test you can download as well to verify your PC's compatibility. There is also a video you can watch on downloading LSEG Workspace here.
To install the Excel plug-in you will need to request the Workstation Access from the Service Desk here.
Darden Camp Library, First Floor, 100 Darden Blvd., Darden Business School, University of Virginia, Charlottesville, VA 22903 Mailing Address: Darden Camp Library, PO Box 6550, Charlottesville, VA 22906-6550 Google Map with Darden Library Email: library@darden.virginia.edu Phone: (434) 924-7321 FAX: (434) 924-3533
