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

# Ultimate Excel: become an Excel guru in easy, bitesize steps

### Course Summary

Become an Excel master and learn all the best tricks, from beginner through to advanced, in bitesize lessons

• +

### Course Syllabus

• Using Excel to add numbers
• The SUM function
• The SUMIF function
• A brief reminder for adding numbers
• Test yourself
• Basic calculations in Excel
• Learn to add, subtract, multiply, divide
• Using built-in functions to save time
• Operator order in Excel
• Operator order in Excel and what that means
• More complex formulas in Excel
• Learn how to create more complex formulas
• Basic calculations: Quiz
• Test yourself: Basic calculations
• Creating a graph (chart)
• Create a chart (graph) that's recommended for your data
• How to create pie, bar, and line charts
• Customize it to make it look exactly how you want
• What is a combo chart and how to create one
• How to copy a chart to another worksheet in the same or a different workbook
• Freeze or lock panes
• How to freeze panes
• Freezing panes in detail
• Cell references
• The basics of cell references
• Copying formulas with references
• Working with TIME
• Subtracting time
• Averaging a group of numbers
• How to average a group of numbers
• AVERAGEIF function
• Weighted average
• Sort and filter data
• Sort and filter data quickly
• Sorting things other than numbers
• Using the AutoFilter
• Conditional Formatting
• Using conditional formatting
• Conditional formatting and dates
• Conditionally formatting text
• Copy and remove conditional formatting
• Take conditional formatting to the next level
• Using formulas to apply conditional formatting
• How to manage conditional formatting
• VLOOKUP
• VLOOKUP: When and how to use it
• The nuts and bolts of VLOOKUP
• Look up values on a different worksheet
• Copy a VLOOKUP formula
• IF function refresher
• Nested IF functions
• IF used with AND and OR
• COUNTIF and SUMIF
• AVERAGEIF and IFERROR
• Using Dropdown lists
• Dropdown lists
• Dropdown list settings
• Input and error messages
• Managing dropdown lists
• Working with macros
• Work with macros
• Editing a macro
• Saving a macro
• Assigning a button to a macro

Course Fee:
USD 47

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: