MS Excel Full Course 1.0.1 [免費版]

MS Excel Full Course
This app includes below topics with detail explanation :
Basics : Excel Rows and Columns, Enter text and numbers in a Cell, How to Edit text in a Cell, How to Centre text and numbers, Font Formatting in Excel 2007/2010, How to
change the colour of a Cell, How to Save your work in Excel, Currency Symbols in Excel 2007/2010, How to Merge Cells, Review Number One
Spreadsheet : 1. Introduction to Section Two, 2. How to use AutoFill in Excel 2007/2010, 3. Entering Simple Addition Formula, 4. The SUM Function in Excel, 5. The SUM
Function Continued, 6. Copy and Paste, 7. How to use Paste Special, 8. How to Multiply in Excel 2007/2010, 9. Finishing your spreadsheet for this section, 10. How to Add a
Comment to a Cell, 11. Review Number Two
Processing : 1. Data Tables in Excel 2007/2010, 2. A Second Data Table, 3. Excel Scenarios, 4. Goal Seek, 5. Absolute Cell References, 6. Named Ranges in Excel 2007/2010,
7. Create a Custom Name in Excel, 8. Excel Pivot Tables, 9. Pivot Tables, Part Two, 10. Reference other Worksheets, 11. The LOOKUP Function, 12. The VLOOKUP Function in
Excel, 13. Create a Business Invoice, Part One,14. Excel Business Invoice, Part Two, 15 Business Invoice, Part Three
Functions : 1. The Average Function, 2. The Date Function, 3. Time Functions in Excel, 4. A TimeTable Project, 5. Financial Functions, 6. The Student Averages
Project
Charts : 1. How to Sort Data in Excel, 2. Create an Excel Chart, 3. Move and Resize your Chart, 4. Chart Styles and Layouts, 5. Chart Titles and Series Titles, 6. Chart
Layout Panel in Excel 2007/2010, 7. The Format Chart Panel, 8. Create a Pie Chart in Excel, 9. Add Labels to a Pie Chart, 10. Format Pie Chart Segments, 11. Create a 2D
Line Chart in Excel, 12. Format your Axis Titles
Formulas : 1. The SUM Function, 2. How to Multiply in Excel, 3. Subtract and Divide, 4. Combining the Arithmetic Operators, 5 A Budget Spreadsheet
Conditional : 1. The IF Function, 2. Conditional Formatting in Excel 2007/2010, 3. CountIF, 4. SumIF
Advanced Excel : 1. How to Create an Excel Template, 2. Data Forms in Excel 2007/2010, 3. Drop Down Lists in Excel, 4. Add your own Error Messages, 5. Excel and Web
Integration, 6. Hyper-links in Excel, 7. Object Linking and Embedding, 8. Insert Drawing Objects
MS Excel Full Course - Complete learning of Microsoft excel software. user friendly design and offline app. any user can access app from anywhere anytime without
internet.
This app contains below points :
Basic of excel
Charts in excel
conditional
formulas in excel
functions in excel
processing in excel
spreadsheet in excel
advance excel
ms excel learning
learn excel
Microsoft excel
ms office excel
excel learning
easy to learn excel
easy to use excel
excel course
free learning
learning app
learning from home
excel from home

• 08/05/2018: MS Excel Full Course 1.0.1
• Report a new version