8095 Courses in Liverpool delivered Online

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

From business to research, having a solid grasp of Excel Data analysis can open doors of opportunity in various industries. Learn this valuable skill set from the comfort of your home with the Data Analysis In Excel course. This course will introduce you to the ins and outs of Excel data analysis. This Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will help you pick up the skills to visualise data with charts in Excel. Here, you will also learn about Pivot Tables and Charts. Furthermore, the course will teach you how to work with multiple Workbooks. In addition, you will learn about Lookup factions and how to use them. By the end of this course, you will know the essentials of automating Workbook functionality. This course will assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement. This certificate will enhance your employability in the relevant job market. Join now!  Learning Outcomes Understand the basic principles of data analysis with Excel Learn how to visualise data with Excel charts Build your expertise in using Pivot Tables and Charts Grasp the techniques of working with multiple Worksheets and Workbooks Know the process of automating Workbook functionality Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £99. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Research Assistant Researcher Business Analyst

In the digital age, the ability to interpret and predict data trends is paramount. Introducing 'Data Analysis and Forecasting in Excel', a comprehensive course tailored to unveil the intricacies of Excel's powerful tools. Dive deep into the world of worksheets, discover the magic of PivotTables, and unravel the secrets of data visualisation. Whether you're a novice eager to delve into data or a seasoned analyst looking to refine your skills, this course promises a transformative journey into the realm of Excel analytics. The curriculum is designed with the utmost care to ensure a holistic understanding. From the basics of modifying worksheets to the advanced techniques of forecasting data, every module is a step towards mastering Excel. With a focus on real-world applications, learners will be equipped to harness the potential of Excel, making data-driven decisions with confidence and precision. Visualisation is at the heart of understanding data. This course not only teaches you how to analyse data but also how to represent it effectively using charts, PivotCharts, and the innovative Sparklines. By the end of this course, you'll be adept at mapping data, automating workbook functionalities, and employing lookup functions with finesse. Learning Outcomes: Master the techniques of modifying and organising worksheets for optimal data representation. Understand and implement effective list management strategies within Excel. Analyse complex datasets and derive meaningful insights. Design and create compelling visual representations using charts and other visual tools. Efficiently utilise PivotTables and PivotCharts for advanced data analysis. Integrate and manage data across multiple worksheets and workbooks. Implement lookup functions and audit formulas to ensure data accuracy and integrity. Why buy this Data Analysis and Forecasting in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis and Forecasting in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis and Forecasting in Excel course for? Individuals keen on mastering Excel for data interpretation and visualisation. Business analysts aiming to enhance their data forecasting abilities. Students pursuing a career in data analytics or business intelligence. Managers and decision-makers seeking to make data-driven strategies. Researchers looking to streamline and enhance their data processing techniques. Career path Data Analyst: Average salary range £30,000 - £50,000 annually. Business Intelligence Analyst: Average salary range £35,000 - £55,000 annually. Market Research Analyst: Average salary range £27,000 - £45,000 annually. Financial Analyst: Average salary range £35,000 - £60,000 annually. Operations Research Analyst: Average salary range £40,000 - £65,000 annually. Management Analyst: Average salary range £45,000 - £70,000 annually. Prerequisites This Data Analysis and Forecasting in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis and Forecasting in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Course overview Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work. In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want. Learning outcomes Learn how to summaries data with Pivot Table Be able to add graphical representation to your summarized data with PivotChart Learn how to update the Pivot Table with new data Deepen your understanding of sorting and filtering Be able to import data from various sources with Power Query Gain an excellent understanding of Power Pivot Who is this course for? Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Enjoy better spreadsheet management and learn how to carry out everyday data-based tasks in Excel with expertise, with this complete Excel functions masterclass.  Through video guidance, the Simple but Powerful Functions in Microsoft Excel course will take you through the basic functions and features of Excel step-by-step. You will learn how to create pivot tables, use text formulas, search a value in a column, and carry out other typical spreadsheet tasks, gaining valuable office skills that will help you gain a competitive edge in your field. Are you looking to build your efficiency in Excel? Go from beginner to expert and build full proficiency in no time, by mastering Excel's core functions today. No previous experience is needed to take this course. Enrol as a full-time or part-time learner and add new skills to your CV. This best selling Simple but Powerful Functions in Microsoft Excel has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Simple but Powerful Functions in Microsoft Excel is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Simple but Powerful Functions in Microsoft Excel is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Simple but Powerful Functions in Microsoft Excel is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Simple but Powerful Functions in Microsoft Excel, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Simple but Powerful Functions in Microsoft Excel will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Simple but Powerful Functions in Microsoft Excel to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Overview With the ever-increasing demand for Data Analysis in Microsoft Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Data Analysis in Microsoft Excel may be. Learning about Data Analysis in Microsoft Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Data Analysis in Microsoft Excel . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Data Analysis in Microsoft Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Data Analysis in Microsoft Excel course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Data Analysis in Microsoft Excel course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Data Analysis in Microsoft Excel course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Data Analysis in Microsoft Excel , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Data Analysis in Microsoft Excel , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Data Analysis in Microsoft Excel , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Data Analysis in Microsoft Excel course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1_ Introduction to Microsoft Excel Introduction to Microsoft Excel 00:00 Module 2_ Data Visualization and Advanced Functions Data Visualization and Advanced Functions 00:00 Module 3_ PivotTables and Regression PivotTables and Regression 00:00 Module 4_ Time Series Analysis in Excel Time Series Analysis in Excel 00:00

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Full Excel Course Beginner to Advanced 6hrs