Input data through multiple sheets by grouping sheets together.
Using Insert Function to find the right formula.
Writing statistical functions COUNTA and COUNTBLANK. Write a COUNTIFS to count entries based on criteria.
Create a Table to organise and analyse data. Use Table tools to remove duplicates, run totals and add data.
Use Conditional Formatting to enable table’s numbers to standout by using rules to change colour automatically.
Analyse data with Pivot Tables.
Create and manage a Pivot Table’s layout.
Control a Pivot Table’s calculations and creating a Pivot Chart.
Shareable on LinkedIn
You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.
Call:
01225 308979
Email:
info@go.courses
Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL