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 - Excel Course (Basic and Advanced)

### Course Summary

This excel training covers both basic excel and advanced excel tutorial

• +

### Course Syllabus

• INTRODUCTION
• Introduction
• EXCEL 2010: GETTING STARTED
• Getting Started - Surfing Excel & HELP Function
• Getting Started - Surfing Excel & HELP Function
• CASE STUDY
• XYZ Company Basic Excel Case Study
• Excel Case Study
• Excel Case Study
• Data Entry in Excel
• Data Entry in Excel
• Populating the Case Study in Excel
• Populating the Case Study in Excel
• CALCULATIONS
• Calculations - Addition Subtract Multiply Division
• Calculations - Addition Subtract Multiply Division
• FORMULAS
• Formulas - SUM MAX MIN AVERAGE
• Formulas - SUM MAX MIN AVERAGE
• FORMATTING
• Formatting - Number Formats
• Formatting - Number Formats
• Formatting - Table Formats
• Formatting - Table Formats
• UPDATING A CALCULATION
• Updating a Calculation
• Updating a Calculation
• PERCENTAGES & ABSOLUTE REFERENCES
• Percentages and Absolute References
• Percentages and Absolute References
• CONDITIONAL FORMATTING
• Conditional Formatting
• Conditional Formatting
• IF FUNCTION
• IF Function
• IF Function
• COUNTIF AND SUMIF
• COUNTIF Function
• COUNTIF Function
• SUMIF Function
• SUMIF Function
• CHARTS AND GRAPHS
• Creating Charts and Graphs
• Creating Charts and Graphs
• Create Pie Charts
• Create Pie Charts
• SORTS AND FILTERS
• Sorts
• Sorts
• Filter
• Filter
• FREEZE AND SPLIT
• Freeze and Split
• PRESENTATION
• Presentation - Table Formats
• Presentation - Table Formats
• Presentation - Indents and Formatting Charts
• Presentation - Indents and Formatting Charts
• PRINT
• Printing the Worksheet
• Printing the Worksheet
• Printing - Headers and Titles
• Printing - Headers and Titles
• SHORTCUTS
• Shortcuts - Formatting and Navigation
• Shortcuts - Formatting and Navigation
• Shortcuts - Selection, Data and Formula
• Shortcuts - Selection, Data and Formula
• COMMON ERRORS
• Common Errors
• Common Errors
• KEY DIFFERENCE MS EXCEL 2007 VS 2010
• Office Button and Paste Function
• Office Button and Paste Function
• Sparklines, Custom Ribbons and Screenshots
• Sparklines, Custom Ribbons and Screenshots
• Conditional Formatting and Equation Editor
• Conditional Formatting and Equation Editor
• USEFUL EXCEL FUNCTIONS
• Paste Special
• Paste Special
• Logical functions IF AND OR
• Logical functions IF AND OR
• Logical Functions Quiz - without solutions
• Logical Functions Quiz - with solutions
• Logical functions IF AND OR
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• Cell Information ISERROR ISBLANK etc
• Cell Information ISERROR ISBLANK etc
• DATA FUNCTIONS
• CHOOSE Function
• CHOOSE Function
• CHOOSE Function
• VLOOKUP Function
• VLOOKUP Function
• VLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• MATCH INDEX
• MATCH INDEX
• MATCH INDEX
• Database functions DSUM DAVERAGE DCOUNT
• Database functions DSUM DAVERAGE DCOUNT
• Database functions DSUM DAVERAGE DCOUNT
• OFFSET Function- Understanding basics
• OFFSET Function - Dynamic nature
• FORECAST Function
• FORECAST Function
• WHATIF ANALYSIS
• One Dimensional Data Tables
• One Dimensional Data Tables
• One Dimensional Data Tables
• Two dimensional Data Tables
• Two dimensional Data Tables
• Solver
• Solver
• Goal Seek
• Goal Seek
• Goal Seek
• ARRAYS
• Array Function Introduction
• Array Function Introduction
• Array Function Row and Columns
• Array Function Row and Columns
• Array Function TRANSPOSE
• Array Function TRANSPOSE
• Array Function FREQUENCY
• Array Function FREQUENCY
• FUNCTIONS FOR WORKING WITH TEXT
• PROPER UPPER LOWER LEFT RIGHT MID
• PROPER UPPER LOWER LEFT RIGHT MID
• FIND CLEAN REPT CONCATENATE
• FIND CLEAN REPT CONCATENATE
• PIVOT TABLES IN DEPTH
• Pivot Tables
• Pivot Tables
• Pivot Table Filter Slicer
• Pivot Table Filter Slicer
• Pivot Charts
• Pivot Charts
• Naming Dynamic Ranges
• Naming Dynamic Ranges
• Naming a Cell and a Range
• Naming a Cell and a Range
• AUDITING AND TROUBLE SHOOTING FORMULAS
• Auditing Toolbar
• Auditing Toolbar
• Watch Window
• Watch Window
• FORM CONTROLS
• Group Boxes and Options Button
• Group Boxes and Options Button
• Check Boxes
• Check Boxes
• List Boxes and Combo Boxes
• List Boxes and Combo Boxes
• Scroll Bar and Spinners
• Scroll Bar and Spinners
• IMPORTANT EXCEL TOOLS
• Text to Columns
• Text to Columns
• Grouping Tabs
• Grouping Tabs
• SUBTOTAL Function
• SUBTOTAL Function
• Data Validation
• Data Validation
• Random Numbers
• Random Numbers
• Custom View
• Custom View
• Protecting Worksheet and Workbook
• Protecting Worksheet and Workbook
• Excel 2010 Sparklines
• Excel 2010 Sparklines
• Range Charts
• Range Charts Type 1
• Range Charts Type 1
• Range Charts Type 1- Continued
• Range Charts Type 1- Continued
• Range Charts Area
• Range Charts Area Type 2
• Range Charts Area Type 2
• Range Charts Area Type 2- Continued
• Range Charts Area Type 2- Continued
• Funding Graph
• Funding Graph
• Funding Graph
• Two Axis Graphs
• Two Axis Graphs
• Two Axis Graphs
• Scenario Graphs
• Scenario Graphs
• Scenario Graphs Continued
• Scenario Graphs Continued
• Average Line
• Average Line
• Bar to Pie chart
• Bar to Pie chart
• Combo Charts
• Combo Charts
• Creating Histogram
• Creating Histogram
• Invert Negatives
• Invert Negatives
• Scrolling Chart
• Scrolling Chart
• Scrolling Chart Continued
• Scrolling Chart Continued
• CONCLUSION
• Conclusion

Course Fee:
USD 119

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: