Advanced Excel

RKCLs Advanced Excel course (Code - RCAE) is tailored for individuals looking to deepen their expertise in Microsoft Excel (Microsoft 365 suite) and unlock its full potential for data analysis, reporting, and automation. This course goes beyond the basics, delving into advanced functions, complex formulas, data visualization techniques, PivotTables, & Macros. Whether you're a business professional, data analyst, or anyone who works extensively with spreadsheets, this course will equip you with the skills to handle complex tasks with ease, enhance your productivity, and make data-driven decisions. By the end of the course, you'll have a robust understanding of Excel's advanced features, enabling you to solve challenging problems and streamline your workflow.

Preview this course

1. Excel Fundamentals & Import data into workbooks

2. Navigate within workbooks & Modification

3. Format worksheets and workbooks & Data

4. Customize options and views

5. Configure content for collaboration

6. Manipulate data in worksheets

7. Format cells and ranges

8. Define and reference named ranges

9. Summarize data visually

10. Create and format/sort tables

11. Insert references

12. Calculate and transform data

13. Format and modify text

14. Create Charts & Advanced Charts

15. Modify charts

16. Format charts

17. Manage workbooks

18. Prepare workbooks for collaboration

19. Use and configure language options

20. Fill cells based on existing data

21. Format and validate data

22. Apply advanced conditional formatting and filtering

23. Perform logical operations in formulas

24. Look up data by using functions

25. Use advanced date and time functions

26. Perform data analysis

27. Troubleshoot formulas

28. Create and modify simple macros

29. Create and modify PivotTables & PivotCharts