Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen - H. Albert Napier, PhD & Ollie N. Rivers

Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen

By H. Albert Napier, PhD & Ollie N. Rivers

  • Release Date - Published: 2013-05-07
  • Book Genre: Computers
  • Author: H. Albert Napier, PhD & Ollie N. Rivers
Our rating: 5/5 stars

Score: (From 0 Ratings)

Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen H. Albert Napier, PhD & Ollie N. Rivers read online review & book description:

Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen

Course Description
Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen is a three-lesson basic to intermediate level course. The course guides you through creating, copying/pasting, filling, reviewing, and correcting basic and complex formulas in Excel 2013 using step-by-step hands-on activities. 

In Lesson 1 you learn about the syntax of formulas and about Excel’s predefined formulas, called functions. Then you create basic formulas by entering the formulas into cells manually, by using the Sum (AutoSum) feature, and by copying/pasting and filling existing formulas into adjacent cells. You also learn how to use status bar options to quickly find the sum, average, minimum, maximum, and number of values for a range without creating a formula.

In Lesson 2 you learn how to use the Formula AutoComplete feature, how to enter formulas on grouped worksheets, and how to create formulas with 3-dimensional references—references that span worksheets and workbooks. Next you use the Function Library to add the current date and time to a worksheet and to create a formula that performs two logical tests. Then you learn to use defined names and column or row labels as function arguments. Finally, you learn how to apply conditional formatting to formulas.

In Lesson 3 you learn how to use tools that help you identify and correct errors in formulas and other kinds of worksheet errors including the Error Checking feature and the Trace Error icon, the Formula Auditing tools, the Watch Window, displaying a workbook in more than one window and splitting a worksheet into multiple viewing panes, and protecting a worksheet.

Note that this course emphasizes using finger gestures and keyboard actions to perform tasks in Excel 2013. Information on using the mouse pointer to perform tasks is not provided.

NOTE
The Napier & Rivers course Microsoft® Excel® 2013: Working with Formulas and Functions emphasizes using traditional mouse pointer and keyboard actions to perform tasks in Excel.

@2019 – Go Read a Book. All Right Reserved. goreadabook.org is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for website owners, to earn advertising fees by linking and advertising to amazon.com and any other website that may be affiliated with Amazon Service LLC Associates Program; As an Amazon Associate I earn from qualifying purchases.

Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen book review Microsoft® Excel® 2013: Working with Formulas and Functions Using a Touch Screen ePUB; H. Albert Napier, PhD & Ollie N. Rivers; Computers books.

Post a review about this book