Catalog Search Results
Author
Series
Language
English
Description
For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns...
Author
Series
Language
English
Description
Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed,...
Author
Series
Language
English
Description
The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-related information are also presented.
Author
Series
Language
English
Description
Addressing a classroom teacher's need to simultaneous manage a classroom full of students, meet state mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom. Tracking attendance, grades, and books in the school library, creating reports to share with parents at parent-teacher conference time, and teaching basic charting concepts...
Author
Series
Language
English
Description
This guide to enabling middle-grade mathematics teachers to use Microsoft Excel in the classroom focuses primarily on concepts taught in grades 4–10, with some pre-algebra lessons for higher grades. Including files available for downloading to create custom math worksheets, build self-grading interactive spreadsheets, and use Excel to demonstrate charts and Cartesian math, this handbook provides fun examples of probability, solving equations, magic...
Author
Series
Language
English
Description
With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet,...
Author
Series
Language
English
Description
Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing time spent on analytics. The book explores the entire gamut of finance-related functions and is focused on practical approaches to using Excel-including Pivot Tables, Goal Seek, Scenario Builder, and VBA-in problem solving to deliver quality results. Using case studies across...
Author
Series
Language
English
Description
With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart...
In Interlibrary Loan
Didn't find what you need? Items not owned by Pueblo Library can be requested from other Interlibrary Loan libraries to be delivered to your local library for pickup.
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request