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

Self-Study

Active