Course details
Have some experience with Excel and want to improve your skills? This course will help you learn Intermediate and Advanced Excel techniques. Whether you use Excel for work or study, this training will help you on your journey to becoming an Excel Expert!This workshop is highly interactive, as participants will be challenged to step out of their comfort zones and demonstrate the techniques practically. You will learn how to find a value with VLOOKUP, create and format Pivot Tables, record Macros and more. Designed and delivered by internationally qualified and experienced trainer, the workshop can be tailored in alignment with your business objectives.
Course Content:
Conditional Formatting
- Formatting Cells Containing Values
- Clearing Conditional Formatting
- Working with Data Bars, Colour Scales and Icon Sets
- Creating and editing Sparklines
- Performing An Alphabetical Sort
- Performing A Numerical Sort
- Sorting On More Than One Column
- Sorting By Vertically & Horizontally
- Understanding Filtering
- Applying, Using and Clearing A Filter
- Creating Compound Filters
- Creating Multiple Value and Custom Filters
- Using Wildcards
- Understanding Filling
- Filling A Series
- Creating, Modifying and Deleting A Custom Fill List
- Adding Chart and Axes Titles
- Positioning The Legend
- Show Data Labels and Data Table
- Modifying The Axes
- Creating a combination chart
- Creating 2 Axis chart
- Choosing The Chart Type
- Creating A New Chart
- Working With An Embedded Chart
- Resizing and changing Chart type
- Creating drop down in cells
- Restricting values from list only
- Creating error messages
- Creating dependent lists
- Text to Column, SubTotal and Paste Special
- Group / Ungroup
- Sharing workbook
- Understanding Pivot Tables
- Creating A PivotTable Shell
- Filtering A PivotTable Report
- Clearing A Report Filter
- Formatting A PivotTable Report
- Understanding and Creating Slicers
- Converting data into table
- Automation calculation in table
- Converting table to normal range
- Using table in Charts & Vlookup
- Understanding Logical Functions
- Using IF To Display Text
- Using IF To Calculate Values
- Nesting IF Functions
- Using IFERROR, AND and OR Functions
- Absolute and Relative Referencing
- Problems with Relative Formulas
- Creating Absolute References
- Recording & Running Macros
- Creating button to run the macro
- Assigning shortcut to macro
- Deleting Macros
- Relative reference in Macros
- Count, CountA, CountIF & CountBlank
- Sum, SumIF & SumIFs
- Networkdays
- Today, Now, Trim and Concatenate functions
- Normal Vlookup & Hlookup
- Vlookup with IFError
- Vlookup from Multiple Sheets using IFERROR
- Using IF Condition and Multiple criteria in Vlookup
- Open & Modify file password
- Protect sheet from deletion, data copy or protect few cells, rows or columns
Job roles this course is suitable for:
Office Manager , Project Manager , Business Professional , Administrative Assistant , Anyone who generates report , Anyone who analyzes data , Accounting and Finance professionalCourse Location
About Eminent Educational Institute
Eminent offers a range of courses that will enhance your skills, improving efficiency and productivity.Successful people invest in themselves and Eminent has been assisting individuals for the last 25 years in the process by offering an extensive range of courses, at affordable prices.
Our courses are delivered by subject matter experts with both training as well as industry experience. They are not only professional, but also considerate and sensitive towards varying individual needs and provide the necessary support to every participant during the learning process.
Take a look at what we have to offer and feel free to call us for more information and guidance on how we can help you advance your skills and thereby your career. See all Eminent Educational Institute courses
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- How to use Vlookup in Excel EVREN EDUOLC SOLUTION PRIVATE LIMITEDAED 51
AED 103Duration: Upto 3 Hours - Excel Data Analysis Academy for Health & FitnessAED 46
AED 2,387Duration: Upto 2 Hours
