396 Spreadsheet courses in Leicester delivered On Demand

Build essential insurance and risk knowledge with Excel, payroll, accounting, data entry, and data analysis courses. Insurance is built on numbers, and risk isn’t just about crystal balls and worst-case scenarios. This mini bundle gets to the point with five streamlined courses covering payroll, accounting, Excel, data entry, and foundational data analysis—keeping things sharp, organised, and to the point. Designed with the modern insurance desk in mind, this selection strengthens your grip on the tools that matter. Whether you're crunching claims figures or analysing trends in a spreadsheet, this is the bundle that knows risk isn’t risky when your data game is tight. No drama, no filler—just structured insight into key support functions behind risk and insurance roles. Learning Outcomes: Develop accurate payroll knowledge for insurance workplaces. Gain accounting insights relevant to insurance workflows. Understand how to manage data entry in risk settings. Improve Excel handling for risk and claims analysis. Apply structured data analysis to insurance processes. Learn digital functions that support insurance decisions. Who Is This Course For: Insurance assistants looking to enhance desk skills. Admin staff working in policy and claims teams. Entry-level data handlers in insurance offices. Team members using Excel daily in insurance settings. Payroll staff working in risk-sensitive roles. Account handlers needing back-end knowledge. Risk assistants aiming for confident data handling. Professionals brushing up on digital insurance support tools. Career Path (UK Average Salaries): Insurance Data Analyst – £32,000 per year Risk Administrator – £27,000 per year Claims Processor – £24,000 per year Payroll Coordinator – £28,000 per year Junior Accountant – £26,500 per year Excel and Reporting Clerk – £25,000 per year

Train for disability assessor roles with psychology, counselling, and learning disability-focused courses online. Assessing disability requires careful listening, clinical understanding, and more empathy than a spreadsheet can hold. This mini bundle includes psychology, learning disabilities, child psychology, counselling, and first aid—giving you a rounded introduction to the principles behind assessment work in health and care sectors. This is not about becoming an expert in diagnoses but learning the theory and perspective that underpin professional assessor roles. The focus is on observation, structured judgement, and understanding how conditions affect daily life. Whether you work in a related field or are preparing for a new opportunity, this course can help you approach your role with more confidence—and fewer question marks. Learning Outcomes: Understand basic psychological principles behind disability assessment. Identify characteristics of learning disabilities and cognitive challenges. Recognise child developmental concerns relevant to assessment work. Apply counselling strategies in sensitive assessment conversations. Respond appropriately to emergency situations with first aid knowledge. Use structured thinking to assess and record support needs. Who Is This Course For: Aspiring disability assessors across health and care sectors. Healthcare assistants involved in patient observations. Support workers assisting with care or disability needs. Mental health staff needing structured assessment knowledge. Carers seeking insight into learning disabilities. Those handling disability-related benefit assessments. Caseworkers supporting clients with cognitive impairments. Professionals working with families in care and welfare. Career Path (UK Average Salaries): Disability Assessor – £35,000 per year Support Worker – £23,000 per year Mental Health Assistant – £26,500 per year Counselling Assistant – £25,000 per year Learning Disability Officer – £29,000 per year Healthcare Assessor – £33,500 per year

