Phu Xuan University Library
|
PXU E-LIB
Sign in
Computer Applications for Managers

External

Computer Applications for Managers

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.

Business
Author
Lumen Learning
Publisher
LibreTexts
Source
LibreTexts
License
CC BY
Language
EN
Category
Business Administration
Read online Download PDF (open licence)
Contents· 303 sections
  1. 01: Introduction to Computers
  2. 1.01: Why It Matters- Introduction to Computers
  3. 1.02: Introduction to Computer Concepts
  4. 1.03: Hardware
  5. 1.04: Software
  6. 1.05: Security
  7. 1.06: Privacy
  8. 1.07: Introduction to Operating Systems
  9. 1.08: Identifying Your Operating System (OS)
  10. 1.09: Introduction to Navigate Programs
  11. 1.10: Managing Windows
  12. 1.11: Keyboard Shortcuts
  13. 1.12: Introduction to Finding Programs and Files
  14. 1.13: Start Menu
  15. 1.14: Creating Files and Folders
  16. 1.15: Organizing Files and Folders
  17. 1.16: Deleting Files and Folders
  18. 1.17: Introduction to File Management
  19. 1.18: Local Files
  20. 1.19: Network Files
  21. 1.20: Online Files
  22. 1.21: Introduction to Snips and Screenshots
  23. 1.22: Snips and Screenshots
  24. 1.23: Putting It Together- Intro to Computers
  25. 1.24: Assignment- Download Files
  26. 1.25: Assignment- Identify Your OS
  27. 1.26: Assignment- Empty the Recycle Bin
  28. 1.27: Discussion- Computers vs. Smartphones
  29. 02: Internet Research
  30. 2.01: Why It Matters- Internet Research
  31. 2.02: Introduction to Using and Searching the Internet
  32. 2.03: Internet Browsers
  33. 2.04: Basic Browser Tools
  34. 2.05: Introduction to Ethical Business Research
  35. 2.06: Ethical Research
  36. 2.07: Data and Customer Rights
  37. 2.08: Introduction to Basic Searches
  38. 2.09: Web Searching
  39. 2.10: Identifying Search Results
  40. 2.11: Opening Search Results
  41. 2.12: Introduction to Advanced Searches
  42. 2.13: Adjusting Search Parameters
  43. 2.14: Image Searches
  44. 2.15: Putting It Together- Internet Research
  45. 2.16: Assignment- Search the Internet
  46. 2.17: Discussion- Search Results
  47. 2.18: Discussion- Personal Data and Ethical Business Use
  48. 03: Microsoft Word Basic Skills
  49. 3.01: Why It Matters- Microsoft Word Basic Skills
  50. 3.02: Introduction to Using Word
  51. 3.03: Creating a New Blank Document and Finding Your Way Around
  52. 3.04: Saving Files
  53. 3.05: File Extensions
  54. 3.06: Introduction to Basic Text Formatting
  55. 3.07: Selecting and Moving Text
  56. 3.08: Bold Italics Underline
  57. 3.09: Fonts
  58. 3.10: Alignment Justification and Indentation
  59. 3.11: Line and Paragraph Spacing
  60. 3.12: Introduction to Workspace Tools
  61. 3.13: Spell Check and Dictionaries
  62. 3.14: Find and Replace
  63. 3.15: Introduction to Lists
  64. 3.16: Lists
  65. 3.17: Putting It Together- Microsoft Word Basic Skills
  66. 3.18: Assignment- Create Basic Document
  67. 3.19: Discussion- Paragraph Styles
  68. 04: Microsoft Word Intermediate Skills
  69. 4.01: Why It Matters- Microsoft Word Intermediate Skills
  70. 4.02: Introduction to Page Layout
  71. 4.03: Tab Stops
  72. 4.04: Columns
  73. 4.05: Headers and Footers
  74. 4.06: Introduction to Text Boxes
  75. 4.07: Text Boxes
  76. 4.08: Introduction to Tables
  77. 4.09: Creating Tables
  78. 4.10: Converting Text to a Table
  79. 4.11: Formatting Tables
  80. 4.12: Introduction to Images
  81. 4.13: Adding Images
  82. 4.14: Text Wrap
  83. 4.15: Introduction to Hyperlinks
  84. 4.16: Hyperlinks
  85. 4.17: Putting It Together- Microsoft Word Intermediate Skills
  86. 4.18: Assignment- Create Document with Tables and Images
  87. 4.19: Discussion- Cover Pages
  88. 05: Microsoft Word Advanced Skills
  89. 5.01: Why It Matters- Microsoft Word Advanced Skills
  90. 5.02: Introduction to Advanced File Creation and Text Formatting
  91. 5.03: Creating a New Document from a Template
  92. 5.04: Text Effects
  93. 5.05: Introduction to Watermarks and Icons
  94. 5.06: Watermarks
  95. 5.07: Icons in Word
  96. 5.08: Introduction to Citations
  97. 5.09: Citations
  98. 5.10: Introduction to Mail Merge
  99. 5.11: Mail Merge
  100. 5.12: Introduction to Internet and Word
  101. 5.13: Internet and Word
  102. 5.14: Putting It Together- Microsoft Word Advanced Skills
  103. 5.15: Assignment- Edit a Newsletter
  104. 5.16: Discussion- Advanced Shortcuts
  105. 06: Microsoft Excel Basic Skills
  106. 6.01: Why It Matters- Microsoft Excel Basic Skills
  107. 6.02: Introduction to Using Excel
  108. 6.03: Creating a New Workbook
  109. 6.04: Entering Data
  110. 6.05: Introduction to Basic Formatting and Layout
  111. 6.06: Table Styles
  112. 6.07: Cell Styles
  113. 6.08: Cell Format
  114. 6.09: Comma Styles
  115. 6.10: Rearranging Tables
  116. 6.11: Changing Width of Columns and Rows
  117. 6.12: Introduction to Using Multiple Worksheets
  118. 6.13: Creating a Workbook with Multiple Worksheets
  119. 6.14: Putting It Together- Microsoft Excel Basic Skills
  120. 6.15: Assignment- Organize Sales Data
  121. 6.16: Discussion- Merging and Centering Cells
  122. 07: Microsoft Excel Intermediate Skills
  123. 7.01: Why It Matters- Microsoft Excel Intermediate Skills
  124. 7.02: Introduction to Using Excel for Data Analysis
  125. 7.03: Sorting Data
  126. 7.04: Filtering Data
  127. 7.05: Functions
  128. 7.06: Introduction to Automating Data Entry
  129. 7.07: Flash Fill
  130. 7.08: SUM Data
  131. 7.09: Simple Math
  132. 7.10: Introduction to Graphics
  133. 7.11: Graphics
  134. 7.12: Modify Graphics
  135. 7.13: Format Graphics
  136. 7.14: Introduction to Charts
  137. 7.15: Charts
  138. 7.16: Clustered Column Charts
  139. 7.17: Chart Styles
  140. 7.18: Putting It Together- Microsoft Excel Intermediate Skills
  141. 7.19: Assignment- Analyze Yearly Trends
  142. 7.20: Discussion- Hard Return within a Cell
  143. 08: Microsoft Excel Advanced Skills
  144. 8.01: Why It Matters- Microsoft Excel Advanced Skills
  145. 8.02: Introduction to Sparklines
  146. 8.03: Sparklines
  147. 8.04: Introduction to More Formatting and Layout
  148. 8.05: Conditional Formatting
  149. 8.06: Viewing a Worksheet
  150. 8.07: Introduction to Pivot Tables
  151. 8.08: Pivot Tables
  152. 8.09: Introduction to Macros
  153. 8.10: Macros
  154. 8.11: Recording a Macro
  155. 8.12: Introduction to Statistical Functions and Formulas
  156. 8.13: What is a Function
  157. 8.14: Lookup Functions and Formulas
  158. 8.15: Logical Functions and Formulas
  159. 8.16: Financial Functions and Formulas
  160. 8.17: Introduction to Add-Ins
  161. 8.18: Add-Ins
  162. 8.19: Introduction to Internet and Excel
  163. 8.20: Internet and Excel
  164. 8.21: Putting It Together- Microsoft Excel Advanced Skills
  165. 8.22: Assignment- Create Macro for Car Loan Spreadsheet
  166. 8.23: Discussion- Excel Worksheet as a Webpage
  167. 09: Microsoft PowerPoint Basic Skills
  168. 9.01: Why It Matters- Microsoft PowerPoint Basic Skills
  169. 9.02: Introduction to Creating Presentations
  170. 9.03: New Presentations
  171. 9.04: Themes
  172. 9.05: Introduction to Using PowerPoint
  173. 9.06: Editing a Presentation
  174. 9.07: Organizing Slides
  175. 9.08: Views
  176. 9.09: Introduction to Objects in PowerPoint
  177. 9.10: Text Boxes
  178. 9.11: Images and Clip Art
  179. 9.12: SmartArt
  180. 9.13: Arranging Objects
  181. 9.14: Grouping Objects
  182. 9.15: Putting It Together- Microsoft PowerPoint Basic Skills
  183. 9.16: Assignment- Present Sales Information
  184. 9.17: Discussion- Infographics and Custom Shapes
  185. 10: Microsoft PowerPoint Intermediate Skills
  186. 10.01: Why It Matters- Microsoft PowerPoint Intermediate Skills
  187. 10.02: Introduction to Transition Effects
  188. 10.03: Transition Effects
  189. 10.04: Introduction to Headers and Footers
  190. 10.05: Headers and Footers
  191. 10.06: Introduction to Videos in PowerPoint
  192. 10.07: Inserting Videos in PowerPoint
  193. 10.08: Embedding Videos in PowerPoint
  194. 10.09: Uploading Videos in PowerPoint
  195. 10.10: Introduction to Lists
  196. 10.11: Creating Lists
  197. 10.12: Modifying Lists
  198. 10.13: Putting It Together- Microsoft PowerPoint Intermediate Skills
  199. 10.14: Assignment- Create a New Presentation
  200. 10.15: Discussion- Making a PowerPoint Presentation into a Video
  201. 11: Microsoft PowerPoint Advanced Skills
  202. 11.01: Why It Matters- Microsoft PowerPoint Advanced Skills
  203. 11.02: Introduction to Colors
  204. 11.03: Color Themes
  205. 11.04: Custom Color Themes
  206. 11.05: Introduction to Tables in PowerPoint
  207. 11.06: Create Tables
  208. 11.07: Format Tables
  209. 11.08: Modify Tables
  210. 11.09: Introduction to Animations in PowerPoint
  211. 11.10: Animations in PowerPoint
  212. 11.11: Introduction to Charts in PowerPoint
  213. 11.12: Create Charts
  214. 11.13: Format Charts
  215. 11.14: Modify Charts
  216. 11.15: Introduction to Customized PowerPoint Template
  217. 11.16: Customized PowerPoint Templates
  218. 11.17: Introduction to Internet and PowerPoint
  219. 11.18: Internet and PowerPoint
  220. 11.19: Putting It Together- Microsoft PowerPoint Advanced Skills
  221. 11.20: Assignment- Modify Existing PowerPoint Presentations
  222. 11.21: Discussion- Ten Extra Tips for PowerPoint
  223. 12: Microsoft Access Basic Skills
  224. 12.01: Why It Matters- Microsoft Access Basic Skills
  225. 12.02: Introduction to Creating Database Tables
  226. 12.03: Creating a Database
  227. 12.04: Naming Databases
  228. 12.05: Creating an Access Table
  229. 12.06: Introduction to Fields in Access
  230. 12.07: Field Properties
  231. 12.08: Field Names and Data Types
  232. 12.09: Introduction to Table Primary Key
  233. 12.10: Primary Key
  234. 12.11: Set a Primary Key
  235. 12.12: Introduction to Indexes
  236. 12.13: What is an Index
  237. 12.14: To Index or Not to Index
  238. 12.15: Putting It Together- Microsoft Access Basic Skills
  239. 12.16: Assignment- Create New Access Database
  240. 12.17: Discussion- Selecting Primary Key Tips
  241. 13: Microsoft Access Intermediate Skills
  242. 13.01: Why It Matters- Microsoft Access Intermediate Skills
  243. 13.02: Introduction to Table Relationships
  244. 13.03: Database Principles
  245. 13.04: Flat File vs Normalized Data
  246. 13.05: Types of Table Relationships
  247. 13.06: Introduction to Working with Tables
  248. 13.07: Datasheets
  249. 13.08: Entering Data
  250. 13.09: Changing Values
  251. 13.10: Introduction to Working with Datasheets
  252. 13.11: Adding Values and Records in Datasheets
  253. 13.12: Deleting Records in Datasheets
  254. 13.13: Introduction to Sorting and Filtering Data
  255. 13.14: Displaying Records in Datasheets
  256. 13.15: Sorting Data
  257. 13.16: Aggregating Data
  258. 13.17: Printing Records
  259. 13.18: Putting It Together- Microsoft Access Intermediate Skills
  260. 13.19: Assignment- Modify Access Database
  261. 13.20: Discussion- Moving Columns and Fields
  262. 14: Microsoft Access Advanced Skills
  263. 14.01: Why It Matters- Microsoft Access Advanced Skills
  264. 14.02: Introduction to Importing and Exporting Data
  265. 14.03: External Data
  266. 14.04: Import and Export Options
  267. 14.05: Introduction to Queries
  268. 14.06: What Are Queries
  269. 14.07: Adding Criteria to a Query
  270. 14.08: Saving Queries
  271. 14.09: Introduction to Forms and Reports
  272. 14.10: Understanding Forms
  273. 14.11: Creating Basic Forms
  274. 14.12: Form Controls and Views
  275. 14.13: Presenting Data on Reports
  276. 14.14: Introduction to Analyzing Data
  277. 14.15: Transforming Data
  278. 14.16: Understanding Calculations
  279. 14.17: Using Conditional Analysis
  280. 14.18: Using Subqueries
  281. 14.19: Understanding Domain Aggregation
  282. 14.20: Putting It Together- Microsoft Access Advanced Skills
  283. 14.21: Assignment- Create Queries for Access Database
  284. 14.22: Discussion- Ways to Manage Access Tables
  285. 15: Integration
  286. 15.01: Why It Matters- Integration
  287. 15.02: Introduction to Using Word with Excel and PowerPoint
  288. 15.03: Customized Word Templates
  289. 15.04: Excel Table in Word Document
  290. 15.05: Excel Chart in Word Document
  291. 15.06: PowerPoint in Word Document
  292. 15.07: Introduction to Using PowerPoint with Excel
  293. 15.08: Excel Table in PowerPoint
  294. 15.09: Excel Chart in PowerPoint
  295. 15.10: Introduction to Integrating Access
  296. 15.11: Access and Mail Merge
  297. 15.12: Excel Table from Access Data
  298. 15.13: Access Data from Excel Table
  299. 15.14: Putting It Together- Integration
  300. 15.15: Assignment- Create Mail Merge Letters
  301. 15.16: Discussion- Audio Integration
  302. 16: Resources- Capstone Assignment
  303. 16.01: Assignment- Create Capstone Presentation