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

Excel 2010 Superhero Course

Course Summary

Awesome skills and techniques to make you an Excel Superhero


  • +

    Course Syllabus

    • Introduction
      • Course Intro
    • Working with Windows
      • Freeze Panes
      • Split Panes
      • Working with Multiple Windows
    • Sorting and Filtering Records
      • Sorting Records
      • Filtering Records
      • Sorting and Filtering Records by Cell or Font Colour
      • Sorting and Filtering
    • Getting Started with Formulas
      • Writing Formulas
      • Calculating Percentages
      • Introduction to Functions
      • Absolute Cell References
      • Defined Names
      • COUNTA and COUNTBLANK Functions
      • The Excel Function Wizard
      • Exercise 1: Absolute and Mixed References
      • Exercise 2: Writing Formulas
      • Exercise 3: Using Functions
    • Using Logical Functions
      • The IF Function
      • Testing Multiple Conditions
      • Nesting Functions to Test Multiple Conditions
      • Exercise 1: Using the IF Function
      • Exercise 2: Nesting Functions
    • Using Lookup Functions
      • The VLOOKUP Function
      • VLOOKUP for the Closest Match
      • The HLOOKUP Function
      • VLOOKUP with Nested MATCH Function
      • The LOOKUP Function
      • The INDEX and MATCH Functions
      • Handling the #N/A Error Message
      • Exercise 1: Lookup Functions
    • Protecting and Sharing Excel Files
      • Encrypt an Excel File
      • Workbook Protection
      • Worksheet Protection
      • Sharing a Workbook
    • Using Conditional Formatting
      • Applying Conditional Formatting
      • Using Data Bars and Icon Sets
      • Managing your Conditional Formatting Rules
      • Apply Conditional Formatting to the Entire Row
      • Use a Formula for your Rule
      • Exercise 1: Conditional Formatting
      • Exercise 2: Highlight Unmatched Items
    • Validating Data Entry
      • Validate the Text Length of a Data Entry
      • Validate Date Entries
      • Validate using a Drop Down List
      • Create your own Input and Error Messages
      • Create Dependent Drop Down Lists
      • Exercise 1: Validating Entry of Dates
      • Exercise 2: Validating Entry of Values
    • Analysing Data
      • Subtotals
      • The SUMIF Function
      • The SUMIFS and COUNTIFS Functions
      • The SUBTOTAL Function
      • Exercise 1: Applying Subtotals
      • Exercise 2: Using SUMIFS
    • Working with Charts
      • Create a Column Chart
      • Create a Pie Chart
      • Create a Combination Chart
      • Save a Chart Template
      • Dynamic Data Labels
      • Create an Interactive Chart
      • Using Sparklines
    • Formatting a Range as a Table
      • Create the Table
      • Structured References within Formulas
      • Convert a Table to a Range
    • Working with PivotTables
      • Create a PivotTable
      • Sorting PivotTable Fields
      • Change the Values Function and Format
      • Grouping PivotTable Fields
      • Showing Differences and Comparisons
      • Filtering PivotTable Data
      • Refreshing PivotTable Data
      • Create a PivotChart
      • Using Slicers
      • Exercise 1: Using PivotTables
      • Exercise 2: Using Slicers
    • Importing Data into Excel
      • From a Text File
      • From an Access Database
      • From the Web
      • Exercise 1: Import from Access
      • Exercise 2: Import from a Text File
    • Cleaning and Preparing Data
      • Using Find and Replace
      • Text to Columns
      • The CONCATENATE Function
      • Extracting Text from a Cell
      • Using MID and FIND Together
      • The VALUE Function
      • Exercise 1: Text to Columns
      • Exercise 2: Text Functions
    • Automate Repetitive Tasks with Macros
      • Recording a Macro
      • Assigning a Macro to a Toolbar Button
      • Customising the Ribbon
      • Adding a Button to the Worksheet
      • Saving a Macro Enabled File
      • Using Relative References in Macros
      • Editing Macro Code
      • Exercise 1:Using Macros
    • Conclusion
      • Conclusion


Course Fee:
USD 99

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