Computer Applications for Managers

by Lumen Learning

Read here Read at LibreTextsPDF

This text is aimed at beginning to intermediate computer users. It teaches a range of computer skills from the basics of using Windows, to basic internet literacy, to creating projects using Microsoft Office. Assignments show step-by-step visuals to help students complete projects, and include integration across Microsoft Word, Excel, PowerPoint, and Access.

Description from LibreTexts.

Subjects
Business
Licence
CC BY 4.0, as LibreTexts states it
Who can read
Tweens profiles and older, judged from its title and subjects

Contents

LibreTexts writes equations in TeX, and here they show as TeX; the PDF has them typeset.

  1. Front Matter
  2. TitlePage
  3. InfoPage
  4. Table of Contents
  5. Licensing
  6. About This Course
  7. Course Contents at a Glance
  8. Pacing
  9. Assignments
  10. 1: Introduction to Computers
  11. 1.1: Why It Matters- Introduction to Computers
  12. 1.2: Introduction to Computer Concepts
  13. 1.3: Hardware
  14. 1.4: Software
  15. 1.5: Security
  16. 1.6: Privacy
  17. 1.7: Introduction to Operating Systems
  18. 1.8: Identifying Your Operating System (OS)
  19. 1.9: Introduction to Navigate Programs
  20. 1.10: Managing Windows
  21. 1.11: Keyboard Shortcuts
  22. 1.12: Introduction to Finding Programs and Files
  23. 1.13: Start Menu
  24. 1.14: Creating Files and Folders
  25. 1.15: Organizing Files and Folders
  26. 1.16: Deleting Files and Folders
  27. 1.17: Introduction to File Management
  28. 1.18: Local Files
  29. 1.19: Network Files
  30. 1.20: Online Files
  31. 1.21: Introduction to Snips and Screenshots
  32. 1.22: Snips and Screenshots
  33. 1.23: Putting It Together- Intro to Computers
  34. 1.24: Assignment- Download Files
  35. 1.25: Assignment- Identify Your OS
  36. 1.26: Assignment- Empty the Recycle Bin
  37. 1.27: Discussion- Computers vs. Smartphones
  38. 2: Internet Research
  39. 2.1: Why It Matters- Internet Research
  40. 2.2: Introduction to Using and Searching the Internet
  41. 2.3: Internet Browsers
  42. 2.4: Basic Browser Tools
  43. 2.5: Introduction to Ethical Business Research
  44. 2.6: Ethical Research
  45. 2.7: Data and Customer Rights
  46. 2.8: Introduction to Basic Searches
  47. 2.9: Web Searching
  48. 2.10: Identifying Search Results
  49. 2.11: Opening Search Results
  50. 2.12: Introduction to Advanced Searches
  51. 2.13: Adjusting Search Parameters
  52. 2.14: Image Searches
  53. 2.15: Putting It Together- Internet Research
  54. 2.16: Assignment- Search the Internet
  55. 2.17: Discussion- Search Results
  56. 2.18: Discussion- Personal Data and Ethical Business Use
  57. 3: Microsoft Word Basic Skills
  58. 3.1: Why It Matters- Microsoft Word Basic Skills
  59. 3.2: Introduction to Using Word
  60. 3.3: Creating a New Blank Document and Finding Your Way Around
  61. 3.4: Saving Files
  62. 3.5: File Extensions
  63. 3.6: Introduction to Basic Text Formatting
  64. 3.7: Selecting and Moving Text
  65. 3.8: Bold, Italics, Underline
  66. 3.9: Fonts
  67. 3.10: Alignment, Justification, and Indentation
  68. 3.11: Line and Paragraph Spacing
  69. 3.12: Introduction to Workspace Tools
  70. 3.13: Spell Check and Dictionaries
  71. 3.14: Find and Replace
  72. 3.15: Introduction to Lists
  73. 3.16: Lists
  74. 3.17: Putting It Together- Microsoft Word Basic Skills
  75. 3.18: Assignment- Create Basic Document
  76. 3.19: Discussion- Paragraph Styles
  77. 4: Microsoft Word Intermediate Skills
  78. 4.1: Why It Matters- Microsoft Word Intermediate Skills
  79. 4.2: Introduction to Page Layout
  80. 4.3: Tab Stops
  81. 4.4: Columns
  82. 4.5: Headers and Footers
  83. 4.6: Introduction to Text Boxes
  84. 4.7: Text Boxes
  85. 4.8: Introduction to Tables
  86. 4.9: Creating Tables
  87. 4.10: Converting Text to a Table
  88. 4.11: Formatting Tables
  89. 4.12: Introduction to Images
  90. 4.13: Adding Images
  91. 4.14: Text Wrap
  92. 4.15: Introduction to Hyperlinks
  93. 4.16: Hyperlinks
  94. 4.17: Putting It Together- Microsoft Word Intermediate Skills
  95. 4.18: Assignment- Create Document with Tables and Images
  96. 4.19: Discussion- Cover Pages
  97. 5: Microsoft Word Advanced Skills
  98. 5.1: Why It Matters- Microsoft Word Advanced Skills
  99. 5.2: Introduction to Advanced File Creation and Text Formatting
  100. 5.3: Creating a New Document from a Template
  101. 5.4: Text Effects
  102. 5.5: Introduction to Watermarks and Icons
  103. 5.6: Watermarks
  104. 5.7: Icons in Word
  105. 5.8: Introduction to Citations
  106. 5.9: Citations
  107. 5.10: Introduction to Mail Merge
  108. 5.11: Mail Merge
  109. 5.12: Introduction to Internet and Word
  110. 5.13: Internet and Word
  111. 5.14: Putting It Together- Microsoft Word Advanced Skills
  112. 5.15: Assignment- Edit a Newsletter
  113. 5.16: Discussion- Advanced Shortcuts
  114. 6: Microsoft Excel Basic Skills
  115. 6.1: Why It Matters- Microsoft Excel Basic Skills
  116. 6.2: Introduction to Using Excel
  117. 6.3: Creating a New Workbook
  118. 6.4: Entering Data
  119. 6.5: Introduction to Basic Formatting and Layout
  120. 6.6: Table Styles
  121. 6.7: Cell Styles
  122. 6.8: Cell Format
  123. 6.9: Comma Styles
  124. 6.10: Rearranging Tables
  125. 6.11: Changing Width of Columns and Rows
  126. 6.12: Introduction to Using Multiple Worksheets
  127. 6.13: Creating a Workbook with Multiple Worksheets
  128. 6.14: Putting It Together- Microsoft Excel Basic Skills
  129. 6.15: Assignment- Organize Sales Data
  130. 6.16: Discussion- Merging and Centering Cells
  131. 7: Microsoft Excel Intermediate Skills
  132. 7.1: Why It Matters- Microsoft Excel Intermediate Skills
  133. 7.2: Introduction to Using Excel for Data Analysis
  134. 7.3: Sorting Data
  135. 7.4: Filtering Data
  136. 7.5: Functions
  137. 7.6: Introduction to Automating Data Entry
  138. 7.7: Flash Fill
  139. 7.8: SUM Data
  140. 7.9: Simple Math
  141. 7.10: Introduction to Graphics
  142. 7.11: Graphics
  143. 7.12: Modify Graphics
  144. 7.13: Format Graphics
  145. 7.14: Introduction to Charts
  146. 7.15: Charts
  147. 7.16: Clustered Column Charts
  148. 7.17: Chart Styles
  149. 7.18: Putting It Together- Microsoft Excel Intermediate Skills
  150. 7.19: Assignment- Analyze Yearly Trends
  151. 7.20: Discussion- Hard Return within a Cell
  152. 8: Microsoft Excel Advanced Skills
  153. 8.1: Why It Matters- Microsoft Excel Advanced Skills
  154. 8.2: Introduction to Sparklines
  155. 8.3: Sparklines
  156. 8.4: Introduction to More Formatting and Layout
  157. 8.5: Conditional Formatting
  158. 8.6: Viewing a Worksheet
  159. 8.7: Introduction to Pivot Tables
  160. 8.8: Pivot Tables
  161. 8.9: Introduction to Macros
  162. 8.10: Macros
  163. 8.11: Recording a Macro
  164. 8.12: Introduction to Statistical Functions and Formulas
  165. 8.13: What is a Function?
  166. 8.14: Lookup Functions and Formulas
  167. 8.15: Logical Functions and Formulas
  168. 8.16: Financial Functions and Formulas
  169. 8.17: Introduction to Add-Ins
  170. 8.18: Add-Ins
  171. 8.19: Introduction to Internet and Excel
  172. 8.20: Internet and Excel
  173. 8.21: Putting It Together- Microsoft Excel Advanced Skills
  174. 8.22: Assignment- Create Macro for Car Loan Spreadsheet
  175. 8.23: Discussion- Excel Worksheet as a Webpage
  176. 9: Microsoft PowerPoint Basic Skills
  177. 9.1: Why It Matters- Microsoft PowerPoint Basic Skills
  178. 9.2: Introduction to Creating Presentations
  179. 9.3: New Presentations
  180. 9.4: Themes
  181. 9.5: Introduction to Using PowerPoint
  182. 9.6: Editing a Presentation
  183. 9.7: Organizing Slides
  184. 9.8: Views
  185. 9.9: Introduction to Objects in PowerPoint
  186. 9.10: Text Boxes
  187. 9.11: Images and Clip Art
  188. 9.12: SmartArt
  189. 9.13: Arranging Objects
  190. 9.14: Grouping Objects
  191. 9.15: Putting It Together- Microsoft PowerPoint Basic Skills
  192. 9.16: Assignment- Present Sales Information
  193. 9.17: Discussion- Infographics and Custom Shapes
  194. 10: Microsoft PowerPoint Intermediate Skills
  195. 10.1: Why It Matters- Microsoft PowerPoint Intermediate Skills
  196. 10.2: Introduction to Transition Effects
  197. 10.3: Transition Effects
  198. 10.4: Introduction to Headers and Footers
  199. 10.5: Headers and Footers
  200. 10.6: Introduction to Videos in PowerPoint
  201. 10.7: Inserting Videos in PowerPoint
  202. 10.8: Embedding Videos in PowerPoint
  203. 10.9: Uploading Videos in PowerPoint
  204. 10.10: Introduction to Lists
  205. 10.11: Creating Lists
  206. 10.12: Modifying Lists
  207. 10.13: Putting It Together- Microsoft PowerPoint Intermediate Skills
  208. 10.14: Assignment- Create a New Presentation
  209. 10.15: Discussion- Making a PowerPoint Presentation into a Video
  210. 11: Microsoft PowerPoint Advanced Skills
  211. 11.1: Why It Matters- Microsoft PowerPoint Advanced Skills
  212. 11.2: Introduction to Colors
  213. 11.3: Color Themes
  214. 11.4: Custom Color Themes
  215. 11.5: Introduction to Tables in PowerPoint
  216. 11.6: Create Tables
  217. 11.7: Format Tables
  218. 11.8: Modify Tables
  219. 11.9: Introduction to Animations in PowerPoint
  220. 11.10: Animations in PowerPoint
  221. 11.11: Introduction to Charts in PowerPoint
  222. 11.12: Create Charts
  223. 11.13: Format Charts
  224. 11.14: Modify Charts
  225. 11.15: Introduction to Customized PowerPoint Template
  226. 11.16: Customized PowerPoint Templates
  227. 11.17: Introduction to Internet and PowerPoint
  228. 11.18: Internet and PowerPoint
  229. 11.19: Putting It Together- Microsoft PowerPoint Advanced Skills
  230. 11.20: Assignment- Modify Existing PowerPoint Presentations
  231. 11.21: Discussion- Ten Extra Tips for PowerPoint
  232. 12: Microsoft Access Basic Skills
  233. 12.1: Why It Matters- Microsoft Access Basic Skills
  234. 12.2: Introduction to Creating Database Tables
  235. 12.3: Creating a Database
  236. 12.4: Naming Databases
  237. 12.5: Creating an Access Table
  238. 12.6: Introduction to Fields in Access
  239. 12.7: Field Properties
  240. 12.8: Field Names and Data Types
  241. 12.9: Introduction to Table Primary Key
  242. 12.10: Primary Key
  243. 12.11: Set a Primary Key
  244. 12.12: Introduction to Indexes
  245. 12.13: What is an Index?
  246. 12.14: To Index or Not to Index?
  247. 12.15: Putting It Together- Microsoft Access Basic Skills
  248. 12.16: Assignment- Create New Access Database
  249. 12.17: Discussion- Selecting Primary Key Tips
  250. 13: Microsoft Access Intermediate Skills
  251. 13.1: Why It Matters- Microsoft Access Intermediate Skills
  252. 13.2: Introduction to Table Relationships
  253. 13.3: Database Principles
  254. 13.4: Flat File vs Normalized Data
  255. 13.5: Types of Table Relationships
  256. 13.6: Introduction to Working with Tables
  257. 13.7: Datasheets
  258. 13.8: Entering Data
  259. 13.9: Changing Values
  260. 13.10: Introduction to Working with Datasheets
  261. 13.11: Adding Values and Records in Datasheets
  262. 13.12: Deleting Records in Datasheets
  263. 13.13: Introduction to Sorting and Filtering Data
  264. 13.14: Displaying Records in Datasheets
  265. 13.15: Sorting Data
  266. 13.16: Aggregating Data
  267. 13.17: Printing Records
  268. 13.18: Putting It Together- Microsoft Access Intermediate Skills
  269. 13.19: Assignment- Modify Access Database
  270. 13.20: Discussion- Moving Columns and Fields
  271. 14: Microsoft Access Advanced Skills
  272. 14.1: Why It Matters- Microsoft Access Advanced Skills
  273. 14.2: Introduction to Importing and Exporting Data
  274. 14.3: External Data
  275. 14.4: Import and Export Options
  276. 14.5: Introduction to Queries
  277. 14.6: What Are Queries?
  278. 14.7: Adding Criteria to a Query
  279. 14.8: Saving Queries
  280. 14.9: Introduction to Forms and Reports
  281. 14.10: Understanding Forms
  282. 14.11: Creating Basic Forms
  283. 14.12: Form Controls and Views
  284. 14.13: Presenting Data on Reports
  285. 14.14: Introduction to Analyzing Data
  286. 14.15: Transforming Data
  287. 14.16: Understanding Calculations
  288. 14.17: Using Conditional Analysis
  289. 14.18: Using Subqueries
  290. 14.19: Understanding Domain Aggregation
  291. 14.20: Putting It Together- Microsoft Access Advanced Skills
  292. 14.21: Assignment- Create Queries for Access Database
  293. 14.22: Discussion- Ways to Manage Access Tables
  294. 15: Integration
  295. 15.1: Why It Matters- Integration
  296. 15.2: Introduction to Using Word with Excel and PowerPoint
  297. 15.3: Customized Word Templates
  298. 15.4: Excel Table in Word Document
  299. 15.5: Excel Chart in Word Document
  300. 15.6: PowerPoint in Word Document
  301. 15.7: Introduction to Using PowerPoint with Excel
  302. 15.8: Excel Table in PowerPoint
  303. 15.9: Excel Chart in PowerPoint
  304. 15.10: Introduction to Integrating Access
  305. 15.11: Access and Mail Merge
  306. 15.12: Excel Table from Access Data
  307. 15.13: Access Data from Excel Table
  308. 15.14: Putting It Together- Integration
  309. 15.15: Assignment- Create Mail Merge Letters
  310. 15.16: Discussion- Audio Integration
  311. 16: Resources- Capstone Assignment
  312. 16.1: Assignment- Create Capstone Presentation
  313. Back Matter
  314. Index
  315. Glossary
  316. Glossary
  317. Detailed Licensing