Learn charity-focused accounting, finance, and problem-solving to strengthen your management and analysis skills online. Charity finance is a delicate balance of stewardship, accuracy, and calm problem-solving under pressure. This mini bundle brings together essential topics—accounting, financial analysis, business analysis, business management, and structured problem solving—all focused on the not-for-profit context. Whether you're overseeing budgets or handling funding reports, this bundle supports your role with clarity and purpose. It's ideal for those involved in running, supporting, or reporting within charitable organisations. From planning costs to responding to financial puzzles with a level head, this is where spreadsheet meets strategy—without any need for complicated jargon or beige PowerPoint slides. Learning Outcomes: Understand accounting principles for charity-related finance roles. Analyse financial data to support planning and decision-making. Evaluate charity business activities through structured analysis. Interpret financial reports in a management-led context. Identify and respond to financial and operational issues. Apply structured approaches to charity-focused problem solving. Who Is This Course For: Charity finance officers handling budgeting and expenditure. Admin staff supporting financial reporting within charities. Charity managers overseeing funding and financial planning. Support workers assisting with operational decision-making. Grant officers reviewing costs and funding allocations. Entry-level accountants within charitable organisations. Trustees or board members reviewing charity performance. Fund programme staff handling budgeting-related queries. Career Path (UK Average Salaries): Charity Accountant – £36,000 per year Financial Analyst (Charity) – £37,000 per year Business Analyst (Non-profit) – £38,000 per year Budget Officer – £32,000 per year Operations Coordinator (Charity) – £30,500 per year Programme Finance Officer – £34,000 per year

Confused by self assessment or VAT? Learn to handle tax returns, accounting, and reports online with this detailed training bundle. 🔹 Overview: The Self Assessment Tax Return Mini Bundle takes a focused look at the structure and reporting involved in personal tax declarations. You’ll study the principles behind tax returns, VAT rules, and how to organise everything through accounting and data visualisation software—without ever printing another spreadsheet. The courses in this bundle are built for individuals who want to make sense of numbers and deadlines, with added emphasis on financial analysis and digital reporting. From VAT calculation to Power BI charts that actually make sense, this bundle aims to turn tax confusion into organised clarity—one module at a time. 🔹 Learning Outcomes: Understand how to complete a self assessment tax return Analyse VAT data for personal and freelance tax planning Use Power BI to generate useful financial tax dashboards Apply accounting methods to individual tax records Gain financial insights through structured data interpretation Explore UK tax structure from income to VAT components 🔹 Who is this Course For: Individuals required to submit a self assessment each year Freelancers dealing with VAT and income tax submissions New accountants interested in personal tax reporting Business owners learning about tax return obligations Students studying tax reporting, VAT and analytics Budget-conscious individuals aiming to reduce tax errors Data-savvy users learning Power BI for tax analysis People managing their finances independently with structure 🔹 Career Path: VAT Analyst – £28,000–£36,000 per year Self Assessment Support Advisor – £24,000–£32,000 per year Finance Officer (Tax Focus) – £30,000–£40,000 per year Tax and VAT Assistant – £25,000–£34,000 per year BI Reporting Analyst (Finance) – £32,000–£45,000 per year Accounting Associate – £23,000–£30,000 per year

