MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Microsoft Excel 2013 Training for Beginners / Intermediate

• +

### Course Syllabus

• Introduction to the course
• Introduction
• What is Microsoft Excel?
• What will you learn from this course?
• Earn your certificate of completion
• Understanding the basics
• Understanding the basics Intro
• Create a new template
• 3D Index
• Workbook and Worksheets
• Ribbon
• The formula bar
• Entering Data
• Excel Operators
• Find and Replace Tool
• Hide Columns and Rows
• Shortcuts
• Understanding the basics
• Save a file
• Intro
• Saving the workbook
• Different Extensions
• Auto Recover
• Protect File
• Save a file
• Printing and Sharing
• 1 - Intro
• Let's Print
• Print Selection
• Print the Workbook
• Print to file
• Page Orientation
• Printing and Sharing
• Getting started with data
• Intro
• Copy and Paste
• Paste Special
• Undo & Redo
• Format cells
• Wrap text
• Merge data
• Flash Fill
• Insert Equations & Symbols
• Worksheet Background
• Protect Worksheets
• Freeze Panes
• Format Painter
• Tables and borders
• Text to Columns
• Getting started with data
• View and Review
• Intro
• Page Views
• Window arrangement
• Spell-Check
• Translate
• View and Review
• Accounting
• Intro
• Change Currency
• Decimal Values
• Format with percentage and comma
• Accounting
• Top 10 formulas to maximize your productivity
• Intro
• What is a formula?
• Basic Syntax
• SUM
• COUNT
• AVERAGE
• SumIF, CountIF & AverageIF
• LEN
• IF Statement
• "=" Sign
• VLOOKUP
• Analyse the formula
• Lock cell references
• Top 10 formulas to maximize your productivity
• Pictures and graphics
• Intro
• Inserting Pictures
• Inserting Shapes
• Smart Art
• Picture Position
• Pictures and Graphics
• Creating Charts
• Intro
• Why do we need them?
• Different chart types
• Creating a bar & column chart
• Different axis
• Trend line VS Limit line
• Edit chart data
• Data labels
• Format chart area
• Creating Charts
• Conditional Formatting
• Intro
• Different types of conditional formatting
• Create a rule
• Manage a rule
• Clear a rule
• Conditional Formatting
• Pivot Tables
• Intro
• What is a pivot table?
• Creating a pivot table
• Manage criterias
• Slicers
• Pivot Tables
• Sorting and filtering
• Intro
• Create a filter
• Sort data
• Create an Auto Fill
• Data Validation Lists
• Sorting and filtering
• Bonus Lesson
• Course Completion
• Congratulations !

• Course Fee:
USD 69

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: