課程資料
報名日期
全年招生
課程級別
學習模式
修業期
1 小時 38 分鐘
教學語言
英語
授課導師
David Murray
評分
1次瀏覽
課程簡介
Go beyond the Excel 2016 basics. Excel 2016 is included with Microsoft Office 365
Microsoft Excel 2016 (365) Intermediate Training Course
Excel 2016 is included with Microsoft Office 365
This course is designed for people with some limited experience of using PowerPoint 2016. It will also suit people who has studied my Excel 2016 Foundation level course.
The course starts by looking at Microsoft Excel 2016 Setup & Printing Issues
We then start looking at Excel Functions and Formulas including Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions and finally Database Functions
Next we see how to create and use Named Ranges within an Excel worksheet.
The next chapter shows you how to use Cell Formatting techniques.
Then we see the various Worksheets manipulation techniques.
Finally we look at the use of Microsoft Excel Templates and the Microsoft Excel Paste Special Options.
課程章節
- 10 個章節
- 19 堂課
- 第 1 章 Introduction
- 第 2 章 FREE 233-page e-Book, plus sample files
- 第 3 章 Excel 2016 Setup & Printing Issues
- 第 4 章 Functions and Formulars
- 第 5 章 Time and Date Functions
- 第 6 章 Math Functions
- 第 7 章 Logical Functions
- 第 8 章 SUMIF Functions
- 第 9 章 Stats Functions
- 第 10 章 Excel 2016 Text Functions
課程內容
- This is the second of three Excel 2016 training courses and builds on the materials covered in the foundation tutorials. Topics covered include Excel 2016 Functions and Formulas such as Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions & Database Functions. Plus Named Ranges, Cell Formatting, Worksheet manipulation and Excel 2016 Templates
此課程所涵蓋的技能
評價
-
WWilliam Macko
Quick overview of some intermediate excel functionality. Filling in the various fields for the functions is totally intuitive but by the end of the course, you kinda get the hang of it.
-
IIdris Thomas
I only became confused a couple of times, which is a miracle. I needed to better understand the logic behind syntax, which took a while to figure out otherwise. Also, when introducing difficult new concepts, such as NPV, perhaps an explanation of that, too. :)
-
EErick Daniel Vallejo Huerta
It's okay for an entry intermediate level of excel, you can enhance this course by following the entire book and practice any kind of example of your job/school. Thank you so much it refreshed me some functions I forgot.
-
EEdwin Sotto
It is a big help for Excel users...But maybe you should have added more examples and exercises for us to practice... Thank you...
