2826 Accounting & Finance courses in Addlestone delivered On Demand

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Microsoft Excel is a powerful tool widely used to create and format spreadsheets, interpret and share data or information to make further accurate conclusions. Mastering Excel can be a valuable investment in both your personal and professional life. Taking this Microsoft Excel 2016 Intermediate course will help you create advanced workbooks and worksheets. Upon successful completion, you will be able to explain massive amounts of data and ensure actionable information from it. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification 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.

Businesses will always require sharp minds to navigate the intricate maze of regulations and predict potential threats. Acting as the watchdogs of an organisation,Compliance and Risk Management professionals ensure all procedures align with legislative standards and anticipate risks that could threaten business stability. According to UK statistics, there's a soaring 15% demand for experts in Compliance and Risk Management. In fact, the salary range lies between £40,000 to £100,000 per annum, depending on experience and roles. Our Compliance and Risk Management course dives deep into the fundamental topics of this discipline: from understanding the basics of compliance to the intricacies of compliance and risk management. With a Compliance and Risk Management comprehensive curriculum covering eight vital modules, including Compliance Audit, Ethics, and the Risk Management Process, our course offers a thorough theoretical grounding. By the end of your journey with us, you'll have a robust understanding, preparing you for a prosperous career in Compliance and Risk Management. Compliance and Risk Management Course Learning Outcomes: Master key concepts in Compliance and Risk Management. Comprehend Compliance's Five Essential Elements. Explore the intricacies of Compliance Management System (CMS). Decode the Compliance Audit methodology. Emphasise Ethics within Compliance and Risk Management frameworks. Identify diverse Risk categories in Compliance and Risk Management. Understand the Compliance and Risk Management procedural flow. Join today, be skilled, learn Compliance and Risk Management with positive energy and enthusiasm, create an excellent career using your full potential! Become the best in the Compliance and Risk Management business. Get Started Now. Upon completing this comprehensive Compliance and Risk Management course, you will be able to: Gain in-depth knowledge on what compliance is and the importance of compliance Get familiar with the five basic elements of compliance and processes Get introduced to Compliance Management System along with the elements of CMS Know the compliance audit in detail and acquire the skills to conduct a audit Explore the differences between ethics and compliance Be aware of what risk is and all the different types of risks Have a deep understanding of risk management, its objectives and concepts Gain intensive knowledge and skills to carry out a risk management process Diploma in Compliance and Risk Management Course Curriculum Course Curriculum : Module 1: Introduction to Compliance Module 2: Five Basic Elements of Compliance Module 3: Compliance Management System (CMS) Module 4: Compliance Audit Module 5: Compliance and Ethics Module 6: Risk and Types of Risk Module 7: Introduction to Risk Management Module 8: Risk Management Process CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Compliance and Risk Management. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a Employee Employer Manager Supervisor Entrepreneur Business Professional Company Leader HR Professional Requirements This Compliance and Risk Management course has no requirements. Career path This Compliance and Risk Management course will help you with the fundamentals of compliance and risk management. This course will provide all the essential competencies to explore a plethora of exciting work opportunities, such as - Consultant Officer Risk Manager Risk & Compliance Investigator These opportunities pay an average of £20,000 to £65,000 a year in the UK. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Navigating large datasets in Excel can feel like finding a needle in a haystack — until you’ve met Pivot Tables. This Pivot Tables Essentials Course breaks down the complexities and equips learners with the know-how to summarise, organise and interpret data with ease. Whether you're dealing with spreadsheets brimming with figures or just seeking a smarter way to report, this course offers a structured route to clarity using one of Excel’s most powerful tools. You’ll learn how to create, customise and fine-tune Pivot Tables to spot patterns, extract insights and make informed decisions. From filtering data like a pro to arranging fields for meaningful output, this course walks through the essential functions with purpose and precision. It’s ideal for professionals who spend more time than they'd like scrolling through spreadsheets — and prefer letting Excel do the heavy lifting. Ask ChatGPT Learning Outcomes: Gain a solid understanding of pivot tables and their capabilities. Learn how to create and format pivot tables in Excel. Discover how to sort and filter your data, and use the "show field values as" feature to analyze your data in different ways. Understand how to group and summarize your data using pivot tables. Learn how to create pivot charts to visualize your data, and use macros to automate repetitive tasks. The Pivot Tables Essentials course is designed to provide you with the skills and knowledge you need to master pivot tables in Excel. Whether you're a beginner or an experienced Excel user, this course is perfect for anyone who wants to take their data analysis skills to the next level. You'll learn how to create and format pivot tables, sort and filter your data, and use the "show field values as" feature to analyze your data in different ways. You'll also discover how to group and summarize your data, create pivot charts to visualise your data, and use macros to automate repetitive tasks and streamline your workflow. Pivot Tables Essentials Course Curriculum Section 01: Introduction Section 02: Axis and Formatting Section 03: Sorting and Filtering Section 04: Grouping and Analysis Section 05: Show Field Values As Section 06: Pivot Charts Section 07: Macro How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business professionals who work with data and want to analyze it more efficiently. Analysts who want to take their Excel skills to the next level. Entrepreneurs who want to analyze their business data more effectively. Students who want to enhance their Excel skills and prepare for a career in data analysis. Anyone who wants to develop their skills in data analysis and Excel. Career path Data Analyst: £24,000 - £45,000 Business Analyst: £26,000 - £50,000 Financial Analyst: £28,000 - £60,000 Management Consultant: £35,000 - £95,000 Chief Financial Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Excel isn’t just about cells and charts—it’s where numbers tell stories. This Excel Data Analysis (Microsoft Office) Course is designed for those who want to make sense of spreadsheets without staring blankly at endless rows. Whether you’re handling budgets, forecasts, or good old-fashioned reports, you’ll explore Excel’s powerful tools that help turn raw data into clear insights. VLOOKUPs, pivot tables, conditional formatting—yes, the good stuff is all here, and it’s less scary than it sounds. No fluff, just focused learning. This course cuts straight to what matters: using Excel as a decision-making companion. From sorting data like a spreadsheet whisperer to creating charts that even your boss might understand, the content is structured to be logical, easy to follow, and surprisingly enjoyable. Whether you’re in finance, admin, marketing, or somewhere in between, this is for anyone who’s had a spreadsheet say, “figure me out,” and needed the right nudge in the right direction. Learning Outcomes: Trace formulas and use Excel's Scenario Manager and Goal Seek Use Solver and Data Tables to analyse data Utilise Data Analysis Tools to draw insights from data sets Create forecasts with Excel's Forecast Sheet Understand popular formulas like Sumif, Countif, and If Apply advanced formula techniques like And, Or, and Nested If. Course Curriculum: Excel Data Analysis for Beginner Tracing Formulas Using the Scenario Manager Goal Seek Solver Data Tables Data Analysis Tools Forecast Sheet Sumif, Countif, Averageif, Sumifs, and Countifs formulas If, And, Or, and Nested If formulas How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst - £30,000 to £45,000 Financial Analyst - £35,000 to £55,000 Marketing Analyst - £25,000 to £40,000 Business Intelligence Analyst - £35,000 to £60,000 Sales Analyst - £25,000 to £40,000 Project Coordinator - £25,000 to £35,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Microsoft Excel is more than just rows and columns — it's a powerhouse for professionals who know how to make it work for them. This course zeroes in on four of Excel’s most essential lookup functions: VLOOKUP, XLOOKUP, MATCH, and INDEX. Whether you're reconciling data, building dynamic reports, or navigating large spreadsheets, these tools save time, reduce errors, and make you look like you actually enjoy spreadsheets — even if you don’t. You'll learn how each function behaves, when to use one over the other, and how to string them together to achieve powerful results. The course is designed for learners who want to use Excel efficiently, without getting buried in formulas that behave like they’ve had too much coffee. With clear explanations, useful examples, and a touch of logic that even your sleep-deprived Monday brain can follow, this course gets straight to the point. If you've ever stared at a dataset wondering where to begin, you're in the right place — no fluff, just formulas that do the heavy lifting. Learning Outcomes: Utilise Vlookup and Xlookup to retrieve data efficiently Understand how to use Match and Index functions Learn to compare and match large data sets Automate data processing and analysis Improve data accuracy and reliability Increase productivity and save time on manual calculations Course Curriculum: 1.1 Excel vlookup 1.2 Excel xlookup 1.3 Excel vlookup 1.4 Excel vlookup 1.5 Excel vlookup 1.6 Excel vlookup 1.7 Excel vlookup How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst (£26,000 - £45,000) Financial Analyst (£25,000 - £50,000) Business Analyst (£26,000 - £52,000) Accountant (£22,000 - £48,000) Operations Manager (£24,000 - £61,000) Project Manager (£29,000 - £65,000) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Diploma in Data Entry & Management will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Diploma in Data Entry & Management will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Diploma in Data Entry & Management and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Diploma in Data Entry & Management is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Diploma in Data Entry & Management. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Diploma in Data Entry & Management will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum **Data Entry And Management** Introduction to Data Entry 00:20:00 Data Management 00:20:00 Using the Computer for Data Entry 00:15:00 Common Rules and Guidelines for Data Entry 00:30:00 Using Excel for Efficient Data Entry 00:30:00 Using Excel's Flash Fill and Autofill to Automate Data Entry 00:30:00 How to Create a Data Entry Form in Excel? 00:45:00 Using Statistics Packages in Data Entry 00:45:00 **Basics Of MS Excel** Getting Started With Microsoft Office Excel 2016 Navigate the Excel User Interface 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 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 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 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Introduction is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Introduction is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:01:00 Section 01 What is Excel 00:04:00 Opening Excel 00:07:00 Navigating the Excel User Interface 00:10:00 Using the Excel Ribbon 00:07:00 Understanding Excel Worksheet Components 00:07:00 Using the Backstage View 00:09:00 Section 02 Creating a New Workbook 00:06:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using the Accessibility Checker 00:04:00 Section 03 Navigating a Worksheet by Mouse or Keyboard 00:05:00 Understanding Excel Data Types 00:06:00 Using the Inking Tools 00:06:00 Working with Cell and Range Addressing 00:03:00 Using various Data Selection Techniques 00:03:00 Working with Common Excel Commands 00:05:00 Using the Autofill Handle 00:04:00 Using Flash Fill 00:02:00 Section 04 What are Formulas and Functions 00:04:00 Understanding the Components of a Formula 00:06:00 Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Creating Basic Formulas 00:03:00 Working with Basic Functions and AutoSum 00:06:00 Using Cell References 00:05:00 Using the Quick Analysis Tools 00:03:00 Section 05 Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:04:00 Section 06 Formatting and Aligning Data 00:11:00 Merging Data 00:08:00 Wrapping Text and Adjusting Orientation 00:07:00 Formatting Numbers 00:08:00 Using Borders and Shading 00:07:00 Using the Format Painter 00:04:00 Removing Formatting Quickly 00:05:00 Section 07 Using Cell Styles 00:06:00 Applying Themes 00:04:00 Section 08 Inserting and Formatting Images 00:06:00 Inserting and Formatting Shapes 00:06:00 Inserting and Formatting SmartArt 00:09:00 Working with Icons 00:06:00 Working with 3-D Models 00:05:00 Inserting Screenshots 00:05:00 Inserting Hyperlinks 00:05:00 Inserting Symbols and Equations 00:05:00 Inserting WordArt and Text Boxes 00:08:00 Inserting Other Excel Objects 00:06:00 Arranging Objects 00:05:00 Section 09 Using Find and Replace 00:03:00 Using Go To and Go To Special 00:03:00 Using the Spell Checker 00:05:00 Using the Thesaurus and Translation Features 00:05:00 Section 10 Printing and Previewing Excel Files 00:05:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:05:00 Exporting to PDF and XPS 00:04:00 Section 11 Renaming and Coloring Worksheet Tabs 00:04:00 Adding, Deleting, and Navigating Worksheets 00:05:00 Section 12 Viewing Workbooks 00:05:00 Using Zoom Tools 00:02:00 Configuring Sheet Options 00:04:00 Using the Freeze Panes and Split Commands 00:06:00 Working with Window Commands 00:03:00 Adjusting Workbook Properties 00:06:00 Recap Recap 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00