Microsoft Excel 2013 is a software that allows you to organize, format and calculate data using a spreadsheet system.  It provides a great way to organize various projects such as lists, budgets, enrollment lists, research data, financial stats, inventories, schedules, surveys, etc.  It is an important software to understand for many BJC jobs.

We offer a full-day Foundations class called Excel 2013 Basic Skills that will get you started understanding the basics of entering, editing, calculating, formatting, and printing data using Excel.

When you understand the basics of entering data and basic formulas, then attend our 6 half-day Focus classes that focus on specific features.

To sign up for a class, simply logon to the Online Learning Center and type Excel Foundation or Excel Focus in the Search box.

 microsoft_excel_2013_logo_svg

 

CLASS NAME Description Class Manual and File –
click to download file

BILD Excel 2013 Foundation:
Basic Skills

Explore the spreadsheet environment and ways to quickly enter data in a spreadsheet, create basic formulas and functions such as SUM and COUNT, then format the data to display correctly. Practice ways to control viewing and printing large spreadsheets. Excel 2013 Basic Skills Manual

Excel 2013 Basic Class File

 

BILD Excel 2013 Express:
Basic Skills

(This class is an abbreviated version of the
Basic Skills Foundation class)

Explore the spreadsheet environment and ways to quickly enter data in a spreadsheet, create basic formulas and functions such as SUM  and AVERAGE, then format the data to display correctly. Practice ways to control viewing and printing large spreadsheets. Excel Basic Skills Express Manual

Excel-2013-Express Class File

BILD Excel 2013 Focus:
Calculating Data

Explore ways to save time by using specific formulas including
IF statements/nested IF statements, date/time formulas, conditional formulas, reference formulas, Text formulas, and how to use auditing tools and names in formulas.
 Excel 2013 Calculating Data Manual

Excel 2013 – Calculating Data Class File

BILD Excel 2013 Focus:
Summarizing Data

Summarize your data quickly by building interactive summaries using PivotTables and PivotCharts.  Learn how to correctly position your data within the Field List and explore a variety of tools to format and adjust how the summary is calculated.

 Excel 2013 Summarizing Data Manual

Excel 2013 Summarizing Data Class File

BILD Excel 2013 Focus:
Organizing Data

Learn the tricks to Sorting and Filtering Data quickly. Reorganize and summarize your data using Subtotal and how work with Outlines and Groups to adjust how the data displays. Review ways to clean up data using Text to Columns and Remove Duplicates and tag cells using Comments.  Excel 2013 Organizing Data Manual

Excel 2013 Organizing Data Class File

BILD Excel 2013 Focus:
Visualizing Data

Learn how to visually represent your data summary using Charts. Explore ways to create charts and then step through ways to adjust the chart’s elements. Learn about the many types of charts and how to choose the right one to represent your data. Create simple one cell charts called Sparklines to demonstrate trends in data.  Excel 2013 Visualizing Data Manual

Excel 2013 Visualizing Data Class File

BILD Excel 2013 Focus:
Editing and Formatting Data

Learn ways to control how you enter data using Data Validation and forms. Explore great ways to save time formatting data using Table Formats, Styles, Themes and Conditional Formatting. Then review how to quickly separate data and remove duplicate entries. Excel 2013 Edit-Format Data Manual

Excel 2013 Edit – Format Class File

BILD Excel 2013 Focus:
Linking and Protecting Data

Explore details about your files using file properties and set up password protection for workbooks, worksheets or even individual cells. Learn the language of linking and hyperlinking data and how to manage the links. Set up a Workbook to share and learn to track and control the changes being made to your files.  Excel 2013 Link – Protect Data Manual

Excel 2013 Link – Protect  Data Class File

Excel 2013 Last years Event Class File

MBMC Excel 101 for Leaders

 

Learn how to use basic Excel features such as entering data and formulas, formatting cells, creating a chart, adjusting the spreadsheet structure and printing using the KPI Dashboard. Excel 101 for Leaders manual

KPI Dashboard Example for Excel 101