- Locations: Lagos Johannesburg - South Africa Sheikh Zayed Rd - Dubai Cape Town Gaborone Windheok Luanda Harare Ndola Lusaka Dar es salaam Maputo Beira Madagascar DRC Nairobi Abuja Portharcourt Accra
- Duration: 2 Days
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: Advanced Formatting
• Themes, colors, fonts and effects
• Hiding zeros on a worksheet
• Working with cell styles
• Conditional formatting
• Creating and using templates
Unit 4: Collaborating in Excel
• Editing workbook properties
• Adding Data Validation criteria to cells
• Working with comments
• Working with hyperlinks
• Protecting worksheets, workbooks and files
Unit 5: Formula Auditing
• Tracing Cells
• Error Checking
• Evaluate a formula
Unit 6: Working with Charts
• Data layout for charts
• Creating a new chart
• Changing the chart data
• Applying a different chart layout
• Adding and removing chart elements
• Changing the chart style
• Changing the chart type
• Moving a chart
• Formatting chart elements
• Working with sparklines
Unit 7: Illustrating Excel
• Working with pictures
• Working with SmartArt
• Working with shapes
• Working with WordArt Updated on 08 February, 2023
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
- Microsoft Excel Complete Diploma Skill-UpGHS 318Duration: Upto 1 Day
- Advanced Excel Formulas eduCBAGHS 344Duration: Upto 2 Hours
