16 Educators providing Courses

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

🚀 Unleash Profit Potential with Strategic Pricing Formulas for Business Success - Module 4: Advanced Pricing Models! 🚀   Are you tired of second-guessing your pricing strategy? Ready to take your business to new heights by mastering the art of pricing? Look no further! Welcome to Module 4 of our game-changing online course: 'Strategic Pricing Formulas for Business Success - Advanced Pricing Models.'   🌟 Unlock the Power of Advanced Pricing Models! In this cutting-edge module, we dive deep into the intricacies of strategic pricing, equipping you with the tools and knowledge needed to propel your business forward. Here's a sneak peek into the curriculum:   🚀 Module 1: Introduction Lay the foundation for success by understanding the fundamentals of pricing strategies. Discover the critical role pricing plays in shaping consumer behavior and market dynamics. Gain insights into how pricing impacts your brand perception and overall business profitability. 💡 Module 2: Pricing Models Explore a variety of proven pricing models, from cost-plus pricing to value-based pricing. Learn how to analyze market conditions and competitor pricing strategies. Master the art of setting the right price to maximize revenue and customer satisfaction. 🌐 Module 3: Advanced Pricing Models (Focus of This Course!) Now, brace yourself for the ultimate deep dive into advanced pricing strategies. Here's what you'll conquer: Dynamic Pricing Strategies:Harness the power of real-time data to adjust prices dynamically.Explore personalized pricing strategies to cater to individual customer segments. Psychological Pricing Tactics:Understand the psychology behind consumer decision-making.Implement pricing tactics that influence perception and drive purchasing behavior. Subscription and Tiered Pricing:Learn how to create irresistible subscription models.Craft tiered pricing structures that appeal to different customer preferences. Bundling and Upselling Techniques:Master the art of bundling products and services for maximum value.Implement effective upselling strategies to boost average transaction value.   🌈 Why Choose This Course? Expert-Led Learning: Benefit from the expertise of industry professionals who have mastered the art of strategic pricing. Practical Applications: Apply your newfound knowledge with real-world case studies and hands-on exercises. Lifetime Access: Enjoy continuous access to updated content, ensuring your skills remain cutting-edge. Community Support: Join a vibrant community of like-minded entrepreneurs and pricing enthusiasts.   Don't miss out on this opportunity to revolutionize your pricing strategy! Enroll now in 'Strategic Pricing Formulas for Business Success - Module 4: Advanced Pricing Models' and set your business on the path to unparalleled success. 🚀✨   💡 Enroll Today and Price Your Way to Prosperity! Course Curriculum Module 1- Introduction Overview of Pricing Models 00:00 Module 2- Pricing Models Cost-Based Pricing Pros and Cons 00:00 Market-Based Pricing Pros and Cons 00:00 Value-Based Pricing Pros and Cons 00:00 Choosing a Pricing Model 00:00 Common Mistakes in Pricing 00:00 Setting Your Price Case Study 00:00