Skip to Main Content

CEC PD Resources: Excel Skills for Business : Essentials

Videos

Books

Excel 2010 for Dummies® by Greg Harvey
ISBN: 9780470489536
Publication Date: 2010-04-26
Maths Trails by Jennifer Piggott; Liz Pumfrey; Graeme Brown
ISBN: 9780521700436
Publication Date: 2008-11-27
Taxmann's research methodology : with live case studies, excel applications on CD / Prasant Sarangi.
ISBN: 9788171947379
Office 2010 Web Apps for Dummies by Stephanie Krieger; Peter Weverka
ISBN: 9780470631676
Publication Date: 2010-10-26
Office 2007 Bible by John Walkenbach; Gavin Powell; Faithe Wempen; Cary N. Prague; Herb Tyson; Peter G. Aitken; Michael R. Groh; Lisa A. Bucki; Michael R. Irwin
ISBN: 9780470046913
Publication Date: 2007-06-05

Major Excel Skills

Excel Skill #1: PivotTables

Excel Skill #2: Flash Fill

Excel Skill #3: Filters

Excel Skill #4: Conditional Formatting

Excel Skill #5: COUNTIF

Excel Skill #6: Charts

Excel Skill #7: SUMIF

Excel Skill #8: IFERROR

Excel Skill #9: Slicers

Excel Skill #10: Power Pivots

Excel Skill #11: Sparkline

5 Advanced Excel Skills to Consider Learning

ebooks

Working with Excel by Priscilla Chaffe-Stengel; Donald N. Stengel
ISBN: 9781606492819
Publication Date: 2012-12-08

Excel for accountants [electronic resource] / Conrad Carlberg

Power Excel with Mrexcel by Bill Jelen
ISBN: 9781615473489
Publication Date: 2015-04-01
Excel 2016 Formulas by Michael Alexander; Richard Kusleika
ISBN: 9781119067986
Publication Date: 2016-01-21
Financial Modeling in Excel for Dummies by Danielle Stein Fairhurst
ISBN: 9781119357568
Publication Date: 2017-04-11

Next generation Excel [electronic resource] : modeling in Microsoft Excel for analysts and MBAs (for Windows and Mac OS) / Isaac Gottlieb.

Excel 2013 Formulas by John Walkenbach
ISBN: 9781118491799
Publication Date: 2013-03-18

Articles

Useful websites

Videos