During this course, you will get familiar with 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 AutoFill
- 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
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
Twitter
Studied or Worked here? Share Your Review
Please do not post:
Thank you once again for doing your part to keep Edarabia the most trusted education source.