Excel for Business with AI: Essentials is a practical, beginner-friendly course designed to help you master Excel from the ground up — with a smart twist. You'll learn to build and format professional spreadsheets, perform essential calculations, manage and analyze data efficiently, and create eye-catching visual dashboards. Along the way, you'll also explore how AI tools can enhance your workflow, speed up your tasks, and uncover data insights. Whether you're new to Excel or looking to boost your skills, this course gives you the tools to work confidently and effectively in any business setting.
通过 Coursera Plus 提高技能,仅需 239 美元/年(原价 399 美元)。立即节省

推荐体验
推荐体验
初级
No previous experience with Excel required! This course is designed for beginners and those looking to formalize their Excel skills.
推荐体验
推荐体验
初级
No previous experience with Excel required! This course is designed for beginners and those looking to formalize their Excel skills.
您将学到什么
Develop proficiency working in Excel and using best practise to create and format spreadsheets
Build confidence creating and understanding Excel calculations for accuracy and automation
Manage data effectively, generate insights and create visual reports
Use AI to improve productivity and problem-solve in Excel
您将获得的技能
要了解的详细信息

添加到您的领英档案
43 项作业
了解顶级公司的员工如何掌握热门技能

该课程共有6个模块
In this module we will create our own spreadsheet from scratch, developing confidence working in the Excel space and discovering important efficiency tools like the fill handle and the quick access toolbar.
涵盖的内容
11个视频12篇阅读材料7个作业
11个视频•总计50分钟
- Welcome to Excel for Business with AI•2分钟
- Getting the most out of your course•1分钟
- Introduction: Taking Charge of Excel•1分钟
- Discussion Video •3分钟
- Practise Video: Taking Charge of Excel•7分钟
- Practise Video: Navigating and Selecting Data•6分钟
- Practise Video: Creating a Spreadsheet•6分钟
- Practise Video: Entering and Editing Data•6分钟
- Practise Video: Using the Fill Handle•6分钟
- Practise Video: Managing Rows and Columns •6分钟
- Practise Challenge Video•5分钟
12篇阅读材料•总计120分钟
- Course Overview & Learning Journey •10分钟
- Skills Checklist •10分钟
- Taking Charge Workbook•10分钟
- Navigating and Selecting Workbook•10分钟
- Entering and Editing Data Workbook•10分钟
- Using the Fill Handle Workbook•10分钟
- Columns and Rows Workbook•10分钟
- Columns and Rows Workbook Solution •10分钟
- Practise Challenge Workbook•10分钟
- Practise Challenge Workbook Solution •10分钟
- Assessment Workbook•10分钟
- Quick Reference Guide•10分钟
7个作业•总计84分钟
- Taking Charge of Excel•9分钟
- Navigating and Selecting •9分钟
- Creating a Spreadsheet•9分钟
- Entering and Editing Data•9分钟
- Using the Fill Handle•9分钟
- Managing Rows and Columns•9分钟
- Taking Charge of Excel Assessment•30分钟
This module is all about making your spreadsheets look professional and easy to read as we apply a range of formats: from colours and fonts, to borders, alignment options and number formats. We look at using themes to assist with branding and consistency and explore some of the many copy paste options available.
涵盖的内容
9个视频11篇阅读材料7个作业
9个视频•总计44分钟
- Introduction Video Formatting a Spreadsheet•1分钟
- Discussion Video•3分钟
- Practise Video: Fonts and Colours•5分钟
- Practise Video: Borders and Styles•7分钟
- Practise Video Alignment Tools•5分钟
- Practise Video Number Formats•6分钟
- Practise Video Copy & Paste•7分钟
- Practise Video Themes & Images•5分钟
- Practise Challenge Video•6分钟
11篇阅读材料•总计110分钟
- Formatting a Spreadsheet Skills Checklist •10分钟
- Fonts and Colours Workbook•10分钟
- Borders and Styles Workbook•10分钟
- Alignment Tools Workbook•10分钟
- Number Formats Workbook•10分钟
- Cut, Copy & Paste Workbook•10分钟
- Themes and Images Workbook•10分钟
- Practise Challenge Workbook•10分钟
- Practise Challenge Workbook Solution•10分钟
- Assessment Workbook•10分钟
- Quick Reference Guide•10分钟
7个作业•总计84分钟
- Fonts and Colours Practice•9分钟
- Borders and Styles •9分钟
- Alignment Tools•9分钟
- Number Formats•9分钟
- Cut, Copy and Paste•9分钟
- Themes & Images •9分钟
- Formatting a Spreadsheet•30分钟
This module covers the key principles in creating and copying calculations in Excel. As well as simple calculations with operators we introduce the functions: SUM, AVERAGE, MAX & MIN, look at relative and absolute cell referencing and discover how AI tools can help us generate calculations.
涵盖的内容
9个视频15篇阅读材料7个作业
9个视频•总计50分钟
- Calculations Introduction Video•1分钟
- Discussion Video•4分钟
- Practise Video: Simple Calculations•8分钟
- Practise Video: Absolute Cell References•6分钟
- Practise Video: SUM and Autosum •6分钟
- Practise Video: AVERAGE, MAX and MIN •5分钟
- Practise Video: Calculations across Sheets •5分钟
- Practise Video: Getting Help from AI •6分钟
- Practise Challenge Video•9分钟
15篇阅读材料•总计150分钟
- Skills Checklist •10分钟
- Simple Calculations Workbook•10分钟
- Absolute Cell References Workbook•10分钟
- SUM and Autosum Workbook•10分钟
- AVERAGE, MAX and MIN •10分钟
- Calculations across Sheets •10分钟
- Getting Help from AI Workbook•10分钟
- Getting Help from AI Workbook Solution•10分钟
- Practise Challenge: Calculations Workbook•10分钟
- Practise Challenge: Calculations Workbook Solution•10分钟
- Assessment Workbook•10分钟
- Assessment Workbook Solution•10分钟
- Quick Reference Guide•10分钟
- AI as your thinking Partner•10分钟
- AI Challenge: Use AI to help with Excel calculations•10分钟
7个作业•总计81分钟
- Simple Calculations Quiz•6分钟
- Practise Quiz Absolute Cell References•9分钟
- SUM and Autosum •9分钟
- AVERAGE, MAX and MIN •9分钟
- Calculations across Sheets •9分钟
- Getting Help from AI •9分钟
- Calculations Assessment •30分钟
This module is all about data. Organising it, automating the management of it, sorting and filtering and generating insights from it, with a little help from Copilot.
涵盖的内容
9个视频14篇阅读材料7个作业
9个视频•总计50分钟
- Managing Data Introduction Video•1分钟
- Discussion Video•3分钟
- Practise Video: Working with Sheets •7分钟
- Practise Video: Creating a Table •6分钟
- Practise Video: Working with Tables •6分钟
- Practise Video Sorting Data •4分钟
- Practise Video: Filters & Slicers •7分钟
- Practise Video: Data Insights with Copilot •6分钟
- Practise Challenge Video: Managing Data•8分钟
14篇阅读材料•总计140分钟
- Skills Checklist•10分钟
- Working with Sheets Workbook•10分钟
- Creating a Table Workbook•10分钟
- Working with Tables Workbook•10分钟
- Sorting Data Workbook•10分钟
- Filters & Slicers Workbook•10分钟
- Data Insights with Copilot Workbook•10分钟
- Data Insights with Copilot Workbook Solution •10分钟
- Practise Challenge Workbook•10分钟
- Practise Challenge Workbook Solution•10分钟
- Assessment Workbook•10分钟
- Quick Reference Guide•10分钟
- AI as your thinking Partner•10分钟
- AI Challenge: Use CoPilot to help generate insights•10分钟
7个作业•总计84分钟
- Practise Quiz: Working with Sheets •9分钟
- Practise Quiz: Creating a Table •9分钟
- Practise Quiz Working with Tables •9分钟
- Practise Quiz Sorting Data •9分钟
- Practise Quiz Filters & Slicers •9分钟
- Data Insights with Copilot •9分钟
- Managing Data Assessment•30分钟
This module explores options for setting up Excel sheets to sit nicely on the page when printed or converted to PDF and explores other options for sharing our Excel files and saving to cloud storage.
涵盖的内容
9个视频11篇阅读材料7个作业
9个视频•总计50分钟
- Sharing & Printing Introduction Video•1分钟
- Discussion Video•3分钟
- Practise Video: Print Preview •5分钟
- Practise Video: Page Layout Options •6分钟
- Practise Video: Headers and Footers •5分钟
- Practise Video: Print Titles & Print Areas •5分钟
- Practise Video: Page Breaks•6分钟
- Practise Video: Save & Share Options •8分钟
- Practise Challenge Video: Sharing & Printing•11分钟
11篇阅读材料•总计110分钟
- Skills Checklist•10分钟
- Print Preview Workbook•10分钟
- Page Layout Options Workbook•10分钟
- Headers and Footers Workbook•10分钟
- Print Titles & Print Areas Workbook•10分钟
- Page Breaks Workbook•10分钟
- Save & Share Options Workbook•10分钟
- Practise Challenge Workbook •10分钟
- Practise Challenge Workbook Solution•10分钟
- Assessment Workbook•10分钟
- Quick Reference Guide•10分钟
7个作业•总计90分钟
- Print Preview •15分钟
- Page Layout Options •9分钟
- Headers and Footers •9分钟
- Print Titles & Print Areas •9分钟
- Page Breaks•9分钟
- Save & Share Options •9分钟
- Sharing & Printing Assessment •30分钟
This module covers presenting data visually to help unlock insights and support data driven decision making. We look at conditional formatting, creating effective charts and how to construct a dashboard.
涵盖的内容
10个视频13篇阅读材料8个作业
10个视频•总计61分钟
- Visualising Data Introduction Video•1分钟
- Discussion Video•4分钟
- Practice Video: Quick Conditional Formats•7分钟
- Practise Video: Column & Bar Charts •7分钟
- Practise Video: Pie and Donut Charts •7分钟
- Practise Video: Line and Area Charts •8分钟
- Practise Video: Map and Treemap Charts •6分钟
- Practise Video: Simple Dashboards •9分钟
- Practise Challenge Video: Visualising Data•13分钟
- Concluding Video•1分钟
13篇阅读材料•总计130分钟
- Skills Checklist•10分钟
- Quick Conditional Formats Workbook•10分钟
- Column & Bar Charts Workbook•10分钟
- Pie and Donut Charts Workbook•10分钟
- Line and Area Charts Workbook•10分钟
- Map and Treemap Charts Workbook•10分钟
- Simple Dashboards Workbook•10分钟
- Practise Challenge Workbook •10分钟
- Practise Challenge Workbook Solution•10分钟
- Assessment Workbook•10分钟
- Quick Reference Guide•10分钟
- AI as your thinking Partner•10分钟
- AI Challenge•10分钟
8个作业•总计144分钟
- Quick Conditional Formats •9分钟
- Column & Bar Charts •9分钟
- Pie and Donut Charts •9分钟
- Line and Area Charts •9分钟
- Map and Treemap Charts •9分钟
- Simple Dashboards •9分钟
- Visualising Data Assessment •30分钟
- Final Assessment •60分钟
位教师

提供方

提供方

Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
从 Business Essentials 浏览更多内容
状态:免费试用免费试用MMacquarie University
课程
IIllinois Tech
课程
状态:预览预览SSkillsBooster Academy
课程
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
常见问题
Excel is one of the most widely used and versatile business tools. In six action-packed modules, we cover the essential skills needed to create stunning, accurate, and automated spreadsheets in modern Excel.
Each module begins with a fireside discussion introducing important concepts, followed by six practical, hands-on videos with quick quizzes to test your understanding. At the end of each module, you'll practice all the skills covered to cement your learning before completing the assessment task.
Our course also includes a unique "AI Corner" in select weeks, providing helpful suggestions on improving your Excel productivity with artificial intelligence tools like Microsoft Copilot.
This course is ideal for:
- Business professionals aiming to improve their Excel skills - Students gearing up for careers in business or data analysis - Individuals wanting to boost their productivity with spreadsheets - Professionals looking to integrate AI tools into their Excel workflow - Complete beginners with no previous Excel experience
By the end of this course, you'll be able to:
- Create professional-looking spreadsheets from scratch
- Perform calculations and analyze data efficiently
- Build visually appealing charts and dashboards
- Leverage AI tools to enhance your Excel workflow
- Print and share your Excel documents professionally
- Apply best practices for data management and visualization
In this course, we are using Microsoft Excel $$$$ (Office 365) on a Windows PC with all options set to default. The Office 365 version of Excel is the latest version at the time of writing and developing this course. If you have a different version of Excel or you are using a Mac, some tools and buttons will look different, they may be located in a different spot, or some might be missing altogether. If there are any major differences, we usually point them out during the practice videos. If you cannot find a tool that we mention, you can always ask in the forums or search the Internet. Most of the functionality we demonstrate is also available in other spreadsheet programs, although the interface will look different. Most other spreadsheet software can import and export files in the Microsoft Excel format. If you are not sure which version of Excel you are using, check the Microsoft support pages for help.
If you cannot use Excel 2016 on a PC, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require Excel. Where possible, we have designed assessment tasks so that users of older versions of Excel (such as 2013) can still solve them.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
更多问题
提供助学金,


