- Free Microsoft Excel Spreadsheet
- Intermediate Spreadsheets With Microsoft Excel Answers
- Microsoft Excel Spreadsheet Templates
- Free Excel Spreadsheet Templates
- How To Use Excel Intermediate
- Spreadsheets With Microsoft Excel Module
- Intermediate Spreadsheets With Microsoft Excel Test
How to Delete Blank Rows in Excel — The Right Way Written by co-founder Kasper Langmann, Microsoft Office Specialist. There's something inherently irritating about spreadsheets with blank rows. Excel sets out your data so nicely—and then its hard work is interrupted by blank rows. It seems unjust. What is the keyboard shortcut key to lock cell references in a formula?. CTRL. Mar 05, 2020 Welcome to the intermediate lesson on Excel. To be honest, this isn’t just one lesson. It is a group of lessons designed to kickstart your knowledge of functions and formulas in Excel. The lessons take about five minutes each.
Duration: 6 Hrs (2 @ 3 hr sessions)
This course explains how to use Microsoft Excel
for intermediate spreadsheet tasks and operations.
Level – Intermediate
This course is intended for those who have experience of Excel or have completed an Introduction course.
Live Virtual Training Dates
Free Microsoft Excel Spreadsheet
Why not attend one of our scheduled Live Virtual Training Dates
Course Objectives
∎ This course explains how to use Microsoft Excel for intermediate spreadsheet tasks.
∎ This course is intended for those who are experienced in Excel or have completed the Intermediate level course.
∎ We learn how to work with Excel Formula and Functions, manage data with sort and filter and analyse spreadsheets with tools such as Pivot Tables,
Course Content
u220e</span></span>Excel Productivity Tips</p>nu220e</span></span>Conditional Formatting</p>n
u220e</span></span>Linking Excel Data</p>n
u220e</span></span>Paste Specials</p>n
u220e</span></span>Freezing/Hiding Rows/Columns</p>n
u220e</span></span>Absolute Cell Referencing</p>n
u220e</span></span>Working with Formulas (SumIF, CountIF, CountA)</p>n
u220e</span></span>Working with Date Functions</p>n
u220e</span></span>Sorting Data</p>n
u220e</span></span>Filters & Advanced Filters</p>n
Intermediate Spreadsheets With Microsoft Excel Answers
u220e</span></span>Creating sub-totals</p>n
Microsoft Excel Spreadsheet Templates
u220e</span></span>IF and nested IF Functions</p>n
u220e</span></span>V Lookup</p>n
u220e</span></span>Intro to Tables</p>n
u220e</span></span>Intro to Pivot Tables</span></p>','tablet':','phone':'
u220e</span> The Excel Environment
u220e</span> Cutting, Copying and Pasting
u220e</span> Worksheet Management
u220e</span> Using Find and Replace
u220e</span> Working with Cells
u220e</span> Using Undo and Redo
u220e</span> Entering Data
u220e</span> Entering Basic Formula and Functions
u220e</span> Formatting Text
u220e</span> Auto-filling Rules
u220e</span> Formatting Numbers and values
u220e</span> Using Page Layout and Setup
u220e</span> Formatting Columns and Rows
u220e</span> Sorting and Filtering Data
u220e</span> Formatting Columns and Rows
u220e</span> Headers and Footers
u220e</span> Adding and Editing Borders
u220e</span> Printing a Spreadsheet</p>'}},'slug':'et_pb_toggle'}'>
∎Excel Productivity Tips
∎Conditional Formatting
∎Linking Excel Data
∎Paste Specials
∎Freezing/Hiding Rows/Columns
∎Absolute Cell Referencing
Free Excel Spreadsheet Templates
∎Working with Formulas (SumIF, CountIF, CountA)
∎Working with Date Functions
∎Sorting Data
∎Filters & Advanced Filters
∎Creating sub-totals
∎IF and nested IF Functions
∎V Lookup
∎Intro to Tables
∎Intro to Pivot Tables
Classroom Training - Scheduled Dates and Booking
∎ Due to Current Covid-19 restrictions we have postponed all classroom-based training courses.
∎ We will reschedule Excel training courses as soon as it is practical to resume in-class training.
∎ In the meantime we offer the same Excel courses on a Live Virtual Training basis.
∎ Please see below for scheduled dates and information.
Live Virtual Training Bookings
Dates, Fees & Group Discounts
Wednesday 21st – Thursday 22nd
9.30 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Excel Course Manual
How To Use Excel Intermediate
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)
Monday 10th – Tuesday 11th
9.30 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Excel Course Manual
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)
Tuesday 8th – Wednesday 9th
9.30 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Spreadsheets With Microsoft Excel Module
Excel Course Manual
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)