Microsoft Office Specialist Excel 2010 NetAssist
السعر: 642 SGD
  • أماكن: Colombo Kandy
  • مدة الدورة التدريبية: 3 Days

    تفاصيل الدورة

    Microsoft Excel 2010 Core teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.

    Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Core Exam #77-882.

    Course Objectives
    This course teaches the skills you will need to successfully complete the Excel 2010 Core exam.

    You will use Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations.

    Modules:
    Lesson 1: Introducing Excel

    • What is an Electronic Spreadsheet?
    • Looking at the Screen
    • Entering Data in a Worksheet
    • Working with Workbooks
    • Selecting Cells



    Lesson 2: Constructing Cell Data

    • Editing Cells and Undoing Changes
    • Copying and Moving Data
    • Inserting and Deleting Rows and Columns
    • Adjusting the Columns and Rows
    • Finding and Replacing Data
    • Using AutoFill
    • Managing Worksheets


    Lesson 3: Using Formulas

    • Using Formulas
    • Using Functions
    • Using Absolute and Relative Cell References
    • Displaying and Printing Formulas


    Lesson 4: Formatting the Worksheet

    • Formatting a Cell
    • Clearing Cell Contents and Formatting
    • Themes
    • Using Cell Styles
    • Conditional Formatting


    Lesson 5: Viewing and Printing Workbooks

    • Changing Worksheet Views
    • Printing and Previewing the Workbook
    • Customizing the Page Layout
    • Changing Excel Default Settings


    Lesson 6: Working with Charts

    • Creating a Basic Chart
    • Moving and Resizing Charts
    • Changing Chart Types
    • Working with Pie Charts
    • Changing the Chart Layout and Location
    • Using Sparklines
    • Printing Charts


    Lesson 7: Working with Graphics

    • Drawing Shapes
    • Modifying Graphics Objects
    • Using SmartArt Graphics


    Lesson 8: Analyzing, Organizing and Sharing Workbooks

    • Sorting Data
    • Filtering Information
    • Working with Named Ranges
    • Using Hyperlinks
    • Using Comments
    • Importing and Exporting Data
    • Sharing Workbooks
    تحديث بتاريخ 06 November, 2018

    نبذة عن معهد NetAssist

    As the forerunner of infocomm technologies, we are committed to providing the highest quality of training to IT professionals, both novice and experienced. We are an advanced IT training and professional certification provider and have, since established in year 1999, provided the most comprehensive classroom education in the industry. Training with us provides you with valuable hands-on learning and in-depth instruction in a highly structured environment. Our experts are there to support you in the sharpening of your technical skills. 

    عرض الجميع دورات NetAssist
    دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن. See all courses

    هل هذه الدورة التدريبية الاختيار المناسب لك؟

    قيِم هذه الصفحة

    لم تجد ما كنت تبحث عنه؟

    أو