3275 Accounting & Finance courses

Overview This comprehensive course on Create Website for Accounting Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Create Website for Accounting Business comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Create Website for Accounting Business. It is available to all students, of all academic backgrounds. Requirements Our Create Website for Accounting Business is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 3 sections • 21 lectures • 00:55:00 total length •Introduction: 00:01:00 •Importance of an Online Presence of an Accounting Firm: 00:03:00 •Multi-Page Accounting Website - Part 1: 00:03:00 •Multi-Page Accounting Website - Part 2: 00:02:00 •Single-Page Accounting Website: 00:03:00 •How to Build a Multi-Page Accounting Website Using WIX: 00:04:00 •How to Edit the Homepage of an Accounting Website: 00:06:00 •How to Edit the About Page, Service Page and Contact Page: 00:04:00 •How to Make an Accounting Website Mobile Friendly: 00:03:00 •A Brief View: 00:01:00 •Set Up Wix Editor: 00:02:00 •Dashboard - Part 1: 00:02:00 •Dashboard - Part 2: 00:03:00 •Edit the Header Part 1: 00:03:00 •Edit the Header Part 2: 00:03:00 •Edit the Hero Section: 00:03:00 •Edit the Services Section Part 1: 00:05:00 •Edit the Services Section Part 2: 00:02:00 •Edit the Contact Section and Footer: 00:01:00 •Mobile Version: 00:01:00 •Assignment -Create Website for Accounting Business: 00:00:00

Overview This comprehensive course on Content Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Content Management comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Content Management. It is available to all students, of all academic backgrounds. Requirements Our Content Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 02:55:00 total length •Introduction to Content Management: 00:13:00 •Content Management System (CMS): 00:27:00 •Basics of Content Management Systems: 00:26:00 •Content Strategy: 00:24:00 •Content Marketing: 00:25:00 •Content Marketing Tools and Tactics: 00:31:00 •Content Marketing Strategy: 00:29:00 •Assignment - Content Management: 00:00:00

Course overview Financial analysis is a crucial part of a successful business. It helps companies to make informed decisions regarding investing. Learn how to make a practical analysis of financial statements with this Financial Statement Analysis Masterclass program.  This Financial Statement Analysis Masterclass course explains the steps involved in a practical financial statement analysis in detail. It will also educate you on the importance of financial accounting in businesses. Going through the lesson, you will develop a comprehensive understanding of GAAP rules, correct timing, earnings management and financial valuation. In addition, you will understand the importance and purpose of executive compensation and identify its major components. You will also learn how to prepare and analyze a balance sheet and the steps to prepare a cash flow statement.  Learning outcomes Explore the steps to an effective financial analysis Understand the GAAP requirements for creating financial statements Deepen your understanding of earnings management Learn about applying ratios Deepen your understanding of owner's equity Know how to prepare a cash flow statement Who Is This Course For? This Financial Statement Analysis Masterclass course is highly beneficial for anyone interested in learning the steps for an effective financial statement analysis. In addition, the skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Financial Statement Analysis Masterclass Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Financial Analyst Financial Advisor Financial Planning Analysis Manager Financial and Management Accountant Introduction to the Course Introduction 00:02:00 Module 01: Why Analyse Financial Statements? Why Analyse Financial Statements? 00:10:00 Module 02: GAAP Rules GAAP Rules 00:10:00 Module 03: Correct Timing Correct Timing 00:15:00 Module 04: Earnings Management Earnings Management 00:11:00 Module 05: Balance Sheet Balance Sheet 00:11:00 Module 06: Balance Sheet Part-2 Balance Sheet Part-2 00:11:00 Module 07: Balance Sheet Part-3 Balance Sheet Part-3 00:07:00 Module 08: Statement of Cash Flow Statement of Cash Flow 00:07:00 Module 09: Time Series Time Series 00:11:00 Module 10: Ratios- Introduction Ratios- Introduction 00:16:00 Module 11: Applying Ratios Applying Ratios 00:19:00 Module 12: Valuation Valuation 00:14:00 Module 13: Credits Credits 00:07:00 Module 14: Contracts Contracts 00:10:00 Module 15: Executive Compensation Executive Compensation 00:12:00 Module 16: Lease Lease 00:08:00 Module 17: Owners' Equity Owners' Equity 00:07:00 Module 18: Earnings Per Share Earnings Per Share 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: QuickBooks 2008 is an accounting program which remains top notch for novices to expert users. It comes integrated and suitable for variety of industries. Intuit QuickBooks 2008 Foundation Training provides an overall outlook on the use of this software. In this course, you will learn about accounting basics which will help you get started with the software. After that, you will accustom yourself with lists, forms, registers which will help you with data entry. You will learn to add vendors, customers, sales receipts, setting up, tracking invoices, etc. This skills will build a foundation for mastering this program. Learning Outcomes: Performing basic transactions through setting up sales tax, opening check register, writing checks and much more Enter, view, search and pay bills; along with editing, deleting and voiding a bill Utilizing the loan manager by going through the preparation to add loans, viewing payment schedule and other relevant options Adding new inventory, checking inventory status, adjusting the quantity on hand and using build assemblies Customizing, creating, memorizing purchase orders and navigating through existing ones Finishing purchase orders by checking the spelling, using print preview, printing purchase order and using email options What to do when receiving inventory with or without bills, entering bills against inventory, backorders and closing purchase orders, and creating inventory worksheet Returning items to vendors, applying vendor credits, reimbursing expenses, and using vehicle mileage Creating new bank account in order to transfer funds, making non-customer deposits, and managing undeposited funds account Creating and funding petty cash, and tracking the expenses Understanding credit cards and QuickBooks, setting up credit card as liability account or as a vendor, entering charges, paying credit card, and reconciling them Utilizing online banking features by setting up online account in QuickBooks, and using it as a credit card merchant Using the report menu, opening report center and understanding it, choosing a category and opening pre-defined reports Choosing dates and columns, changing sort order, modifying the header and body for pre-defined reports Emailing, printing, exporting and memorizing the report Review some common reports such as trial balance, balance sheet, profit & loss and others Get report details through QuickZoom feature, accessing memorized reports, setting preferences, and using the learning center 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? Intuit QuickBooks 2008 Foundation Training 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 Intuit QuickBooks 2008 Foundation Training 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. Opening QuickBooks Pro 2008 01:00:00 Accounting Basics, Part One 01:00:00 Accounting Basics, Part Two 01:00:00 Getting Started with QuickBooks 01:00:00 Getting Help in QuickBooks 00:30:00 Lists, Forms, and Registers 00:30:00 Using the Chart of Accounts 00:30:00 Using the Journal 00:30:00 Adding Items and Services 01:00:00 Adding Vendors 00:30:00 Adding Customers 00:30:00 Adding Employees 00:30:00 Sales Receipts 00:30:00 Customer Payments 00:30:00 Finance Charges 01:00:00 Setting up Invoices 00:30:00 Finishing Invoices 00:30:00 Tracking Invoices 00:30:00 Issuing Credit Memos 01:00:00 Mock Exam Mock Exam- Intuit QuickBooks 2008 Foundation Training 00:20:00 Final Exam Final Exam- Intuit QuickBooks 2008 Foundation Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Microsoft Excel course is designed to teach you everything you need to know about Excel from scratch. This comprehensive, instructor-guided training will help you gain a thorough understanding of Excel’s essential features and functions, enabling you to kickstart your career or enhance your current skills. Whether you are just starting out or looking to build on your knowledge, this course will equip you with the most in-demand skills required in today's competitive job market.

