Course details
Unit 1: Working with Defined Names• About defined names
• Creating range names
• Using names in formulas and functions
• Managing names
• Listing names and references on a worksheet
• Applying new names to existing formulas
Unit 2: Working with Data and Lists
• Sorting data
• Creating a custom list
• Filtering data
• Working with Excel Tables
• Summarising data with automatic subtotals
• Consolidating data
• Working with duplicate values
• Linking cells across worksheets and workbooks
Unit 3:… + Read More
Eligibility / Requirements
Course is delivered in English language. Learners are required to have English Language and Mathematics communication level 1.
Job roles this course is suitable for:
Data Capturer , HR manager , Admin Executive , Training AdministratorCourse Location
About Lopterra Training
Lopterra is a trusted name for management systems, SHEQ and Soft Skills training, we are your go to solution for quality training services. Our international & national training courses are accredited and our facilitators and assessors are highly skilled. We offer global levels of training excellence with local and international expertise providing training courses that adds value to your organization.
Why Us
Our training programmes are designed to meet the peculiar needs of prevailing local operating environment and international best practices. We provide:
- Accredited courses where required.
- Various learning options (Classroom, Elearning, In-house (your facility))
- Expert instruction from qualified and experienced facilitators
- Wide range of training courses including including Food Safety, SHEQ and Corporate Soft Skills Courses.
- A certificate to document your attendance, and a successful completion (where assessments apply)
- Learning materials (such as workbooks, flash cards and guidance documents)
- Modern learning techniques
- Current information and knowledge of regulations and standards
- Lunch and/or refreshment breaks every day of the course
Our commitment to meeting our clients’ needs and expectations is expressed in our proposition: Expected Quality, Delivered to satisfaction. To us - it is a culture that inspires and drives our company. To you - it is our promise that unparalleled quality of our skills and expertise towards delivering relevant value to your processes, products and brands.
See all Lopterra Training courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel 2013: Essentials 1TRAININGNGN 31,521
NGN 229,603Duration: Upto 30 Hours - Microsoft Access for Beginners One EducationNGN 33,375
NGN 688,809Duration: Upto 5 Hours