Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Tech Skills and Software Trainings

State Library resources to help you improve with tech skills and specific software.

Excel Resources

Data Smart: Using Data Science to Transform Information into Insight

Data science is little more than using straight-forward steps to process raw data into actionable insight. And in Data Smart, author and data scientist John Foreman will show you how that's done within the familiar environment of a spreadsheet.

Why a spreadsheet? It's comfortable! You get to look at the data every step of the way, building confidence as you learn the tricks of the trade. Plus, spreadsheets are a vendor-neutral place to learn data science without the hype.But don't let the Excel sheets fool you. This is a book for those serious about learning the analytic techniques, the math and the magic, behind big data.

Excel Hacks

Excel Hacks

Microsoft Excel is not just the dominant spreadsheet in the world; it's also one of the most popular applications ever created. Its success lies not only in its power and flexibility, but also in its streamlined, familiar interface that casually conceals its considerable capabilities. You don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path.With this book, Excel power users can bring a hacker's creative approach to both common and uncommon Excel topics--"hackers" in this sense being those who like to tinker with technology to improve it.

Exchanging Data From SAS to Excel

Exchanging Data From SAS to Excel

Microsoft Excel remains the leading spreadsheet application on the market; nearly every SAS user will need to move their data and reports into Excel workbooks at some point during their career. Exchanging Data From SAS(R) to Excel: The ODS Excel Destination shows SAS users how to create Excel workbooks that are presentation ready, eliminating manual changes to the workbooks after creation.

Microsoft Excel 2016 Data Analysis and Business Modeling

Microsoft Excel 2016 Data Analysis and Business Modeling

Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.

R for Microsoft® Excel Users: Making the Transition for Statistical Analysis

R for Microsoft® Excel Users: Making the Transition for Statistical Analysis

Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis—if you can get over its learning curve. In R for Microsoft® Excel Users, Conrad Carlberg shows exactly how to get the most from both programs. Drawing on his immense experience helping organizations apply statistical methods, Carlberg reviews how to perform key tasks in Excel, and then guides you through reaching the same outcome in R—including which packages to install and how to access them. Carlberg offers expert advice on when and how to use Excel, when and how to use R instead, and the strengths and weaknesses of each tool.

Resources Organized by Content Level

A division of the State Library of Oregon | 250 Winter Street NE Salem, Oregon 97301 | Monday-Friday 8am-5pm | 503-378-8800 | LibraryHelp.SLO@state.or.us