Excel Tutorial: Excel中2013初级 - 中级 | Skillfeed
Skillfeed will be shutdown on September 30. Please view additional details here.

Excel中2013初级 - 中级

  • Students: 43
  • 评级:
    (1 评级)
 

影片 时间
第 1 章:介绍
View-play Course overview 5 分钟
View-play Going over the Ribbons and their Functions 14 分钟
View-play Going over the Ribbons and their Functions 8 分钟
第 2 章:Excel工作簿和工作表
View-play How to plug in a formula within an excel spreadsheet 7 分钟
View-play How to add and remove worksheets, and How to rename, copy, and mo 10 分钟
View-play How to navigate an excel workbook 5 分钟
第 3 章:如何在单元格中输入和编辑数据
View-play How to enter text, numbers, and dates in an excel workbook. How t 9 分钟
View-play How to edit the contents of a cell, and also how to undo and redo 7 分钟
View-play How to cut, copy, and paste in a workbook, and How how to drag an 9 分钟
View-play How to use the fill handle of Microsoft excel 8 分钟
View-play How to insert, and delete cells, columns, and rows. 6 分钟
View-play How to change column width and row height 4 分钟
View-play How to hide and unhide columns and rows 6 分钟
第 4 章:基本的数学运算和函数
View-play Basic Math Formulas 5 分钟
View-play Order of Operations with BODMAS and Intro to Basic Formulas 9 分钟
View-play Coying and Pasting Formulas and Functions 6 分钟
View-play Displaying Formulas on a Worksheet 5 分钟
第 5 章:工作表格式和编辑
View-play Selecting Cells For Formatting and Modifying Typeface Font, Size, 9 分钟
View-play Merging And Wrapping Cell Contents 7 分钟
View-play Using Number Formats 3 分钟
View-play Cell Content Alignment, Orientation, Adding And Removing Borders 7 分钟
View-play Applying a date 7 分钟
View-play Finding And Replacing Formats 5 分钟
View-play Clearing Cell Contents Vs Clearing Cell Formatting 5 分钟
第 6 章:管理工作簿和工作表
View-play Worksheet Navigation And Coloured Worksheet Tabs and Moving Or Co 7 分钟
View-play Viewing And Scrolling Multiple Workbooks At The Same Time and Hid 6 分钟
View-play Modifying More Than One Worksheet At A Time 3 分钟
第 7 章:设置页面格式进行打印
View-play-active Using Print Titles And Print Areas 7 分钟
View-play Paper Size, Orientation, Margins, And Scaling Options 7 分钟
View-play Creating Headers and Footers 7 分钟
View-play Using The Page Break And The Page Layout Views 4 分钟
View-play Printing A Range Of Cells and Running the Spell Checker 6 分钟
View-play Controlling Most Print Settings In One Place 3 分钟
第 8 章:公式和函数
View-play The Sum Function 8 分钟
View-play Copying Formulas And Functions 6 分钟
View-play Useful Count Functions 4 分钟
View-play Absolute Referencing Explained 8 分钟
View-play Formulas Across Worksheets 8 分钟
View-play 3D Referencing 7 分钟
View-play Making Use Of Named Cells And Ranges 9 分钟
第 9 章:更复杂的格式
View-play Creating Your Own Autofill List 9 分钟
View-play Converting Data To A Table For Formatting 5 分钟
View-play Enhancing Worksheets Using Themes and Adding, Editing, And Deleti 6 分钟
第 10 章:保护和安全
View-play Activating And Deactivating Worksheet Protection 5 分钟
View-play Protecting Part Of A Worksheet To Aid Data Entry 5 分钟
View-play Password Protecting The Whole Workbook 3 分钟
View-play Ready to use templates 3 分钟
第 11 章:图形化的人物和物体
View-play Obtaining And Inserting Online Images 4 分钟
View-play Using Graphical Objects And Mathematical Formulas 5 分钟
View-play Inserting Shapes And Screenshots 6 分钟
View-play Formatting Graphical Objects 6 分钟
View-play The Stacking Order 7 分钟
View-play Grouping Multiple Objects Together 7 分钟
View-play Using Graphical Objects And Mathematical Formulas 5 分钟
第 12 章:图表以及如何使用它们
View-play The New Recommended Charts Option 4 分钟
View-play Create A Chart Using The Long Or The Short Method and Formatting 9 分钟
View-play Modifying The Chart Type and Formatting Chart Elements 8 分钟
View-play Adding A Trendline 3 分钟
View-play Mini Graphs Sparklines 10 分钟
View-play Mini Graphs Sparklines 7 分钟
第 13 章:Excel和如何使用它作为一个数据库
View-play Fixing On Screen Rows And Columns 7 分钟
View-play Fixing Print Rows And Columns and Sorting Data In Excel 10 分钟
View-play Filtering Data To Reduce Dataset Size 7 分钟
View-play Removing Duplicate Entries In The Data and Adding Subtotals To A 6 分钟
View-play Using Text To Columns Effectively 6 分钟
View-play Linking To Data On A Webpage 4 分钟
第 14 章:先进的,有点复杂的公式
View-play Using An If Formula 5 分钟
View-play Use Of The If Function To Hide Excel Error Messages 6 分钟
View-play Datedif A Useful But Hidden Formula 5 分钟
View-play Text Manipulation Using Functions 6 分钟
View-play Use The Text Function To Format Numbers and Date Manipulation Fun 8 分钟
View-play Introducing Sumif, Countif, And Averageif 6 分钟
View-play Use Of Rank To Calculate Placings 5 分钟
View-play Flash Fill 3 分钟
第 15 章:更多的格式
View-play Altering Cell Appearance Based On The Cell Value 6 分钟
View-play Displaying Data Bars, Color Scales, Or Icon Sets and Using Top 7 分钟
View-play Creating A Formatting Rule From Scratch 4 分钟
View-play Managing The Conditional Formatting Rules 4 分钟
概述

The course teaches Microsoft Excel 2013 from the very basics into an intermediate level. As a result the user reaches the level of an intermediate level user. Topics covered such formatting, functions, formulas and advanced tasks with the worksheets are delivered in various sections for detailed description and peculiarities of their usage. By the end of the course you will turn into an Intermediate Microsoft Excel user, capable of using the software in everyday personal or business tasks.

课程总数: 78
时间: 7 小时31 分钟
主题: 业务
语言: 英文
软件: Excel 2013
水平: 初级
关键词:
已发布: 08/19/14
项目文件:
关于讲师
Large_6248774_6562_3

Optimum is a leading educational center specialized in the IT field. We have over 3 years of experience in teaching different subjects. The study groups have been developed and taught based on specific practical syllabuses. Our center has around 850 graduates, who have successfully completed our courses in the physical location of our center. Developing and advancing our programs, currently we are bringing our experience to the global market. We guarantee that you will be delivered the most up to date and practical content provided by our professional instructors. Optimum IT Center is: - High-level educational center specialized in IT (Information Technologies) sphere - Professional training and re-training center for the professionals of the IT sphere - A chaining element between the Job Market of IT sphere and potential employees delivering practical knowledge - A team consisting of experienced professionals in the relevant fields.