Textbook
Microsoft Office Excel 2019 Part 1
Course Description
Use Excel to help organize, analyze and share your data at work or home. Learn to navigate Excel, create a basic worksheet, perform calculations, modify and format a worksheet, manage and print workbooks, and customize the Excel environment. This course is intended for individuals who have little to no experience with Microsoft Excel. To successfully complete this course, you must attend both sessions.
Learning Outcomes
Below are the topics we will cover in this class. There will be a mix of lecture and hands-on exercises.
- Learning terms and concepts.
- Learning UI and navigation.
- Basic formulas
- Simple functions
- Learning references, and what they are.
- Relative references
- Absolute references
- Mixed references
- Worksheet References
- Some number formats
- Currency
- Date
- Text
- Cell styles & Themes
- Printing
- Worksheets
- Inserting
- Deleting
- Renaming
- Moving
- Copying
- Hiding
- Unhiding
- Workbook properties
- Title
- Author
- Subject
- Tags