By doing this way, your learnings are step by step and you will be confident to make any statement, reports, complex calculations and their printing. Lab assignment is added in order, so this also you can practice it. After the completion of this course, we are ensuring your excel knowledge, for making various statements, reports and their printing, complex calculations etc.Īfter watching each video, please practice it yourself, then start the next video. Since this course is well designed and learning method is step by step from start to end, the learners can grasp simply each topics, and at the end of each section, there is a lab assignment - instruction video and downloadable file, for making practice.
Excel Keyboard Shortcuts - frequently used shortcuts and their uses with example Pivot Table and Chart - Setup and Creationħ. Excel Charts - Setup and creation of Chart ( Column Chart, Line Chart, Pie chart, Combo Chart, Spark Line. Excel Functions - explanation and uses with exampleĥ. General commands and tools - operation and their uses with exampleĤ. Review - Protect sheet and general commands and tools - operation and their uses with example Other commands and tools - operation and their uses with exampleĮ. Data - Advanced tools - Scenario, Data Validation, Consolidate, subtotal and group,įlash Fill ,text to column, sorting and filtering Formula Bar - Advanced tools - Name Manager, Formula auditingĭ. Page Layout - general commands and tools - operation and their uses with exampleĭ. Insert - general commands and tools - operation and their uses with exampleĬ. Home - general commands and tools - operation and their uses with exampleī. Excel Ribbon and Tabs - a detailed explanationĪ. Formula Bar - role of formula bar in excel, various calculations and making formula and their operationģ. Cell Reference - Absolute, Missed and Relative Reference ( Application and uses with example)Ĭ. Worksheet - operation and management (cell, formula, data manipulation, simple calculation etc.)ī.
The learners who are just learned excel basics, but have no experience and practice, want to enhance knowledge and practiceĪ. The learners who are the beginner, knowing computer basics, but not knowing excel and their operationĢ. This Excel online Tutorial is designed and developed by RCCS, Institute of Information Technology to spread their teaching experience and services across the world.ġ.
0 kommentar(er)
