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

Useful Excel for Beginners

Course Summary

Learn the basics of Microsoft Excel and become an effective user


  • +

    Course Syllabus

    • Introduction
      • Introduction to the Course
    • Basics of Excel
      • Basics of Excel
      • Workbooks and Worksheets
      • Fundamentals
      • CHAPTER 2: Basics of Excel
    • Entering Data
      • How to Enter data
      • Auto Fit
      • Keyboard Navigation
      • Auto Complete
      • Entering Numbers
      • Navigating edges
      • Navigating - First and last used cells
      • Selecting cells - Introduction
      • Selecting cells - Shift + Arrow
      • Selecting cells - Ctrl + Shift + Arrow
      • Selecting cells - Mouse Click and Drag
      • Selecting cells - Mouse Click and Shift Click
      • Selecting cells - All Cells & Used Cells
      • Selecting cells - Rows and Columns
      • Selecting cells - Non-contiguous cells
      • Selecting cells - Summary
      • Number Formatting - Introduction
      • Number Formatting - General and Text
      • Number Formatting - Number and Fraction
      • Number Formatting - Currency
      • Number Formatting - Accounting
      • Number Formatting - Percentage
      • Number Formatting - Date
      • Number Formatting - Time
      • Number Formatting - Summary
      • Inserting and deleting Rows, Columns and Cells
      • CHAPTER 3: ENTERING DATA
    • Formatting
      • Formatting - Introduction
      • Formatting - Bold, Italics and Underline
      • Formatting - Border
      • Formatting - Fill and Font
      • Formatting - Alignment
      • Formatting - Format Painter and Clear Formats
      • CHAPTER 4: FORMATTING
    • Editing
      • Editing - Editing Cell Content
      • Editing - Multiple Lines of Text
      • Editing - Ctrl + Enter
      • Editing - Auto Fill
      • Editing - Copy and Paste
      • Editing - Cut and Paste
      • Editing - Auto Fill Series
      • Editing - Sort
      • Editing - Filter
      • Editing - Find and Replace
      • CHAPTER 5: EDITING
    • Saving
      • Saving - Saving Excel documents
      • CHAPTER 6: SAVING
    • Viewing
      • Viewing - Freeze Panes
    • Calculations
      • Calculations - Introduction to Formula
      • Editing Formula
      • Introduction to Functions
      • Entering Functions
      • Types of Functions
      • MIN, MAX and AVERAGE Functions
      • Copying Formula
      • Cell References
      • Paste Formula
      • Counting Functions
      • Lookup Functions
      • Date Functions
      • Text Functions
      • SUMIF Function
      • IF Function
      • Errors
      • Calculations - Summary
      • CHAPTER 8: CALCULATIONS
    • Visualizing
      • Introduction to Charts
      • Creating a Chart
      • Chart Components - Labels
      • Chart Components - Background
      • Chart Components - Axes
      • Chart Components - Format and Design
      • Chart Types
      • Introduction to Conditional Formatting
      • Conditional Formatting - Format All Cells
      • Conditional Formatting - Format Only Cells
      • Conditional Formatting - More Rule Types
      • Conditional Formatting - Formula Based
      • Conditional Formatting - Summary
      • Illustrations
      • CHAPTER 9: VISUALIZING
    • Analyzing
      • Introduction to PivotTables
      • Creating PivotTable
      • PivotTable Summarization Types
      • PivotTable Tools
      • PivotCharts
      • CHAPTER 10: PIVOTTABLES
    • Tables
      • Creating a Table
      • Tables - Functionality
      • CHAPTER 11: TABLES
    • Sharing
      • Save & Send
      • Printing
      • CHAPTER 12: SHARING
    • Final Thoughts
      • Final Thoughts


Course Fee:
Free

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top