Microsoft Excel Training
Assignments designed for skill retention
Buy any 2 Office books and get 1 free
(email us which title is your free software book)
MS Excel Training Manuals from Get To The Point
The MS Excel training manuals have been produced to meet (and exceed) both technical mathematics and business mathematics software course requirements and thus cover curriculum topics necessary at a college level. Our Microsoft manuals result in the added bonus of not only learning about how to use the software, but, to also learn about the technical mathematics and business components inherent within the software materials.
Our hands-on, mathematical (algebra, trigonometry, technological, or business), student-based MS Excel training manuals contain a highly visual step-by-step approach to creating applied technical spreadsheet examples. It assumes that the student has no experience or background with MS Excel software or spreadsheets. It is a very user-friendly manual and is meant for self paced learning with little or no input from an instructor.
The Microsoft Excel training proceeds to take the student through mathematical operators (add, subtract, multiply, divide, exponentiation, brackets), formatting of numbers, the spreadsheet, and mathematical formula building using (absolute) cell references.
- Sum, Product, Quotient, Square Root, Power, Exponent, Log, Ln, If, Nested If, VLookup, HLookup, Max, Min, Count, Average, StDev, Sin, Cos, Tan, ASin, ACos, ATan, Now, And, Or
- Future Value (FV), Present Value (PV), Payment (PMT)
- Technical charts
- Business – financial mathematics formulas and functions
This is a text designed to make the student use a spreadsheet as more than just a calculator. It is designed to encourage the student to think through a series of calculations involving formulas and functions, moving toward an applied outcome. It is very thorough. Distance delivery and e-learning classes are greatly enhanced with the use of these materials as questions are answered by working through the materials.
Our manuals have 45 assignments ranging from simple to complex, each of which takes 1.00 hours. A course could thus be easily 45+ hours, if the entire manual were used.
The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.
Top features to explore
Get started quickly
Templates do most of the set-up and design work for you, so you can focus on your data. When you open Excel 2013, you’ll see templates for budgets, calendars, forms, and reports, and more.
Instant data analysis
The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less. Preview your data with conditional
formatting, sparklines, or charts, and make your choice stick in just one click.
Fill out an entire column of data in a flash
Flash Fill is like a data assistant that finishes your work for you. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it
recognizes in your data. To see when this feature comes in handy, see Split a column of data based on what you type.
Create the right chart for your data
With Chart recommendations, Excel recommends the most suitable charts for your data. Get a quick peek to see how your data looks in the different charts, and then simply pick the one that shows the insights you want to present. Give this feature a try when you create your first chart.
Filter table data by using slicers
First introduced in Excel 2010 as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other
data tables. Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at.
One workbook, one window
In Excel 2013 each workbook has in its own window, making it easier to work on two workbooks at once. It also makes life easier when you’re working on two monitors.
New Excel functions
You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function
categories. Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services.
Save and share files online
Excel makes it easier to save your workbooks to your own online location, like your free SkyDrive or your organization’s Office 365 service. It’s also
simpler to share your worksheets with other people. No matter what device they’re using or where they are, everyone works with the latest version of a worksheet— and you can even work together in real time.
Embed worksheet data in a web page
To share part of your worksheet on the web, you can simply embed it on your web page. Other people can then work with the data in Excel Web App or open the embedded data in Excel.
Share an Excel worksheet in an online meeting
No matter where you are or what device you’re on—be it your smartphone, tablet, or PC—as long as you have Lync installed, you can connect to and share a
workbook in an online meeting.
Save to a new file format
Now you can save to and open files in the new Strict Open XML Spreadsheet (*.xlsx) file format. This file format lets you read and write ISO8601 dates to
resolve a leap year issue for the year 1900.
New charting features
Changes to the ribbon for charts
The new Recommended Charts button on the Insert tab lets you pick from a variety of charts that are right for your
data. Related types of charts like scatter and bubble charts are under one umbrella. And there’s a brand new button for combo charts—a favorite chart
you’ve asked for. When you click a chart, you’ll also see a simpler Chart Tools ribbon. With just a Design and Format tab,
it should be easier to find what you need.
Fine tune charts quickly
Three new chart buttons let you quickly pick and preview changes to chart elements (like titles or labels), the look and style of your chart, or to the data that is shown.
Richer data labels
Now you can include rich and refreshable text from data points or any other text in your data labels, enhance them with formatting and additional freeform
text, and display them in just about any shape. Data labels stay in place, even when you switch to a different type of chart. You can also connect them to their
data points with leader lines on all charts, not just pie charts.
View animation in charts
See a chart come alive when you make changes to its source data. This isn’t just fun to watch—the movement in the chart also makes the changes in your data much clearer.
Powerful data analysis
Create a PivotTable that suits your data
Picking the right fields to summarize your data in a PivotTable report can be a daunting task. Now you can get some help with that. When you create a
PivotTable, Excel recommends several ways to summarize your data, and shows you a quick preview of the field layouts so you can pick the one that gives you the insights you’re looking for.
Use one Field List to create different types of PivotTables
Create the layout of a PivotTable that uses one table or multiple tables by using one and the same Field List. Revamped to accommodate both single and
multi-table PivotTables, the Field List makes it easier to find the fields you want in your PivotTable layout, switch to the new Excel Data Model by adding more tables, and explore and navigate to all of the tables.
Use multiple tables in your data analysis
The new Excel Data Model lets you to tap into powerful analysis features that were previously only available by installing the PowerPivot add-in. In addition to creating traditional PivotTables, you can now
create PivotTables based on multiple tables in Excel. By importing different tables, and creating relationships between them, you’ll be able to analyze your data with results you aren’t able to get from traditional PivotTable data.
Connect to new data sources
To use multiple tables in the Excel Data Model, you can now connect to and import data from additional data
sources into Excel as tables or PivotTables. For example, connect to data feeds like OData, Windows Azure DataMarket, and SharePoint data feeds. You can also
connect to data sources from additional OLE DB providers.
Create relationships between tables
When you’ve got data from different data sources in multiple tables in the Excel Data Model, creating relationships between those tables makes it easy to
analyze your data without having to consolidate it into one table. By using MDX queries, you can further leverage table relationships to create meaningful
PivotTable reports.
Use a timeline to show data for different time periods
A timeline makes it simpler to compare your PivotTable or PivotChart data over different time periods. Instead of grouping by dates, you can now simply
filter dates interactively or move through data in sequential time periods, like rolling month-to-month performance, in just one click.
Use Drill Down, Drill Up, and Cross Drill to get to different levels of detail
Drilling down to different levels of detail in a complex set of data is not an easy task. Custom sets are helpful,
but finding them among a large number of fields in the Field List takes time. In the new Excel Data Model, you’ll be able to navigate to different
levels more easily. Use Drill Down into a PivotTable or PivotChart hierarchy to see granular levels of detail, and Drill
Up to go to a higher level for “big picture” insights.
Use OLAP calculated members and measures
Tap into the power of self-service Business Intelligence (BI) and add your own Multidimensional Expression (MDX)-based calculations in PivotTable data that is connected to an
Online Analytical Processing (OLAP) cube. No need to reach for the Excel Object Model—now you can create and manage calculated members and measures right in Excel.
Create a standalone PivotChart
A PivotChart no longer has to be associated with a PivotTable. A standalone or de-coupled PivotChart lets you experience new ways to navigate to data
details by using the new Drill Down, and Drill Up features. It’s also much easier to copy or move a de-coupled PivotChart.
Power View
If you’re using Office Professional Plus, you can take advantage of Power View. Simply click the Power View button on the ribbon to discover insights
about your data with highly interactive, powerful data exploration, visualization, and presentation features that are easy to apply. Power View lets
you create and interact with charts, slicers, and other data visualizations in a single sheet.
New and improved add-ins and converters
PowerPivot for Excel add-in
If you’re using Office Professional Plus, the PowerPivot add-in comes installed with Excel. The PowerPivot data analysis engine is now built into
Excel so that you can build simple data models directly in Excel. The PowerPivot add-in provides an environment for creating more sophisticated models. Use it to
filter out data when importing it, define your own hierarchies, calculation fields, and key performance indicators (KPIs), and use the Data Analysis
Expressions (DAX) language to create advanced formulas. Learn more about the PowerPivot in Excel 2013 add-in.
Inquire add-in
If you’re using Office Professional Plus, the Inquire add-in comes installed with Excel. It helps you analyze and review your workbooks to understand their
design, function, and data dependencies, and to uncover a variety of problems including formula errors or inconsistencies, hidden information, broken links
and others. From Inquire, you can start a new Microsoft Office tool, called Spreadsheet Compare, to compare two versions of a workbook, clearly indicating
where changes have occurred. During an audit, you have full visibility of the changes in your workbooks.  Microsoft Excel Training Manuals Available: | | MS Excel (Office 365) Training Manual | 2013 | $29.95 | |  | | MS Excel Biology Training Manual | 2007 | $29.95 | | | | 2003 | $29.95 | | | | 2002 (XP) | $29.95 | | | | 2000 | $29.95 | |  | | MS Excel Biology Training Manual (eBook) | 2002 (XP) | $29.95 | |  | | MS Excel Business Training Manual | 2010 | $29.95 | | | | 2007 | $29.95 | | | | 2003 | $29.95 | | | | 2002 (XP) | $29.95 | | | | 2000 | $29.95 | |  | | MS Excel Chemistry Training Manual | 2007 | $29.95 | | | | 2003 | $29.95 | |  | | MS Excel Chemistry Training Manual (eBook) | 2003 | $29.95 | |  | | MS Excel Engineering Training Manual | 2010 | $29.95 | | | | 2007 | $29.95 | | | | 2002 (XP) | $29.95 | | | | 2000 | $29.95 | | | | 1997 | $29.95 | |  | | MS Excel Engineering Training Manual (eBook) | 2003 | $29.95 | |  | | MS Excel Engineering Training Manual (French version) | 2003 | $29.95 | |  | | MS Excel Engineering Training Manual (French version) (eBook) | 2003 | $29.95 | |  | | MS Excel Forestry Training Manual | 2007 | $29.95 | | | | 2002 (XP) | $29.95 | |  | | MS Excel Forestry Training Manual (eBook) | 2002 (XP) | $29.95 | |  | | MS Excel HVAC / BEST Training Manual | 2010 | $29.95 | | | | 2007 | $29.95 | | | | 2003 | $29.95 | |  | | MS Excel HVAC / BEST Training Manual (eBook) | 2003 | $29.95 | |  | | MS Excel PetroChemical Training Manual | 2007 | $29.95 | | | | 2003 | $29.95 | |  | | MS Excel PetroChemical Training Manual (eBook) | 2003 | $29.95 | |  | | MS Excel Power Engineering Training Manual | 2010 | $29.95 | | | | 2007 | $29.95 | | | | 2003 | $29.95 | |  | | MS Excel Training Manual | 2010 | $29.95 | | | | 2007 | $29.95 | |  | | MS Excel Water and Waste Water Training Manual | 2007 | $29.95 | | | | 2003 | $29.95 | |  | | MS Excel Water and Waste Water Training Manual (eBook) | 2003 | $39.95 | |  | | Statistical Analysis Using MS Excel | 2007 | $29.95 | | | | 2003 | $29.95 | |  | |
|