Microsoft - Work Smarter with Microsoft Excel
5.0 /5- Offered byCoursera
Work Smarter with Microsoft Excel at Coursera Overview
Duration | 20 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Work Smarter with Microsoft Excel at Coursera Highlights
- Flexible deadlines in accordance to your schedule.
- Earn a Certificate upon completion
Work Smarter with Microsoft Excel at Coursera Course details
- This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.
- Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you.
- This course will introduce you to Microsoft's powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data. If you are familiar with Excel's basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop basic Excel skills.
- In this course, you will become comfortable with creating a new spreadsheet, working with basic formulas and functions, making your spreadsheets look professional and presentable, and saving and printing a spreadsheet.
- By the end of this course, you will be comfortable creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.
- This course will help you prepare for Exam MO-200: Microsoft Excel (Excel and Excel 2019). You will get opportunities to demonstrate the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually
Work Smarter with Microsoft Excel at Coursera Curriculum
Getting started with Excel
Introduction to Work Smarter with Excel
Navigating this course
Get to know Excel
Create a workbook
Save and share a workbook
Get help in Microsoft Excel
Work with data
Work with rows and columns
Format text
Format cells
Align cell content
Search for and replace data
Spell check a worksheet
Define the basic page layout for a workbook
Refine the page layout and apply print options
Module summary - Getting started with Excel
Course syllabus - Work Smarter with Excel
How to be successful in this course
How to use the video settings on Coursera
Exercise: Creating workbooks
Exercise: Getting help in Excel
Additional resources
Exercise: Working with data
Exercise: Working with rows and columns
Exercise: Formatting text
Regional number formatting
Exercise: Formatting cells
Exercise: Aligning cell content
Exercise: Searching for and replacing data
Exercise: Spell checking a worksheet
Exercise: Previewing a workbook before printing
Exercise: Refining the page layout and applying print options
Knowledge check: Get started with Excel
Knowledge check: Get started with data
Knowledge check: Modifying a worksheet
Knowledge check: Printing workbook content
Module graded quiz: Getting started with Excel
Working with functions
Module introduction - Working with functions
A closer look at formulas and functions
Using formulas and functions
Sort and filter Data
Add range names
Use range names in formulas
Function categories and syntax
Using specialized functions
Manage text with functions
Trim and case text functions
Join and transpose text functions
Logical functions and operators
Using logical functions with conditions
Module summary - Working with functions
Exercise: Getting started with formulas
Exercise: Using formulas and functions
Exercise: Sort and filter data
Exercise: Using range names in formulas
Exercise: Using specialized functions
Additional resources
Exercise: Analyzing data using text functions
Additional resources
Exercise: Analyzing data using logical functions
Additional resources
Knowledge check: Working with formulas and functions
Knowledge check: Sorting and filtering data
Knowledge check: Apply range in Excel
Knowledge check: Specialized functions
Knowledge check: Text functions
Knowledge check: Logical functions
Module graded quiz: Working with functions
Organizing and visualizing data
Module introduction - Organizing and visualizing data
Create tables
Format tables
Modifying tables
Name tables and use structured references
Database functions and convert to range
Format worksheet tabs
Manage worksheets
Manage the view of worksheets and workbooks
Create charts
Modify and format charts
Advanced chart elements
Create a PivotTable
Summarize data in a PivotTable
Filtering data using slicers
Module summary - Organizing and visualizing data
Exercise: Creating and modifying a table
Exercise: Modifying tables
Subtotal function arguments
List of database functions
Exercise: Using table references
Exercise: Formatting worksheet tabs
Exercise: Managing worksheets
Exercise: Managing the view of worksheets and workbooks
Exercise: Creating charts
Exercise: Modifying and formatting charts
Exercise: Create a trendline
Summary of DAX categories of functions
Exercise: Creating PivotTables
Exercise: Filtering data using slicers
Knowledge check: Create and modify tables
Knowledge check: Table references
Knowledge check: Managing large workbooks
Knowledge check: Visualizing data with basic charts
Knowledge check: Analyzing data
Module graded quiz: Organizing and visualizing data
Advanced Excel features
Customize formula options
Customize proofing and save options
Customize the ribbon and Quick Access Toolbar
Conditional formatting
Conditional formatting rules
Customize workbooks
Manage workbook properties
Export data
Use data sources
Module summary - Advanced Excel features
Course wrap up - Work Smarter with Microsoft Excel
Exercise: Customizing formula options
Customizing proofing and save options
Exercise: Customizing the Quick Access Toolbar
Exercise: Apply conditional formatting
Exercise: Customizing workbooks
Exercise: Managing workbook properties
Exercise: Exporting worksheet data
Exercise: Using data sources
Next steps
Knowledge check: Customize the Excel environment
Knowledge check: Conditional formatting
Knowledge check: Enhancing and managing workbooks
Knowledge check: Exporting and sourcing data
Module graded quiz: Advanced Excel features
Honors: Hands-on practice using Microsoft Excel
Project introduction
How to submit assignment link
Work Smarter with Microsoft Excel at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Work Smarter with Microsoft Excel at Coursera Students Ratings & Reviews
4 Ratings- 4-54
Student Forum
Anything you would want to ask experts?