Excel Fundamentals for Financial Applications
Issued by
Saint Francis University
This badge confirms proficiency in Excel for accounting and finance. Earners can navigate Excel, format data, use basic functions/formulas (SUM, AVERAGE, COUNT, etc.), create simple data visualizations, handle page layout, and remove duplicates. They can apply conditional formatting, sort/filter data, group worksheets, utilize 3-D functions, and use IF statements. This badge demonstrates a foundational grasp of Excel, optimizing workflow and data analysis in professional settings.
- Type Learning
- Level Foundational
- Time Hours
Skills
- Basic data visualization charts
- Basic formatting cell styles and conditional formatting
- Data Bars
- Duplicate removal
- Formula
- Function Library creation and cell references
- Grouping worksheets and 3-D functions
- Navigating the Excel interface with shortcut keys
- Page Layout
- Page Setup
- Sorting And Filtering Data
- Sparklines
- Tables
- Themes
- Vlookups
Earning Criteria
-
The successful completion of a 1-day Excel training workshop and the associated outside assignments. Participants will learn how to navigate the Excel interface, create and format data, use formulas and functions, and create basic data visualizations.