2 Days Of Excel Training For Staff
- or -
Post a project like this£1.0k(approx. $1.2k)
- Posted:
- Proposals: 10
- Remote
- #2233932
- OPPORTUNITY
- Expired
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
158872082707494791652864209896622381072344742244654124710242509120
Description
Experience Level: Expert
I am looking to run two 1 day courses for 8 staff (16 staff in total) on from beginner to intermediate on Microsoft Excel at our facility in Rickmansworth.
We have 8 PCs and a projector - trainer will need to provide their own training slides and material.
The topics to be covered are:
Microsoft Excel Masterclass Outline
• Starting Excel from the desktop
• Understanding the Excel start screen
• The Excel tab interface
• The Excel Workbook screen
• Using the Ribbon
• Showing and collapsing the Ribbon
• Understanding the backstage view
• Accessing the backstage view
• Using shortcut menus
• Understanding dialogue boxes
• Launching dialogue boxes
• Understanding the Quick Access toolbar
• Adding commands to the QAT
• Understanding the Status Bar
• Sorting Data:
• Understanding lists
• Performing an alphabetical sort
• Performing a numerical sort
• Sorting on more than one column
• Sorting numbered lists
• Sorting by rows
• Understanding filtering
• Applying and using a filter
• Clearing a filter
• Creating compound filters
• Multiple value filters
• Creating custom filters
• Using wildcards
• Managing Tables
• Creating a table
• Inserting or deleting table records
• Removing duplicates
• Modifying a table
• Sorting data in a table
• Filtering data in a table
• Adding and removing table columns
• Naming tables
• Resizing tables
• Playing with table styles
• Converting a table to a range
• Deleting a table
• Conditional Formatting:
• Understanding conditional formatting
• Highlighting cells containing values
• Highlighting cells containing text
• Highlighting duplicate values
• Using top and bottom rules
• Using data bars
• Using colour scales
• Using icon sets
• Creating custom rules
• The conditional formatting rules manager
• Managing rules
• Clearing rules
• Using Sparklines
• Working with Functions and Formulas:
• Using Formulas in Excel
• Exploring Excel Functions
• Using Functions in Excel
• Working with Names and Ranges
• Working with Array Formulas
• What if Formulas
• Common Error Messages
• VLOOKUPs
• Pivot Tables:
• Create a PivotTable from an Excel data list
• Add/remove/reorganise data fields
• View data in more detail
• Change how values are summarised
• Refresh data/change data source
• Filter PivotTable with Slicers/Timelines
• Create and modify a PivotChart
• VLOOKUPs
• Charts
• Create and modify charts such as Pie, Column & Line
• Format charts to enhance their presentation
• Print charts
• Excel Tips & Tricks - Top 10 Excel Shortcuts
• Enter data or formulas in non adjacent cells simultaneously
• Copy data or formulas down a column instantly
• Instantly enter today's date or time
• Convert formulas to values with a simple drag
• Adjust all or selected column widths or row heights in a flash
• Display all worksheet formulas instantly
• Create charts instantly with either of these keystroke shortcuts
• Display Print Preview instantly
• Undo, redo, and repeat with keystrokes
• Zoom in and out quickly
We have 8 PCs and a projector - trainer will need to provide their own training slides and material.
The topics to be covered are:
Microsoft Excel Masterclass Outline
• Starting Excel from the desktop
• Understanding the Excel start screen
• The Excel tab interface
• The Excel Workbook screen
• Using the Ribbon
• Showing and collapsing the Ribbon
• Understanding the backstage view
• Accessing the backstage view
• Using shortcut menus
• Understanding dialogue boxes
• Launching dialogue boxes
• Understanding the Quick Access toolbar
• Adding commands to the QAT
• Understanding the Status Bar
• Sorting Data:
• Understanding lists
• Performing an alphabetical sort
• Performing a numerical sort
• Sorting on more than one column
• Sorting numbered lists
• Sorting by rows
• Understanding filtering
• Applying and using a filter
• Clearing a filter
• Creating compound filters
• Multiple value filters
• Creating custom filters
• Using wildcards
• Managing Tables
• Creating a table
• Inserting or deleting table records
• Removing duplicates
• Modifying a table
• Sorting data in a table
• Filtering data in a table
• Adding and removing table columns
• Naming tables
• Resizing tables
• Playing with table styles
• Converting a table to a range
• Deleting a table
• Conditional Formatting:
• Understanding conditional formatting
• Highlighting cells containing values
• Highlighting cells containing text
• Highlighting duplicate values
• Using top and bottom rules
• Using data bars
• Using colour scales
• Using icon sets
• Creating custom rules
• The conditional formatting rules manager
• Managing rules
• Clearing rules
• Using Sparklines
• Working with Functions and Formulas:
• Using Formulas in Excel
• Exploring Excel Functions
• Using Functions in Excel
• Working with Names and Ranges
• Working with Array Formulas
• What if Formulas
• Common Error Messages
• VLOOKUPs
• Pivot Tables:
• Create a PivotTable from an Excel data list
• Add/remove/reorganise data fields
• View data in more detail
• Change how values are summarised
• Refresh data/change data source
• Filter PivotTable with Slicers/Timelines
• Create and modify a PivotChart
• VLOOKUPs
• Charts
• Create and modify charts such as Pie, Column & Line
• Format charts to enhance their presentation
• Print charts
• Excel Tips & Tricks - Top 10 Excel Shortcuts
• Enter data or formulas in non adjacent cells simultaneously
• Copy data or formulas down a column instantly
• Instantly enter today's date or time
• Convert formulas to values with a simple drag
• Adjust all or selected column widths or row heights in a flash
• Display all worksheet formulas instantly
• Create charts instantly with either of these keystroke shortcuts
• Display Print Preview instantly
• Undo, redo, and repeat with keystrokes
• Zoom in and out quickly
Sam C.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
43%
Last project
18 Jan 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies