Training
Microsoft Excel – EssentialsBecome more effective in your reporting processes. Gain useful data manipulation skills!
Duration: 1 day | 6 hours
Available delivery methods:
Classroom
Become more effective in your reporting processes. Gain useful data manipulation skills!
Course Information
In this first course of the Microsoft Excel Skills, you will learn the essentials of Microsoft Excel. You will learn to smoothly navigate the Excel user interface, perform basic calculations with formulas and functions, formatting basics, professionally format spreadsheets, and useful shortcuts.
Key areas covered on the course include:
- Understanding the MS Excel environment
- Formatting basics
- Formatting, Borders
- Alignment Tools
- Format Painter
- Number Formats
- Styles and Themes
- Styles and Themes
- Keyboard Shortcuts, Terminology, and Ninja Tips
- Performing calculations
- SUM and AUTOSUM
- AVERAGE, MIN and MAX
- Absolute Cell References
- Calculations across sheets
- Working with Data
- Managing Rows and Columns
- Find and Replace
- Filtering & Sorting
Prerequisites
There are no formal prerequisites, but you should have some familiarity with computers and Windows 10.
What is Microsoft Excel?
Microsoft Excel is a spreadsheet program originally developed by Microsoft in the late 1980s. The industry standard spreadsheet for businesses all over the world, Excel allows the collection, processing and manipulation of data in a tabular format. Excel forms part of the Microsoft Office suite of software.
What’s included in this course?
1 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.
Learners taking this course are:
- Customer Care Reps
- Accountants
- Operations Analysts
- Financial Analysts
- Executive Assistants
What key skills will I gain in this course?
- Graphs
- Chart
- Sorting
- Microsoft Excel
Do you offer In-house corporate training?
We offer corporate trainings for a minimum number of 6 participant at your preferred venue.
Find out more
Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99
Interested in our training courses?
Get 20% off!
...on select training bundles.
Our Best Selling Courses
Microsoft Excel - Essentials
Become more effective in your reporting processes. Gain useful data manipulation skills!
Advanced Analysis & Visualization in Excel
Make the process of “Data to Decisions” efficient and cost effective.
Analytics for Finance Professionals in Excel
Drive productivity, efficiency, transparency and lower risk as a Finance professional.
Advanced PowerPoint
For professional, engaging in presentations that yield results.
Microsoft Excel - Intermediate
Become more effective in your reporting processes. Gain useful data manipulation skills!
Report Automation with Excel VBA/Macros
Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.
Microsoft Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
Microsoft Excel - Advanced
Connect, Integrate, Analyze and Visualize data like a pro!
Advanced Excel + Financial Modelling & Forecasting in Excel
Efficiently build an effective and robust financial model based on real-world financial modelling challenges.
Data Analysis & Visualization in Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
R for Data Science
Python for Data Science
