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 2013 Basic Training Course

### Course Summary

Master Basic Excel 2013 Features. Get a solid foundation level understanding of Excel 2013 - formulas & functions

• +

### Course Syllabus

• Overview
• Overview
• Getting Started
• Opening Excel
• Familiarity with excel interface and Ribbons
• Surfing an excel worksheet and How to use HELP in MS Excel
• Case Study
• Case Study
• XYZ Company Basic Excel Case Study
• Data Entry
• Data entry in excel
• Populating the Case Study in Excel
• Populating the Case Study in Excel
• populating case study in excel (without solution)
• populating case study in excel (with solution)
• Calculations
• Calculations
• Calculations (without solution)
• Calculations (with solution)
• Formulas
• Formulas - part 1
• Formulas - part 2
• Formulas (without solution)
• Formulas (with solution)
• Formatting
• Formatting Number formats
• Formatting - Number Formats (without solution)
• Formatting - Number Formats (with solution)
• Formatting Table formats
• Formatting Table formats
• Formatting - Table Formats (without solution)
• Formatting - Table Formats (with solution)
• Updating a Calculation
• Updating a Calculation
• updating a calculation (without solution)
• updating a calculation (with solution)
• Percentages & Absolute References
• Percentages and Absolute References
• percentage & asbsolute refernces(without solution)
• percentage & asbsolute refernces(with solution)
• Conditional Formatting
• Conditional Formatting
• Conditional formatting (without solution)
• Conditional formatting (with solution)
• IF Function
• IF Function
• if function (without solution)
• if function (with solution)
• COUNTIF
• COUNTIF
• count if (without solution)
• count if (with solution)
• SUMIF
• SUMIF
• SUMIF (without solution)
• SUMIF (with solution)
• Graphs & Charts
• Graphs and Charts Part 1
• Graphs and Charts Part 2
• Graphs and Charts Part 3
• Graphs & Charts (without solution)
• Graphs & Charts (with solution)
• Pie Chart
• Pie Chart
• Create Pie Chart (without solution)
• Create Pie Chart (with solution)
• Sorts
• Sort function
• Sort (without solution)
• Sort (with solution)
• Filter Function
• Filter Function
• Filter (without solution)
• Filter (with solution)
• Pivot table
• Pivot table Part 1
• Pivot table Part 2
• Pivot table (without solution)
• Pivot table (with solution)
• Freeze & Split
• Freeze and Split
• Freeze panes (without solution)
• Freeze panes (with solution)
• Split (without solution)
• Split (with solution)
• Presentation
• Table Formats
• Presentation table format (without solution)
• Presentation table format (with solution)
• Indents and Formatting Charts
• Indents and Formatting Charts (without solution)
• Indents and Formatting Charts (with solution)
• Print
• Printing the Worksheet
• Print Layout
• Printing the Worksheet (without solution)
• Printing the Worksheet (with solution)
• Print Layout (without solution)
• Print Layout (with solution)
• Shortcuts
• Shortcuts Part 1
• Shortcuts Part 2
• Shortcuts Part 3
• Shortcuts Part 4
• Shortcuts Part 5
• Shortcuts Part 6
• Excel Shortcuts
• Common errors
• Common errors

Course Fee:
USD 99

Self-Study

Active