- مدة الدورة التدريبية: 1 Day
تفاصيل الدورة
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.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Microsoft Excel for Beginners Certificate New Skills Academy88 درهم
1,098 درهممدة الدورة التدريبية: 15 ساعة - Microsoft Excel 2016 Advanced Level Training Express78 درهم
735 درهممدة الدورة التدريبية: Upto 3 Hours