Interactive

Excel Office 365 (Windows): Managing Data

Skillsoft

Updated Aug 06, 2020

Excel offers a set of tools that allows you explore more in detail data analysis and complex formulae. If you need to work with data from other sources, you can import and edit data from a text and a .csv file. In this course you'll see how to use different formulae to make calculations when you have multiple conditions imposed. You'll also be able to forecast data using the NPER function. With complex formulae you can run calculations to discover the average numbers or the smallest or largest values depending on a settle of conditions, for example.

Related learning

Forecasting Data in Excel 2016: Determine Potential Outcomes Using Data TablesInteractive ⋅ 5 mins

Top Ten Tips: Data AnalysisCourse ⋅ 120 mins

Excel Office 365: Finding & Analyzing Information with FormulasInteractive ⋅ 38 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Skillsoft GLOBAL

Skillsoft is the global leader in corporate learning, providing the most engaging learner experience and high-quality content. Skillsoft are trusted by the world's leading organizations, including 65 percent of the Fortune 500. Skillsoft's mission is to build beautiful technology and engaging content that drives business impact for today's modern enterprise. Skillsoft provides a comprehensive selection of cloud-based corporate learning content, including courses, videos, books and other resources. Skillsoft's 500,000+ multi-modal courses, videos, authoritative content chapters and micro-learning modules are accessed more than 130 million times every month, in 160 countries and 29 languages. Via the Go1 Content Hub, you can access Skillsoft courses on topics including Business and Management Skills, Leadership Development, Digital Transformation, IT Skills and Certification Training, Productivity and Collaboration Tools and Compliance.