Macquarie University - Excel Skills for Business: Essentials
4.7 /5- Offered byCoursera
Excel Skills for Business: Essentials at Coursera Overview
Duration | 18 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
Excel Skills for Business: Essentials at Coursera Highlights
- 13% got a pay increase or promotion
- Offered by Macquarie University
- Earn a certificate upon successful completion
- 31% got a tangible career benefit from this course
Excel Skills for Business: Essentials at Coursera Course details
- Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
- Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.
- Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
- Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.
- This course is created for those learners who want to specialize in Excel for the purpose of business-related calculations. It is one of the highest-rated Excel courses on Coursera that helps learners get acquainted with using formulas and functions in Microsoft Excel. Learners will also get to solve a variety of business problems through Excel. They will get the opportunity to use productivity features for business-related calculations
- Through this beginner-level course offered by Macquarie University, learners will be able to perform basic calculations, create data visualizations through graphs and charts, and professionally format spreadsheets. Anyone regardless of having experience in Excel can opt for this course. It offers downloadable Excel workbooks along with full data sets containing applied examples and related practical challenge exercises. Learners will validate data as well as identify errors and rectify them. This 18 hours long course is great for beginners with an average rating of 4.5
Excel Skills for Business: Essentials at Coursera Curriculum
Week 1: Critical Core of Excel
Introduction
Discussion
Practice Video: Taking Charge of Excel
Practice Video: Navigating and Selecting
Practice Video: View Options
Practice Video: Data Entry, Data Types, Editing and Deleting
Practice Video: Fill Handle
Week 1 Wrap-up
Copy and Paste
Templates
Week 2: Performing calculations
Introduction
Discussion
Practice Video: Formulas
Practice Video: Formulas in Context
Practice Video: Functions I: SUM and AUTOSUM
Practice Video: Functions II: AVERAGE, MIN and MAX
Discussion: Absolute Cell References
Practice Video: Absolute Cell References
Practice Video: Calculations across sheets
Week 2 Wrap-up
Excel Options
Week 3: Formatting
Introduction
Discussion
Practice Video: Formatting
Practice Video: Borders
Practice Video: Alignment Tools
Practice Video: Format Painter
Practice Video: Number Formats
Practice Video: Styles and Themes
Week 3 Wrap-up
Graphics
Week 4: Working with Data
Introduction
Discussion
Practice Video: Managing Rows and Columns
Practice Video: Find and Replace
Practice Video: Filtering
Practice Video: Sorting
Practice Video: Conditional Formatting
Week 4 Wrap-up
Accessibility
Week 5: Printing
Introduction
Discussion
Practice Video: Print Preview
Practice Video: Orientation, Margins and Scale
Practice Video: Page Breaks
Practice Video: Print Titles
Practice Video: Headers and Footers
Week 5 Wrap-up
Save Options
Week 6: Charts
Introduction
Discussion
Practice Video: Basic Chart Types: Pie, Column and Line Charts
Practice Video: Move and Resize Charts
Practice Video: Change Chart Style & Type
Practice Video: Modify Chart Elements
Week 6 Wrap-up
Sharing Charts
Final Assessment
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?