Online
- Duration / Course length: Há 2 Horas Start now
- Course delivery: This course is delivered in video format
Course details
During this course, you will get familiar with the how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and Pivot tables.Chapter 1. New features in Excel 2013
New Excel Templates
New Flash Fill
New Pivot Table, Timeline, Slicer and etc (Free Preview)
New Quick Analysis
Chapter 2. Start Working with Worksheets and basic functions
Creating a Blank Workbook
Ribbon Tabs and Display Options
How to cut and paste
How to copy and paste
Quick Access Toolbar (Free Preview)
Chapter 3. Basic and essential Tools
Spell Checker
Find and Replace
Hiding and unhiding Columns and rows
Conditional formatting (Free Preview)
Go to function
Useful Functions and their Shortcut keys
Undo and redo
Chapter 4. Working with Rows and Columns
Sorting Items
Filtering Items
Inserting and Deleting Rows and Columns
Adding comments to cell (Free Preview)
Compare two workbook side by side
Chapter 5. Auto Entering Data and Simple Formula
Using Auto Fill
Entering Data and Formatting Data
Auto SUM
Simple Formulas
Chapter 6. Creating Charts and formatting them
Creating Charts and Formatting Them
New Recommend Charts
Chapter 7. New SkyDrive and Sharing Features
New Sky Drive Sharing files
New Sharing Work on Social Networks
Chapter 8. Saving and Help
Saving work
Excel Help
Chapter 9. Learn from Complete sample exercise.
Complete Project, Calendar
Complete Project, House Budget Part 1
Complete Project, House Budget Part 2
Complete Project, Sales Receipt Ultima actualização em 11 July, 2018
