Course
Google Sheets Level 2
Course Duration
1 Day
Public Scheduled Dates
<<
<
>
Public scheduled prices per delegate +VAT
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Course Content
-
RECAP of performing calculations in SheetsAdding and Subtracting Numbers
Multiplication and Division
Understanding BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Using Absolute ReferencingDifference between Relative and Absolute References
Absolute Reference and the Dollar Sign
Why use Absolute References?
Using an Absolute Reference in a formula
-
Naming Cells (Ranges)Giving names to cells and ranges of cells
Names in formulas
Editing and deleting names
-
Linking within a workbookLinking within a workbook
Simple referencing in a worksheet
Calculating across multiple sheets
-
Calculating Data with Logical Functions (IF Function)IF functions
IF function criteria
Using IF’s to test or check your data
-
Conditional FormattingConditional Formatting Types
Highlight Cells different colours based on their value
Single colour and colour scales
Customising Conditional Formatting
-
Performing Date and Time CalculationsDate Shortcuts
TODAY and NOW functions
DATEDIF function
YEAR, MONTH, DAY, TEXT functions
NETWORKDAYS function -
CommentsAdding, Editing and Deleting Comments
-
Cleaning DataRemove Duplicates
Trim whitespace
Use Clean up suggestions -
Data ValidationSpecifying validation criteria
Controlling entry into a cell
Types of Validation Criteria
Creating a drop-down list
-
SecurityProtecting a range or a worksheet
-
Presenting Data Using ChartsCreating a chart
Modifying charts
Formatting charts
Advanced Chart Features
-
SlicersUsing Slicers
-
Sharing and CollaboratingSharing in Sheets
Emailing a Document as an Attachment
Collaborating in Real-Time
Learn with IT Training Solutions. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
Please contact us to book a place or request a quote for your course.
-
Course Options
Please contact us to discuss options for this courseVirtualVirtualThese courses can be attended from anywhere.PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.BespokeBespokeBespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/25/2024 6:16:51 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/25/2024 6:16:51 AM