課程資料
- 可獲發
- *證書的發放與分配,依課程提供者的政策及安排而定。
課程簡介
Beginners Course to learn how to use Microsoft Excel, Master the Fundamentals of Microsoft Excel as a Beginner.
Excel expert Michael Bouwer helps new users of Microsoft Excel from the most fundamental and basic principles all the way to creating their own worksheets with functioning formulas and references.
This course guides you through some of the most common knowledges, that is not so common to all.
No prior knowledge of Excel required.
Michael have experienced thousands of users that simply don't know about the essential principles covered in this course, and so miss out on a multitude of Excel functionality.
If you want to become proficient or even just a great user of Microsoft Excel, then this course comes highly recommended.
Topics include:
Understanding the Excel Layout and Screen with Menus
Simple Data Entry Techniques
Creating Formulas and Common Functions
Understanding Formatting Tools and Worksheet Manipulation
Printing
Creating and Editing Charts and its elements
Adjusting your View as well as working with Multiple Worksheets and Workbooks
Some Advanced Functions, such as IF, VLOOKUP and COUNTIF Family of Functions
How to Protect your Worksheets and Workbooks
Features to do Proper Data Management
Tools for Data Analysis
Entire Module Dedicated to PivotTables, from Creation to Manipulation to Charting
An Introduction to Macros
All the Resource Files are provided which can be downloaded for free.
課程章節
- 16 個章節
- 69 堂課
- 第 1 章 What is Excel Used For
- 第 2 章 Basic Navigation around Excel Interface
- 第 3 章 Data Entry into Excel
- 第 4 章 Creating and Mastering Formulas and Functions
- 第 5 章 Formatting Features in Excel
- 第 6 章 Adjusting The Worksheet Layout to Suit You
- 第 7 章 Printing Basics in Excel
- 第 8 章 Charting Basics in Excel
- 第 9 章 Adjusting Worksheet Views in Excel
- 第 10 章 Working with Multiple Worksheets and Workbooks
- 第 11 章 Advanced Formulas (IF, VLOOKUP & COUNTIF family)
- 第 12 章 Protection and Passwords
- 第 13 章 Basic Data Management Features
- 第 14 章 Basic Data Analysis Tools
- 第 15 章 PivotTables Basics in Excel
- 第 16 章 Basic Introduction to Macros
課程內容
- How to Use Microsoft Excel as a Complete Beginner
- From Basic Navigation to Entering Data and Creating your Own Formulas and Functions
- To Understanding Formatting, and Adjusting Your Layouts and Views and Printing
- Learning How To Create Charts and Tables and Other Management Features
- Protecting Your Precious Files and Worksheets and Analysis Tools like Add-Ins
- All the Way to Everything about PivotTables and even an Introduction to Macros
此課程所涵蓋的技能
評價
-
DDavid Ault
Yes, I wasn't aware there were so many preset templates for Excel
-
SSarah Campbell
Yes, looking froward to learning all about Excel
-
NNiamh King
Great course
-
AAlix Dykman
Yes it was a good match.