BUS 115 - Business Applications: Excel in Practice
BUS 115 - Business Applications: Excel in Practice
Cover
Acknowledgements
Excel Overview
Time Saver
Auto Fill and Fill Series
Cell Referencing
Absolute and Relative Referencing
Navigation Shortcuts
Managing Cells
Sorting and Filtering
Hiding and Grouping
Paste Special
Named Ranges
Ranking
Rounding
Sum and Count
Managing Worksheets
Lookup Functions
Data Validation
IF Statements
Formula Errors
Text Functions
Text to Columns
Logic Functions 2
Date and Time
Conditional Formatting 1
Standards of Professionalism
Spreadsheet Formatting and Design
Basic Charts
Dashboards
Conditional Formatting 2
Spreadsheet Protection
Basic Pivot Tables
Advanced Pivot Tables and Slicers
Logic Functions 3
Advanced Lookup Functions
Loan Amortization Schedule
Advanced Charts
Macros 1
Macros 2
Macros 3
How to Use Search Engines
Sandbox
Author Biographies
Why the Standards of Professionalism?
Learning New Functions
Images
References
Menu
Abstracts
Download
Search
Sign in
Download
Sign-in Options
Download
PDF
Content PDFs