Want to learn the basics? Struggle to find your way around a workbook? Then this is the course for you.
Confident using a workbook, can manipulate data, columns and rows. Happy with the basic formulas?
Then this is the course for you.
Use Excel daily, happy with managing lists, filters, formulas, but know you could improve. Then this course will be great for you
Who is the course for?
Are you self-taught with gaps in your learning, this course is ideal for you. Or perhaps you need Excel for your work but don't know what it's all about?
I would thoroughly recommend this course for anyone who needs to know Excel better. You will be surprised how much you didn't know when you attend this course. You will find that your efficiency levels improve tremendously, by saving time on those painstaking tasks of cutting and pasting, scrolling down your page, creating headings on each page, and using Autofill to its full potential.
What the course will cover:
Course Outline
Is this course for me?
If you know the basics of Excel, have written formulas and used simple functions. You have created spreadsheets and charts and you feel competent at managing lists, sorting and using the different printing options available, then this course is ideal for you
Short recap from the Introduction course
Sorting and Filtering Data
Basic Formulae & Functions
Using Text functions like:
IF Functions
Conditional Formatting
Charts
Multiple Worksheets
Linking Data
Data Tools
Consolidation Exercise
If time:
Comments
Security
How to add a password to open or modify the spreadsheet
Is this course for me?
If you have used Excel for analysing data, can use functions and want to know some of the more advanced functions this is the course for you.
What the course will cover:
A short recap on the basics including shortcuts and Autofill options
Formulas and functions including:
Importing data from Text/Database/other external sources
Custom Sorting, Advanced Filtering (to extract information based on a complex criteria, or a unique lists)
Conditional formatting data based on cell contents and using formula
Groups and Subtotals
PivotTables, Slicers and PivotCharts including Pivot Calculations and sharing slicers
Recording and playing Macros (SQL not included)
Assigning a Macro to a shortcut key, Quick Access Toolbar button, or a Command button
Charts new 365 map chart etc.
Tracing precedents and Dependents
Using the Evaluate Formula Feature
Note: Excel has hundreds of functions and permutations of functions. This course covers some of the more popular and commonly used functions. If you are confident with the above areas and are looking for more information, it may be better to have one to one consultancy based on your areas of need.
Copyright © All Rights Reserved