Description: This Certified Information Systems Auditor (CISA) - Complete Video Course will provide you with the knowledge and proficiency to prepare for the globally recognized CISA certification exam. The CISA certification has become very popular since it originated in 1978, and is a benchmark for IS audit, security, control, and assurance personnel to validate your skill set. This course will immerse you into the subject, with in-depth coverage of the information covering the five domains that make up the 'Body of Knowledge' for the CISA exam and will provide you the tools to build your technical skills to develop, manage, and perform IT security audits. Being CISA-certified showcases your audit experience, skills and knowledge, and demonstrates you are capable to assess vulnerabilities, report on compliance and institute controls within the enterprise. So, enhance your career by earning CISA - world-renowned as the standard of achievement for those who audit, control, monitor and assess information technology and business system 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? Certified Information Systems Auditor (CISA) - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Certified Information Systems Auditor (CISA) - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. The Process of Auditing Information Systems Management of the Audit Function FREE 00:20:00 ISACA IT Audit and Assurance Standards and Guidelines 01:16:00 Risk Analysis 00:21:00 Internal Controls 00:17:00 Performing An IS Audit 01:07:00 Control Self-Assessment 00:09:00 The Evolving IS Audit Process 00:12:00 Governance and Management of IT Corporate Governance 00:06:00 IT Governance 00:02:00 IT Monitoring and Assurance Practices for Board and Senior Management 00:40:00 Information Systems Strategy 00:05:00 Maturity and Process Improvement Models 00:01:00 IT Investment and Allocation Practices 00:05:00 Policies and Procedures 00:17:00 Risk Management 00:31:00 IS Management Practices 00:50:00 IS Organizational Structure and Responsibilities 00:17:00 Auditing IT Governance Structure and Implementation 00:06:00 Business Continuity Planning 00:37:00 Information Systems Acquisition, Development and Implementation Business Realization 01:21:00 Project Management Structure 00:08:00 Project Management Practices 00:18:00 Business Application Development 00:42:00 Business Application Systems 00:38:00 Alternative Forms of Software Project Organization 00:03:00 Alternative Development Methods 00:10:00 Infrastructure Development/Acquisition Practices 00:09:00 Information Systems Maintenance Practices 00:09:00 System Development Tools And Productivity Aids 00:05:00 Business Process Reengineering And Process Change Projects 00:08:00 Application Controls 00:07:00 Auditing Application Controls 00:14:00 Auditing Systems Development, Acquisition And Maintenance 00:08:00 Information Systems Operations, Maintenance and Support Information Systems Operations 00:19:00 Information Systems Hardware 00:13:00 IS Architecture and Software 00:39:00 Network Infrastructure 01:16:00 Disaster Recovery Planning 00:19:00 Protection of Information Assets Importance Of Information Security 00:43:00 Logical Access 00:37:00 Network Infrastructure Security 00:39:00 Auditing Information Security Management Framework 00:03:00 Auditing Network Infrastructure Security 00:13:00 Environmental Exposures and Controls 00:02:00 Physical Access Exposures and Controls 00:05:00 Mobile Computing 00:05:00 Mock Exam Mock Exam- Certified Information Systems Auditor (CISA) - Complete Video Course 00:20:00 Final Exam Final Exam- Certified Information Systems Auditor (CISA) - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

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

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

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00