|
Books > Computing & IT > Computer software packages > Spreadsheet software
I wrote this book in a few hours with the intention of being a
quick starter guide and a general introduction to PowerPoint. This
book has been used as a study guide for a class I teach at Forest
Academy called "PowerPoint Essentials." It follows my first book on
an element of Microsoft Office called "Excel Essentials" You will
have enough information that serves as a strong platform to learn
more. To use the expression, you will learn in a few short pages
enough to be "dangerous." This book is a simple direct to the point
presentation of how to use PowerPoint to make impressive looking
presentation with animation and narration. You'll get to know all
the fancy techniques in a few pages. With what you learn in this
book, you will have the ability to intuitively learn other topics
on your own that is not covered in this book. You'll have enough
understanding to become a PowerPoint expert. David K. Ewen, M.Ed.
Forest Academy April 2014
The complete change in the Excel 2007 interface has jolted many
Excel users out of their comfort zone as they struggle to locate
and familiarize themselves with the regular functions they have
been using for many years. Most Excel users tend to stick to the
regular functions that they have been using to get their job done
and may not be aware of shorter and more productive methods of
working with the new version of Excel. As such, more than 30 Tips
and Tricks have been specially identified and compiled in this
book. Each of the Tips and Tricks has the potential of saving you
hours of cleaning up the data manually, drastically changing the
way you use Excel. Some of the Tips and Tricks found in this book
are:
- Customize The Quick Access Toolbar (QAT)
- Double Click On The Ribbon To Hide It
- Quick Access To Frequently Used Files
- Tracking Real-Time Changes With Excel Camera
- Jump Instantly To The End Of Your Database
- Searching And Entering Formula With Autocomplete
- Create Attention-Getting Comments
Microsoft Excel is a powerful tool that can transform the way you
use data. This book explains in comprehensive and user-friendly
detail how to manage, make sense of, explore and share data, giving
scientists at all levels the skills they need to maximize the
usefulness of their data. Readers will learn how to use Excel to: *
Build a dataset - how to handle variables and notes, rearrangements
and edits to data. * Check datasets - dealing with typographic
errors, data validation and numerical errors. * Make sense of data
- including datasets for regression and correlation; summarizing
data with averages and variability; and visualizing data with
graphs, pivot charts and sparklines. * Explore regression data -
finding, highlighting and visualizing correlations. * Explore
time-related data - using pivot tables, sparklines and line plots.
* Explore association data - creating and visualizing contingency
tables. * Explore differences - pivot tables and data
visualizations including box-whisker plots. * Share data - methods
for exporting and sharing your datasets, summaries and graphs.
Alongside the text, Have a Go exercises, Tips and Notes give
readers practical experience and highlight important points, and
helpful self-assessment exercises and summary tables can be found
at the end of each chapter. Supplementary material can also be
downloaded on the companion website. Managing Data Using Excel is
an essential book for all scientists and students who use data and
are seeking to manage data more effectively. It is aimed at
scientists at all levels but it is especially useful for
university-level research, from undergraduates to postdoctoral
researchers.
Designed to increase the productivity of MS Excel users, Excel
2010: The Basics course will give you a firm grasp of the
essentials. Productivity in Automation workbooks are designed to
help you "learn by doing." After completing the lessons you can
continue to use this book as a reference. In this course you will
learn: Creating and Saving Workbooks Create and Edit Formulas Copy
and move data and formulas Format and Print Workbooks Create and
Enhance Charts
Revolutionize your data and shine your light at work or with
clients. Discover, visualize and share your data like never before.
Easy Steps to Excel 2010 gives you step by step simplistic approach
to learning. Easily reformat or rearrange your data to gain
accurate and intuitive understanding. Learn how to format cells and
cell content, work with formulas, build tables and charts, perform
complex analyses quickly, discover and compare different ways to
represent your data visually, share workbooks through collaboration
and save and send in various file formats. Make it personal and use
Excel 2010 to help you with home budgets, to-do lists, finances,
retirement savings, college fund savings for kids and utilization
of other power packed built-in templates. Take control of your
destiny and propel your excel skills to the next level. This book
is packed with lots of screenshots and tips to meet you at the
level of your experience. You can learn unlimited possibilities
with Easy Steps to Excel 2010.
|
|