5 (10)
Accounting and Finance Personal Development

Microsoft Excel in Accounting

Microsoft Excel in Accounting teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to sh...

Img

71 Lesson

Img

10hr 50min

Img

5 students enrolled

Microsoft Excel in Accounting teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Microsoft Excel in Accounting is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.
  • Accredited by CPD
  • Instant e-certificate
  • Fully online, interactive course with audio voiceover
  • Self-paced learning and laptop, tablet, smartphone-friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Sneak Peek

Who should take the course

Anyone with a knack for learning new skills can take this Microsoft Excel in Accounting. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this Microsoft Excel in Accounting, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Course Curriculum

The detailed curriculum outline of our Microsoft Excel in Accounting is as follows: Microsoft Excel in Accounting
  • Microsoft Excel 2019 New Features
  • Getting Started with Microsoft Office Excel
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Using PivotTables and PivotCharts
  • Working with Multiple Worksheets and Workbooks
  • Using Lookup Functions and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data
  • Forecasting Data
  • Excel Templates
Course Content
71 Lectures 10hr 50min
  • ImgIntroduction to Microsoft Excel 2019 New Features

  • ImgCONCAT

  • ImgIFS

  • ImgMAXIFS

  • ImgMINIFS

  • ImgSWITCH

  • ImgTEXTJOIN

  • ImgMap Chart

  • ImgFunnel Chart

  • ImgBetter Visuals

  • ImgPivot Table Enhancements

  • ImgPower Pivot Updates

  • ImgNavigate the Excel User Interface

  • ImgUse Excel Commands

  • ImgCreate and Save a Basic Workbook

  • ImgEnter Cell Data

  • ImgUse Excel Help

  • ImgCreate Worksheet Formulas

  • ImgInsert Functions

  • ImgReuse Formulas and Functions

  • ImgInsert, Delete, and Adjust Cells, Columns, and Rows

  • ImgSearch for and Replace Data

  • ImgUse Proofing and Research Tools

  • ImgApply Text Formats

  • ImgApply Number Format

  • ImgAlign Cell Contents

  • ImgApply Styles and Themes

  • ImgApply Basic Conditional Formatting

  • ImgCreate and Use Templates

  • ImgPreview and Print a Workbook

  • ImgSet Up the Page Layout

  • ImgConfigure Headers and Footers

  • ImgManage Worksheets

  • ImgManage Workbook and Worksheet Views

  • ImgManage Workbook Properties

  • ImgWork with Ranges

  • ImgUse Specialized Functions

  • ImgWork with Logical Functions

  • ImgWork with Date & Time Functions

  • ImgWork with Text Functions

  • ImgSort Data

  • ImgFilter Data

  • ImgQuery Data with Database Functions

  • ImgOutline and Subtotal Data

  • ImgApply Intermediate Conditional Formatting

  • ImgApply Advanced Conditional Formatting

  • ImgCreate Charts

  • ImgModify and Format Charts

  • ImgUse Advanced Chart Features

  • ImgCreate a PivotTable

  • ImgAnalyze PivotTable Data

  • ImgPresent Data with PivotCharts

  • ImgFilter Data by Using Timelines and Slicers

  • ImgUse Links and External References

  • ImgUse 3-D References

  • ImgConsolidate Data

  • ImgUse Lookup Functions

  • ImgTrace Cells

  • ImgWatch and Evaluate Formulas

  • ImgCollaborate on a Workbook

  • ImgProtect Worksheets and Workbooks

  • ImgApply Data Validation

  • ImgSearch for Invalid Data and Formulas with Errors

  • ImgWork with Macros

  • ImgDetermine Potential Outcomes Using Data Tables

  • ImgDetermine Potential Outcomes Using Scenarios

  • ImgUse the Goal Seek Feature

  • ImgForecasting Data Trends