3505 Courses

Total SAGE Training (Sage 50 Accounts + Sage Payroll Training) Want to open the door to working in Finance and Accountancy Industry? Starting our Total Sage Training courses will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Total Sage Training courses are combined with Sage 50 Accounts and Sage Payroll Training. You will receive a CPD Completion Certificate from Osborne Training once you finish the course. You also have an Option to attain Certificate from SAGE(UK) subject to passing the exams. What qualification will I gain for Sage Training Courses? CERTIFICATION FROM SAGE (UK) As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Accounting Course (Level 1) Sage 50c Computerised Accounting Course (Level 2) Sage 50c Computerised Accounting Course (Level 3) Sage 50c Computerised Payroll Course (Level 1) Sage 50c Computerised Payroll Course (Level 2) Sage 50c Computerised Payroll Course (Level 3) Level 1 Working with Sage 50 Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials Bank Reconciliations Generating Customers Invoices Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Creating Customer Receipts & Purchase Invoices Supplier Payments Managing Recurring Entries Generating Reports & Information The Active Set-Up Wizard VAT Changes. Level 2 An overview of the Sage program Entering opening balances, preparing and printing a trial balance Creating customer records Creating supplier records Setting up opening assets, liabilities and capital balances, Producing routine reports Checking data, Entering supplier invoices Posting error corrections, amending records Invoicing, generating customer letters, entering new products, checking communication history Banking and payments, producing statements, petty cash Audit trails, correcting basic entry errors, reconciling debtors and creditors Creating sales credit notes, Processing purchase credit notes Preparing journals Verifying Audit Trail Purchase orders, processing sales orders Processing Trial Balance Creating Backups Restoring data Writing-off bad debts Level 3 Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Prepare and Produce Final Accounts Management Information Reports Making Decisions with Reports Using Sage The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

AAT Level 4 Professional Diploma in Accounting AAT Level 4 is the highest level or final stage of the AAT Accounting qualification. This qualification provides the skills necessary for a 'Finance Officer' role including the complex management accounting tasks, general management skills, drafting financial statements and specialist learning areas. This provides you with an opportunity to become a professional member of AAT and use MAAT after your name. You are also entitled to exemptions in the UK's chartered and certified accounting qualifications. Besides, if you want to pursue your career further in University, you are entitled to exemptions for up to two years in various universities in the UK. You will be awarded “AAT Level 4 Professional Diploma in Accounting certificate” from the Association of Accounting Technicians (AAT), once you have passed all the professional-level qualification exams and skill tests. Once you finish Level 4 you become a professional member of AAT and you may use MAAT after your name to stand out from the crowd as an officially Accredited Accountant. What you will gain? Here you'll learn how to draft financial statements for limited companies, perform complex management accounting tasks and develop your own management skills, perform tax calculation for business & individuals and other specialist learning areas. The Level 4 Professional Diploma in Accounting covers the following areas: Management Accounting: Budgeting Management Accounting: Decision and Control Financial Statements of Limited Companies Accounting Systems and Controls Business Tax Personal Tax

AAT Courses London AAT courses London campus offers Modern IT Lab, flexible timing and expert tutors. At Osborne Training London Canary Wharf campus, we offer various AAT courses to reach your dream career in accounting. AAT Level 2 Courses in London You can join evening, weekend or weekdays time for AAT Level 2 courses in London. We provide all books and study materials to ensure you are ready for aat level 2 exams. AAT Level 3 Courses in London You may join evening, weekend or weekdays training for AAT Level 3 courses in London. We provide all books and study materials for AAT Level 3 to ensure you are ready for aat level 3 exams and pass them first time. AAT Level 4 Courses in London You may join evening and weekend training sessions for AAT Level 4 courses in London. We provide all books and study materials for AAT Level 4 to ensure you are ready for aat level 4 exams and pass them first time. We also offer AAT Level 4 project support for students. AAT Evening Courses in London Our AAT evening courses mainly run between 6 pm to 9 pm. AAT evening courses in London are suitable for people who are working full time or have other commitments during daytime. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the evening. Our Canary Wharf campus is minutes away from the financial hub of London. AAT Weekend Courses in London Our AAT weekend courses mainly run on Saturdays daytime. AAT weekend courses in London are suitable for people who are working full time (Monday to Friday) or have other commitments during weekdays. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the weekend. Day Release AAT Courses London Our AAT day release courses in London mainly run on Wednesdays. AAT day release courses are suitable for people who can commit at least one day during weekdays. We offer AAT Level 2 and AAT Level 3 day release courses.