Stepping into the world of construction oversight requires more than just understanding bricks and mortar—it’s about knowing what makes a site tick, from budgets to blueprints. This course is designed specifically for surveyors and those interested in project estimation, construction standards, and managerial know-how. It offers structured insights into the planning, coordination, and financial breakdown of construction projects—making it a sharp pick for learners looking to explore the logic behind construction site decisions and development frameworks. With a well-laid foundation in estimation techniques, health and safety considerations, procurement strategies and construction regulations, this training brings clarity to an industry known for its complex layers. Whether you're reviewing quantities or forecasting project costs, the modules are laid out with precision—keeping things informative, digestible, and anything but dry. If your spreadsheet speaks louder than your toolkit, you’re definitely in the right place. Key Features of Construction Management, Standards & Estimation for Surveyors Bundle CPD Accredited Construction Management, Standards & Estimation for Surveyors Course Instant PDF certificate Fully online, interactive Construction Management, Standards & Estimation for Surveyorscourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Construction Management, Standards & Estimation for Surveyors Bundle course to excel! To become successful in your profession, you must have a specific set of Construction Management, Standards & Estimation for Surveyors skills to succeed in today's competitive world. In this in-depth Construction Management, Standards & Estimation for Surveyorstraining course, you will develop the most in-demand Construction Management, Standards & Estimation for Surveyors skills to kickstart your career, as well as upgrade your existing knowledge & skills. Construction Management, Standards & Estimation for Surveyors Curriculum Course 01: Construction Management Course 02: CDM - Construction Design and Management Course 03: Health and Safety Management for Construction (UK) Course 04: Construction Cost Estimation Using Xactimate Course 05: Construction Estimation using RSMeans Course 06: LEED V4: Building Design and Construction Course 07: Land Surveying and Cost Estimation Course 08: Quantity Surveying Course 09: Property Development Diploma Course 10: Level 5 CAD Designer Training Course 11: Manual Handling at Work Course 12: Working at Height Training Course 13: Working in Confined Spaces Training Accreditation This bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Construction Management, Standards & Estimation for Surveyors basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Construction Management, Standards & Estimation for Surveyors Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Organising chaos isn’t just a superpower—it’s an art form. Whether you're keeping a department afloat or overseeing multiple moving parts from behind the scenes, this Administrative Management CPD Accredited Bundle is the quiet hero your inbox has been crying out for. Designed to streamline your understanding of administrative strategy, structure, and systems, this 3-course collection doesn’t just tick off knowledge—it sharpens your thinking, your decision-making, and your ability to keep everything from turning into spreadsheet soup. From workflow to resource planning, communication control to executive support, this bundle covers the essentials of modern admin management without the fluff. It’s a digital deep-dive, not a desk-based daydream. So, whether you're climbing the ladder or simply trying to stop it wobbling beneath you, these online courses give you the structure and insight to take charge—without needing a filing cabinet or an in-tray the size of a small country. These comprehensive courses are available in this Administrative Management - CPD Accredited 3 Courses Bundle Course 01: Administrative Management Course 02: Organizational Leadership Course 03: Workplace Confidentiality ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Etiquette Module 04: Business Telephone Skills Module 05: Representing Your Boss and Company Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meeting and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Business Writing Skills Module 12: Organisational Skills Module 13: Communication Skills Module 14: Customer Service Module 15: Effective Planning and Scheduling Module 16: Invoicing/Petty Cash Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Administrative Management - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Administrative Management - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 45 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Administrative Management - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Administrative Management - CPD Accredited 3 Courses Bundle training.

Overview: Tired of browsing and searching for a Microsoft Office course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available to answer your queries on Microsoft Office Courses and help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in the Microsoft Office Course, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Microsoft Office Course Bundle Consists of the following Premium courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis for Beginner Course 15: Diploma in Excel Vlookup Xlookup Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and Tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Key Features of the Microsoft Office Course: FREE Microsoft Office CPD-accredited certificate Get a free student ID card with Microsoft Office training (£10 applicable for international delivery) Lifetime access to the Microsoft Office course materials The Microsoft Office program comes with 24/7 tutor support Get instant access to this Microsoft Office course Learn Microsoft Office training from anywhere in the world The Microsoft Office training is affordable and simple to understand The Microsoft Office training is an entirely online Enrol now in the Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning. Description The Microsoft Office bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Course expertise and essential knowledge, which will assist you in reaching your goal. Course 01: Microsoft Office Word Diploma Module 01: Getting Started with Word Module 02: Formatting Text and Paragraphs Module 03: Working More Efficiently Module 04: Managing Lists Module 05: Adding Tables Module 06: Inserting Graphic Objects Module 07: Controlling Page Appearance Module 08: Preparing to Publish a Document =========>>>>> And 19 More Courses <<<<<========= How will I get my Microsoft Office Certificate? After successfully completing the Microsoft Office course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £9.99*20 = £199.7) Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99) So, enrol now in this Microsoft Office Bundle to kickstart your career! Who is this course for? Anyone from any background can enrol in this Microsoft Office Bundle. Requirements Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets 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. Career Path Having this Microsoft Office expertise will increase the value of your CV and open you up to multiple job sectors.

