|
|
Books > Computing & IT > Computer software packages > Spreadsheet software
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.
The jargon associated with Microsoft Excel's pivot tables
("n-dimensional cross tabulations") makes them look complex, but
they're really no more than an easy way to build concise, flexible
summaries of long lists of raw values. If you're working with
hundreds (or hundreds of thousands) of rows, then pivot tables are
the best way to look at the same information in different ways,
summarize data on the fly, and spot trends and relationships. This
handy guide teaches you how to use Excel's most powerful feature to
crunch large amounts of data, without having to write new formulas,
copy and paste cells, or reorganize rows and columns. You can
download the sample workbook to follow along with the author's
examples. Create pivot tables from worksheet databases. Rearrange
pivot tables by dragging, swapping, and nesting fields. Customize
pivot tables with styles, layouts, totals, and subtotals. Combine
numbers, dates, times, or text values into custom groups. Calculate
common statistics or create custom formulas. Filter data that you
don't want to see. Create and customize pivot charts. Unlink a
pivot table from its source data. Control references to pivot table
cells. Plenty of tips, tricks, and workarounds. Fully indexed and
cross-referenced.
Contents 1. Pivot Table Basics 2. Nesting Fields 3. Grouping
Items 4. Calculations and Custom Formulas 5. Filtering Data 6.
Charting Pivot Tables 7. Tricks with Pivot Tables
About the AuthorTim Hill is a data miner based in Las Vegas,
Nevada. When he's not crunching numbers, Tim plays poker, hikes
canyons, and avoids malls.
Meaningful Graphs is a concise and practical go-to guide for
creating charts in Excel (r) that clearly and accurately tell the
story in your data. It incorporates (a) explanations of the graph
design principles of the experts (Tufte, Few, Robbins, Zelazny, and
others), (b) the software steps necessary to incorporate these
principles into Excel (r) charts, and (c) chart-related discussions
of quality improvement (including Pareto charts), statistics
(including run charts and correlations), and the use of graphs in
PowerPoint (r) presentations (including chart animation). Also
included are numerous "Tips" and "In Practice" examples drawn from
over 35 years of working with data in healthcare settings. Coverage
begins with highlighting the importance of knowing the story in
your data and general principles of chart design (e.g., chartjunk,
the use of color, consideration of three dimensional charts) and
then proceeds to examine and create the five major chart types
(column, bar, line, pie, scatter). This is followed by
considerations of the pros and cons of each of the six less
frequently employed chart types. There are over 120 graphs in full
color plus tables and illustrations. Discussions of the most useful
chart types include examples with accompanying data to facilitate
practice. While illustrations are especially tailored for
healthcare professionals (physicians, nurses, patient safety,
quality improvement staff, executives, and managers) both in their
work setting and in their academic preparation, the principles of
graph design and the Excel (r) techniques required to incorporate
these principles apply equally well in other settings. The latter
include other industries and academic programs, including those
leading to degrees in business administration (MBA), public health
(MPH), and public administration (MPA). If you follow the advice in
this book, the graphs you create for reports, presentations,
posters, or publications will be more informative and more easily
und
This book will teach you on how to prepare report(s) automatically
by creating template(s) with combined formula. Then you can use the
template to generate the regular daily, weekly, bi-weekly or
monthly report as and when automatically by placing your on-going
updated data into the template with ExcelAutomateReport concept.
This solution saves you a lot of valuable time plus you don't have
to repeat the same report making process again and again. Suitable
for Sales Personnel, Marketing Personnel, Purchaser, Administrator
& Analyst.
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
|
|