AAT Courses Online Live AAT online courses give you the opportunity to join live online classes. You can interact with your tutor and fellow students and enjoy a shared learning experience. Whilst you are studying, live classes are held regularly to provide you with the support and structure you would get from a traditional classroom environment, wherever you are. The classes are interactive and led by a expert course tutor. Students are able to ask questions in real-time, participate in polls and check their knowledge against their fellow students. You get access to ample study resources online. AAT Level 2 Online Courses When you study aat level 2 online courses, you get coursebooks and workbooks delivered to your home address. You also get access to VLC for additional learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. In addition, you would be given a schedule of live classes. AAT Level 3 Online Courses When you choose to study aat level 3 online courses, you get coursebooks and workbooks delivered to your home address. You also get access to VLC for additional learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. In addition, through your schedule of live classes you can keep yourself up to date with rest of the group. AAT Level 4 Online Courses With aat level 4 online courses, you get coursebooks and workbooks for your chosen subjects delivered to your home address. Through your access to VLC you can join live online classes. In addition, you get ample learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. through your VLC account.

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

Sage 50 Courses: Overview Starting our Sage 50 Accounting courses will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. In Addition, our courses are designed to comply with AAT and Sage certification exams. Why wait, start a new direction to your career in Accountancy. According to statistics, the average salary for Accountants is over £50,000 (Source: Reed Salary Checker). In this sector, the employability rate is higher than in any other sector. Professional or Industry specific qualification

Duration 2 Days 12 CPD hours This course is intended for Those who need to understand the financial implications of their day-to-day decisions to increase the profitability and performance of their business. This course is suitable for managers with little or no financial knowledge. Overview Understanding of financial accounts and reports The ability to use and understanding of financial concepts Analytical skills to interpret financial results using ratios Ability to manage budgets more effectively This course shows how to interpret key financial statements highlighting the questions and areas that matter. It identifies warning signals that managers need to be aware of and shows how to understand key performance indicators to drive profitability. The course will also cover the essentials of budgeting and forecasting as well as addressing key financial terms such as goodwill and accruals & prepayments. Delegates will learn how to appraise capital projects with confidence, allowing them to make the best decisions for their business. Course Outline The basics of finance: How companies are financially structured Accrual v cash accounting The Business Cycle: understand how money flows in a business How businesses are financed: debt and equity Business objectives: using financial data to achieve business targets Key Financial Statements: Income Statement Balance Sheet Cash Flow Statement Key Financial Analysis Ratios Profitability: profit margins, EBIT & EBITDA, operational gearing Return on Investment: ROCE, ROA Leverage: financial gearing & interest cover Liquidity: current & quick ratios Cash Flow: working capital requirement Working capital management Cash flow management Key financial terms ? goodwill, accruals & prepayments, depreciation and amortization Cost analysis, control and reduction Capex v Opex Effective Budgeting and Forecasting to control the business Management Accounts and undertaking variance analysis Improving margins and sales in your business Break even analysis Capital Investment techniques ? NPV, IRR and discounted cash flows Asset Valuation Additional course details: Nexus Humans Finance for Non-Finance Managers (2 Day) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Finance for Non-Finance Managers (2 Day) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: 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 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 Excel 2016 and VBA 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 Excel 2016 and VBA 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. Developing Macros 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 Formatting Worksheets Using Macros 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 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets 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 Performing Calculations 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 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

