Author › Dennis Taylor
Dennis Taylor has over 20 years of experience as a highly respected computer trainer and author, having developed over 50 Excel courses and authored or co-authored multiple books on Excel and spreadsheet software. He specializes in improving business efficiency and productivity using Excel and other data analysis programs. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the federal government, and the University of Colorado, he has taught over 3,000 seminars and classes to a wide variety of audiences.
-
The 2013 update to our popular series demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.
-
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
-
Explores the functions, commands, and techniques in Excel that quickly restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis.
-
Shares easy-to-use database commands and methods for maintaining an Excel database.
-
Spells out the design considerations and tools needed for creating a database in Excel.
-
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
-
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
-
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
-
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
-
Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.
-
Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.
-
Shows how to share data between multiple worksheets and workbooks, including tips for adding, moving, and navigating worksheets and workbooks efficiently.
-
Provides formula examples and demystifies some of the nearly 400 functions in Excel.
-
Shares tips and shortcuts to increase efficiency and get the full power out of Excel 2010.
-
Offers solutions for optimizing the use of dates and times in Excel 2007.
-
Offers solutions for optimizing the use of dates and times in Excel 2010.
-
Shows how to move and copy data to multiple worksheets and gives tips for efficiently adding, moving, and navigating worksheets and workbooks in Excel.
-
Demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros in Excel 2007.
-
Simple and powerful techniques for making data readable and understandable, including keyboard shortcuts and tips for smoother formatting.
-
Demystifies some of the most useful and challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.
