24.01.2020 Manchester

Excel Intermediate Course

Friday, 27th March 2020 from 09:30 to 16:30
Salford, M50 2RP, 1 Houston Park, Zeta House
(Manchester) - view map
MPM Computers Training Provider
 Show Interest
  Email Organiser

Excel Intermediate Course

 Show Interest
  Email Organiser

This course is intended for those who have general experience of Excel and who wish to widen their knowledge of the features and functions contained within the product. You will work with advanced functions and tools to enhance the look and appeal of the worksheet. Upon successful completion you will be able to: Use advanced formulae, Consolidate several spread sheets into one, Use Conditional formatting to analyse a list of data, Create and modify charts, Use advanced table techniques including filter and summarising, Use Pivot table and charts, slicers, Share and protect worksheets. Please be sure to read the pre-requisites for this course to ensure you meet the requirements. Working with Large Worksheets

Viewing options - Adjusting zoom - Using Freeze Panes - Using Split Window Hiding and displaying data - Hiding rows and columns - Creating an outline Printing large worksheets - Page Break preview - Working with page breaks - Printing multiple sheets

Working with Multiple Worksheets and Workbooks

Using multiple worksheets - Navigating between sheets - Moving and copying sheets Linking worksheets - Creating 3-D formulas - Consolidating data Linking workbooks - Creating a formula to link workbooks - Using the Paste Link option - Maintaining links

Working with dates

Entering date functions - TODAY function - NOW function Date and time formats Using dates in formulas

List Management

Working with lists - Structure of a list Sorting and filtering lists - Simple sorting - Sorting by multiple columns - Using AutoFilter Advanced filtering - Using custom filter - Using Advanced Filter Adding subtotals to a list

Using logical functions

Naming ranges - Creating named ranges - Using named ranges in formulas The IF function (recap) Creating nested IF functions AND and OR functions Combining logical functions

Working with lookups

The VLOOKUP function The HLOOKUP function

PivotTables and PivotCharts

Using the PivotTable Wizard Rearranging PivotTables Using the PivotTable toolbar Creating PivotCharts Using Slicers to manipulate PivotTables

Working with dates

Entering date functions - TODAY function - NOW function Date and time formats Using dates in formulas

Conditional formulas and formatting

The IF function Conditional formatting - Based on a cell value - Based on a formula - Identifying cells with conditional formatting - Copying conditional formats

List Management

Working with lists - Structure of a list Sorting and filtering lists - Simple sorting - Sorting by multiple columns - Using AutoFilter Advanced filtering - Using custom filter - Using Advanced Filter Adding subtotals to a list

Using logical functions

Naming ranges - Creating named ranges - Using named ranges in formulas The IF function (recap) Creating nested IF functions AND and OR functions Combining logical functions

Working with lookups

The VLOOKUP function The HLOOKUP function

PivotTables and PivotCharts

Using the PivotTable Wizard Rearranging PivotTables Using the PivotTable toolbar Creating PivotCharts Using Slicers to manipulate PivotTables

 

  • Microsoft
  • Training
  • Excel
  • Training & Development
Business Owner, Business Coach, Business Growth

From Just Busy to Blooming In Six Weeks

28th April, Tuesday 12:00
Online Event
B2B, Business, Marketing, Networking events

Hampshire Business Expo 2020

8th April, Wednesday 9:00
Farnborough, GU14 8JX

Enquiry For Excel Intermediate Course

MPM Computers is an IT training provider, offering course for any level of user and also any size of group.
Expertise

More Events

Event, Business, Exhibition stall

Liverpool Business Fair 2020

1st May, Friday 10:30
Liverpool, L4 0TH

Would you like to promote an event ?

Post your events, seminars, conferences and courses on Professionals UK. Attract attendees and new clients. Reach out to members and visitors.
Join for free today here and start uploading events.

Find the right professionals in United Kingdom

View The Full Index

Search By:

Submit your Enquiry here

Enquiry Details

Contact Details