- مدة الدورة التدريبية: 1 Day
تفاصيل الدورة
This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data and worksheets, and use the tables and filtering features to manage and analyse data.
Assumed Knowledge
It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction course or have obtained comparable knowledge from the workplace.
Section One: Advanced File Tasks
- Using Windows Explorer within Excel
- Saving your Files
- Using File Management Tools
Section Two: Working with Functions and Formulas
- Using Formulas in Excel
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
- Working with Array Formulas
Section Three: Managing Tables
- Working with Tables
- Working with Records and Fields
- Working with Tables and Filters
- Using Excel as a Database
Section Four: Adding the Finishing Touches
- Research Tools
- Using Themes
- Adding Text Boxes
- Inserting Pictures and ClipArt
- Using Screenshot tool
Section Five: Showing Data as a Graphic
- Inserting SmartArt
- Formatting SmartArt
- Adding Symbols, Equations, and Shapes
- Adding Sparklines
- Editing Sparklines
نبذة عن معهد Positive2Work Skillnet
- Building Resilience / Stress Management
- Conflict Management / Building Constructive Relations
- Change Management / People Management
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office 2010 Access Advanced Alpha Academy100 درهم
1,910 درهممدة الدورة التدريبية: Upto 3 Hours - Microsoft Outlook 2016 Inspire London College90 درهم
1,653 درهممدة الدورة التدريبية: Upto 1 Week