Step confidently into office, administration, and junior management roles with the Excel Introduction Training Mini Bundle. Designed to equip you with sought-after skills in MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint, this bundle ensures you stand out as a versatile professional ready to handle essential business tasks. Employers across sectors—from corporate offices to small businesses—actively seek candidates with a strong command of MS Excel, effective Communication Skills, proficiency in MS Word, knowledge of Payroll, and polished presentation skills through MS PowerPoint. This bundle makes you their first choice. Description Today's jobs demand more than spreadsheet know-how. With MS Excel as your core skill, this bundle expands your capability to include effective written and verbal communication through Communication Skills, professional document creation with MS Word, payroll basics for HR or finance roles, and compelling presentations using MS PowerPoint. From managing data to engaging colleagues and clients, your profile will resonate with employers who want well-rounded candidates. The combination of MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint makes you the complete office professional. This is your chance to rise above the crowd with the right blend of technical and interpersonal skills. Don’t wait—hireability is just one bundle away. FAQ Q: What kinds of jobs is this bundle suited for? A: Entry-level admin, office assistant, HR support, junior management, and clerical roles requiring MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint. Q: How do Communication Skills fit in with technical training? A: Effective communication complements technical skills, making you more impactful in team and client interactions. Q: Is Payroll knowledge important here? A: Yes. Even basic payroll understanding is highly valued in HR and admin roles. Q: Does this bundle cover presentation skills? A: Absolutely. MS PowerPoint is included to ensure you can create professional presentations. Q: Will this improve my job prospects quickly? A: Yes. These skills are frequently listed as essential in job descriptions across many industries. Q: Is buying this bundle a cost-effective option? A: Definitely. You get MS Excel, Communication Skills, MS Word, Payroll, and MS PowerPoint training all in one affordable package.

Want to land interviews faster, impress employers instantly, and climb the ladder quicker? The Microsoft Office Specialist (MOS) Mini Bundle equips you with the digital essentials every office, agency, and department looks for. From MS Word and MS Excel to MS PowerPoint, Google DataStudio, and data entry—this is the digital fluency bundle that moves CVs from inbox to interview. Mastery of MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry isn’t optional anymore—it’s expected. This bundle arms you with the digital tools employers trust, from admin to analytics, presentation to planning. Job-ready, cost-effective, and career-focused. Description There’s no such thing as a “basic” office job anymore. Employers demand professionals who can wield MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry tools with ease and accuracy. The MOS Mini Bundle prepares you to meet that demand—and outshine the competition. MS Word gives you document dominance. MS Excel turns you into a spreadsheet strategist. MS PowerPoint lets you present like a pro. Google DataStudio empowers you with data visuals, while data entry precision proves you're fast, focused, and detail-oriented. Together, they make your CV impossible to overlook. Every admin, HR, finance, marketing, or analyst role expects MS Word, MS Excel, and MS PowerPoint proficiency. But throw in Google DataStudio and data entry experience? You’re not just qualified—you’re indispensable. Don’t let this opportunity expire while others land the jobs you deserve. Grab the MOS Mini Bundle now, and make yourself the candidate employers hope to find. FAQ Q: What kind of roles is this bundle suited for? A: Administrative Assistant, Office Manager, Data Analyst, Executive Assistant, Marketing Support, and more—any role requiring MS Word, MS Excel, MS PowerPoint, Google DataStudio, or data entry. Q: Is this bundle beginner-friendly? A: Yes. Even if you're starting fresh, this bundle helps you become confident in MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry. Q: Why is Google DataStudio included with Microsoft tools? A: It’s a popular cloud-based analytics platform, often used alongside MS Excel and MS PowerPoint in data-driven roles. Q: Will this help in remote and hybrid work? A: Absolutely. MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry are essential for digital communication and reporting in any environment. Q: Is it worth the investment? A: Yes—you're gaining professional fluency in five of the most commonly required digital skills for a single, budget-friendly price.

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports 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? Level 3 Diploma in Microsoft Excel 2016 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 Level 3 Diploma in Microsoft Excel 2016 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. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00