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

Getting started:

  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Using a template
  • Entering and editing data
  • Entering and editing text and values
  • Entering and editing formulas
  • Saving and updating workbooks


Modifying Worksheet & Functions:

  • Moving and copying data
  • Moving, copying, and viewing formulas
  • Absolute and relative references
  • Inserting & deleting ranges, rows, columns
  • Entering functions
  • Auto Sum
  • Other common functions

Formatting:

  • Text formatting
  • Row and column formatting
  • Number formatting
  • Merge Cells
  • Apply an Auto Format
  • Apply Styles
  • Entering Data
  • Using Flash Fill
  • Using Auto Fill
  • Editing Data
  • Adding Rows and Columns
  • Checking Your Spelling

Managing workbooks and worksheets: 

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Linking worksheets with 3-D formulas
  • Usingmultiple workbooks
  • Linking workbooks
  • Usingspecial number formats
  • Workingwith themes
  • Otheradvanced formatting

Outlining and subtotals:

  • Outlining and consolidating data
  • Creating subtotals
  • Cell and range names
  • Creating and using names
  • Managing names
  • Data structure and tables
  • Sorting and filtering data
  • Working with tables

Building Formulas, Shortcuts.

تحديث بتاريخ 31 May, 2018

المتطلبات

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

نبذة عن معهد Evanson Training

Who we are?

We help organisations and individuals achieve results in the areas of Finance, Accounts, Reports, Audit, Work Management and Operational Efficiencies.

What we do?

Our team of experts can help you select the right initiatives, deeply customize our training solutions to fit your world, and excel at delivering your training through our network of top-rated facilitators, who have frontline industry experience.

How we do it?

  • We take the time to listen and understand your needs and your situation. And then we define training objectives.
  • Careful need analysis helps us develop training solutions in the context of addressing your specific objectives.
  • After successful completion of training we direct you towards productivity and performance, under guidance of industry experts in our network.

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

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

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

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

أو