Course details
FEATURES
- 16 hours of business focused Excel
- Taught through a trainer led class Practice spreadsheets
OUTLINES Section 1: Foundation
- Excel Introduction
- The Excel Interface
- Basic Navigation and Editing
- Getting Going
Section 2: Orientation and Efficiency
- Editing
- Viewing
- Spreadsheet Structure
- Cell References
- Named Ranges
- Basic Macros
- Design
Section 3: Administration
- Customizing Excel
- Housekeeping
- Connecting Workbooks
- Documentation
- Protecting and Sharing
- Google Docs
- Excel Troubleshooting
Section 4: Data Handling
- Sorting and Filtering
- Controlling User Input
- Working with Dates and Times
- Working with Text
- Lookup and Reference
- Logical Functions
Section 5: Data Analysis
- Working with Numbers
- Summarizing Data
- PivotTables 1 - Simple Summaries
- PivotTables 2 - Manipulating Data
- PivotTables 3 - Interpreting Data
- PowerPivot: Handling Big Data
- Formula Auditing
- Advanced Macros and VBA
- Modelling
Section 6: Presentation
- Cell Formatting
- Number Formatting
- Conditional Formatting
- Graphs and Charts
- Page and Print Setup
Certificate: Log In Certificate of Completion will be provided to delegates who attend and complete the course.
Updated on 26 August, 2018About Login Training Center
Log In Training Center JLT, provides training in languages (English,French,Spanish,Turkish,German)(beginner,intermediate, advanced,conversation,IELTS,TOEFL,SAT,English Business,Commercial Correspondence) , Computers , Business and Personal Development for both individuals and corporate , in addition to its unique and special "Log In Program" which is a combination of all a fore mentioned subjects with enhanced focus on assessment and planning to ensure the program perfectly fits the applicants' needs.
More than 50 courses are offered in addition to tailored courses for specific needs and requirements. The Center prides to have a net of the best trainers available in their fields. Our trainers are not only internationally certified, but also have great passion to education, and share with us the belief in its ability to transform life.
The Center is equipped with most up to date equipment, and uses international curricula in addition to its unique curricula for some subjects specially designed to fulfil the Center's mission and aim in creating learners and not only give information. Our textbook as well contains hints on, positiveness, planning, sustainability and social responsibility, which are part of every course we deliver.
In addition to courses, students and public in general are invited occasionally to one of our many sessions, presentations and conferences discussing various topics every time, where they will meet executives and professors and trainers.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel 2013 for Beginners eduCBAUSD 21
USD 105Duration: Upto 5 Hours - Advanced Excel Formulas eduCBAUSD 35Duration: Upto 2 Hours
