Information Processing 10, 20, 30

(a)	Explain circumstances in which a specific function (e.g., financial, logical, text, date and time, lookup and reference, math and trigonometry, statistical) might be used with a set of data.
(b)	Differentiate between the application of relative and absolute cell references in a spread sheet.
(c)	Include components such as hyperlinks, graphics, graphs and sparklines to increase the efficacy of spreadsheets.
(d)	Demonstrate reordering and renaming of sheet tabs within workbooks to match worksheet conventions.
(e)	Insert headers and footers that provide relevant information (e.g., date, file name or source, page number, document ownership).
(f)	Link information in one worksheet to another worksheet in the same workbook and from one workbook to another.
(g)	Link information from a spreadsheet to another application such as a word document.
(h)	Query and filter and sort data within a spreadsheet.
(i)	Apply conditional formatting to enable visual analysis of data in spreadsheets.
(j)	Investigate how various advanced functions (e.g., SUMIF, SUMIFS, AverageIF, SUMPRODUCT) can be used to manipulate data.
(k)	Use advanced functions to process information in multi-sheet workbooks (e.g., keep and analyze statistics for the basketball team; maintain financial records for a term loan).
(l)	Use lookup tables to present information such as variable income tax rates, volume discounts offered by retailers and wholesalers, or shipping charges based on weight or quantity.
(m)	Apply financial functions such as payment, future value of money, present value, rate and return to scenarios related to loans, credit cards, investments and other money management issues to a spreadsheet.
(n)	Apply advanced functions such as CHOOSE, ROUND, COUNT, IF, AND OR, and FALSE to solve complex problems.
(o)	Research the features of and uses for pivot tables and charts.
(p)	Use pivot tables to summarize large amounts of data and pivot charts to display the data graphically.
(q)	Explore the use of macros in a spreadsheet and how they may be created using tools such as Visual Basic for Applications (VBA).
(r)	Incorporate multi-sheeted workbooks containing advanced functions into other software or applications.

← INFO15D

INFO16A →

Resources

R012546

Excel 2019 in Easy Steps

This resource offers information about Excel 2019 for introductory to advanced levels. It can serve as a reference book to guide learners to use the functions and features of Excel by following the basic instructions and visual supports provided.

Media and Formats : Book

Price : $23.95

Record posted/updated: December 8, 2021

R022403

Office 2019 in Easy Steps

The key features of five Microsoft Office 2019 programs - Word, Excel, Access, PowerPoint and Outlook - are presented in this resource. Instructions for creating and managing files and data in all programs, as well as time-saving shortcuts, provide a good introduction to effectively using the core applications in Microsoft Office 2019.

Media and Formats : Book

Price : $23.95

Record posted/updated: February 22, 2022

R012465

Microsoft Excel 2019 Bible

This book sequences beginner to advanced skills using Excel. The resource offers many supportive graphics and concise language to explain tutorials on specific topics. An extensive table of contents and index are included.

Media and Formats : Book

Price : $66.00

Record posted/updated: December 7, 2021

R012466

Microsoft Excel 2019: Data Analysis and Business Modeling(6th ed.)

This resource provides advanced and comprehensive information about Microsoft Excel 2019 in the context of business. It contains concise directions to use the various functions and offers problems for practice at the end of each chapter. There are practice and solution files available on a companion website. An extensive table of contents and index are included.

Media and Formats : Book

Price : $58.40

Record posted/updated: December 7, 2021

R014656

Microsoft Excel 365 Complete in Practice 2019

This resource provides complete guide to becoming proficient is using the Microsoft Excel 365 program. Students could use this as a textbook, or the teacher could incorporate sections into a course.

Media and Formats : Book

Price : See publisher.

Record posted/updated: June 16, 2022

R012545

Microsoft Office 365 and Office 2019 Introductory

This book goes through very detailed instructions of three projects in each of the following programs: Word, Excel, Access, and PowerPoint. Many graphics and screenshots are provided to accompany the text. It would be most suited for a student or teacher who was unfamiliar with these programs.

Media and Formats : Book

Price : $149.95

Record posted/updated: December 7, 2021

R022893

Your Office. Microsoft Office 365 Excel 2019 Comprehensive

This spiral bound reference book provides a thorough exploration of Microsoft Excel 2019 and its features. Each chapter offers accessible online projects that use real world and business scenarios. The step-by-step tutorials provide hands-on learning. Supplemental instructor resources are available.

Media and Formats : Book

Price : $199.99 USD

Record posted/updated: December 8, 2021

R014931

Microsoft Office 365: A Skills Approach(2019 ed.)

This spiral bound reference book provides a thorough exploration of Microsoft Office 365 and its features. There are sections dedicated to Office, Word, Excel, Access and PowerPoint. Each one has chapters that explore the basics of how to get started and how to format and apply some of the features of the programs in a progression from beginner to advanced levels. Detailed instructions with visual support are provided throughout the resource. There are chapter summaries, guided practice, and independent and challenge projects. Practice files are available on the publisher's SIMnet online platform.

(More information)

Media and Formats : Book

Price : $175.33 USD

Record posted/updated: December 8, 2021