***24 Hour Limited Time Flash Sale*** Strategy for Management Consultants & Business Analysts - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the rapidly evolving UK business landscape, where over 5.9 million small businesses were operational at the start of 2024, the demand for proficient management consultants and business analysts has skyrocketed. How can businesses navigate through the complexities of strategic management, financial analysis, and digital marketing to stay ahead? Are you equipped with the necessary skills to drive business growth in an increasingly competitive market? Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Strategy for Management Consultants & Business Analysts bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Strategy for Management Consultants & Business Analysts Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Strategy for Management Consultants & Business Analysts Career Bundle: Course 01: Strategic Business Management Course 02: Business Productivity Training Course Course 03: Managing Budgets Course 04: Business Analysis Course 05: Xero Accounting Diploma Course 06: Online Bookkeeping and Quickbooks Course Course 07: Social Media Marketing for Your Business Course 08: Surviving Small Business in Pandemic & Recession Course 09: Business Law Course 10: Certificate in Purchasing and Procurement Course 11: Six Sigma & Lean Process Course 12: Financial Business Analysis Course 13: Sage 50 Training Course 14: Business Management Training Course 15: Business Process Management Course 16: Digital Marketing Diploma Level 3 Course 17: HR and Payroll Administrator Course Course 18: Supply Chain Management Course 19: Advanced Business Plan Course 20: Business Development & Sales Course 21: Successful Business Networking Skills Course Course 22: Office Skills Course 23: Strategic Planning Process Course 24: Crisis Management Course 25: Fundamentals of Stakeholder Management Course 26: Management Tools for Quality Control Course 27: Logistics & Operations Management - Level 5 Course 28: Business Etiquette & Professionalism Course 29: SAP Controlling (CO) - Product Costing with S4HANA Course 30: Business Intelligence | Basics of Data & Data Mining With Strategy for Management Consultants & Business Analysts, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes of Strategy for Management Consultants & Business Analysts Understand strategic business management and operational efficiency. Master budget management and financial analysis for business success. Gain proficiency in Xero Accounting and QuickBooks software. Learn effective social media marketing strategies for business growth. Navigate business law essentials for informed managerial decisions. Implement Six Sigma and Lean processes for operational improvement. Don't let this opportunity pass you by. Enrol in Strategy for Management Consultants & Business Analysts today and take the first step towards achieving your goals and dreams. Why buy this Strategy for Management Consultants & Business Analysts? Free CPD Accredited Certificate upon completion of Strategy for Management Consultants & Business Analysts Get a free student ID card with Strategy for Management Consultants & Business Analysts Lifetime access to the Strategy for Management Consultants & Business Analysts course materials Get instant access to this Strategy for Management Consultants & Business Analysts course Learn Strategy for Management Consultants & Business Analysts from anywhere in the world 24/7 tutor support with the Strategy for Management Consultants & Business Analysts course. Start your learning journey straightaway with our Strategy for Management Consultants & Business Analysts Training! Strategy for Management Consultants & Business Analysts premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Strategy for Management Consultants & Business Analysts is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Strategy for Management Consultants & Business Analysts course. After passing the Strategy for Management Consultants & Business Analysts exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Strategy for Management Consultants & Business Analysts course is ideal for: Students seeking mastery in Strategy for Management Consultants & Business Analysts Professionals seeking to enhance Strategy for Management Consultants & Business Analysts skills Individuals looking for a Strategy for Management Consultants & Business Analysts-related career. Anyone passionate about Strategy for Management Consultants & Business Analysts Requirements This Strategy for Management Consultants & Business Analysts doesn't require prior experience and is suitable for diverse learners. Career path This Strategy for Management Consultants & Business Analysts bundle will allow you to kickstart or take your career in the related sector to the next stage. Management Consultant Business Analyst Financial Advisor HR Manager Supply Chain Coordinator Digital Marketer Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type