Microsoft Excel 2013 Beginners

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 Updated on 11 July, 2018